QUERY: SELECT p.products_id, p.products_model, p.label_ids, p.main_category, p.products_ean, p.products_fsk18, p.products_quantity, p.products_quantity_min, p.products_quantity_step, p.products_price, p.products_price_small_opt, p.products_price_opt, p.products_purchase_price, p.small_opt_purchase_price, p.count_small_opt_purchase_price, p.count_opt_purchase_price, p.opt_purchase_price, p.postavshik, p.suplier_catalog_id, p.postavshik_comment, p.name_catalog_id, p.products_tax_class_id, p.products_image, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_currency, p.products_page_url, p.video, p.show_video, pd.products_short_description, p.rev_total, p.rev_rating, pd.products_name, p.products_ordered, pd.products_short_description, s.status, IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price, m.manufacturers_name, m.manufacturers_id FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN specials AS s on p.products_id = s.products_id LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id) LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(3228605,10861723,10861724,10861725,10861726,10861727,10861728,10861729,10861730,10861731,10861732,10861733,10861734,10861735,10861736,10861737,10861738,10861823,10861824,10861825,10861827,3230170,3230171,3230173,3230175,3230176,3230194,3230195,3227390,10860292,10860293,10931546,10931547,8628136,8628137,8628138,8595194,8628337,8065804,10859936,10859937,10859938,10859939,10859940,10859941,10859942,10859943,10859944,10859945,10859946,10859947,10859948,10859949,10859950,10859951,10859952,10859953,10859954,10859955,10859956,10859957,10859969,10859970,10859971,10859972,10859973,10859974,10859975,10859976,10859977,10859978,10859979,10857373,10865792,10865793,10865794,10865795,10865796,10865797,10865798,10865799,10865800,10865801,10865802,10865803,10865804,10865805,10865806,10865807,10865808,10865809,10865810,10865811,10865812,10865813,10865814,10865815,10865816,10865817,10855463,10855464,10855465,10855466,10855467,10855468,10855469,10855470,10855471,10855472,10855473,10855474,10855475,10855476,10855477,10855478,10855479,10855480,10855481,10855482,10855483,10855484,10855485,10855486,10855487,10855488,10855489,10855490,10855491,10855492,10855493,10855494,10855495,10855496,10855497,10855498,10855499,10855500,10855501,10855502,10855503,10855504,10855505,10855506,10855507,10855508,10855509,10855510,7199184,7199185,7199186,7199187,7199188,7199189,7199190,7199191,7199192,7199193,7199194,7199195,7199196,7199197,7199198,7199199,7199200,7199201,7199202,7199203,7199204,7199205,7199206,7199207,7199208,7199209,7199210,7199211,7199212,7199213,7199214,7199215,10996699,10996700,10864498,10864500,8860329,8860445,8554296,8554297,10623605,10623606,10838791,10617068,3232382,8905863,8905864,10615077,10615079,8632710,10615536,10615540,10615543,10615720,10615821,10615923,10615925,10615926,10615927,10615931,10615941,10615943,10615944,10615945,10615947,10615981,10615983,10615984,10615985,10615987,10615990,10426372,10426373,10616577,7155250,7155251,10611232,10614463,10614464,10614519,10614520,10614521,10614522,10614523,10614524,10614525,10614526,10614527,10614528,10614529,10614530,10614531,10614532,10614533,10614534,10614535,10614536,10614537,10611725,10611788,10611801,10611802,10614858,10614859,10614862,10611879,10119650,10612284,10612285,10612286,10612342,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612426,10612427,10612428,10612429,10612430,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612500,10612502,10612503,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612529,10612531,10612534,10612535,10612536,10612538,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612562,10612563,10612565,10612566,10612567,10612573,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612620,10612622,10612623,10612624,10612625,10612626,10612633,10612635,10612637,10612638,10612639,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612650,10612651,10612653,10612655,10612657,10612658,10612659,10612660,10612661,10612663,10612664,10612666,10612667,10612668,10612673,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,8566537,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612716,10612717,10612718,10612720,10612721,10612722,10612723,10612753,8851935,8851936,8851937,8851938,8851939,10612791,10612792,10609818,10609819,10612824,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10612839,10612840,10612841,10612842,10612843,10612844,10612846,10612847,10612853,10612860,10612862,10612863,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612878,10612879,10612881,10612882,10612936,10612937,10612938,10612939,10612941,10612942,10609975,10609976,10609978,10609979,10609981,10613085,10613087,10613089,10613091,10613093,10610270,10610271,10610280,10610282,10610289,10613289,10610296,10613305,10610318,10610319,10610339,10610340,10610359,10610362,10610364,10610371,10610373,10610466,10610476,10610793,10610836,10610937,10610939,10610940,6673738,7015358,7015359,9911967,9911968,9169807,10118233,8850176,9912798,9912799,9912800,10415591,10415592,10415593,10415594,10415595,10415668,10415669,10415670,10415672,10417808,10417810,9168920,10418997,10418998,10418999,10419000,10419001,10419002,10419003,10419004,10419005,10419006,10419007,9169253,9169289,9169290,9169291,9169292,9169293,9169294,10469619,10469620,10469621,9167963,10889617,10889618,10889619,10889620,10889621,10889622,10889623,10889624,10887513,10887514,10887515,10887516,10887517,10887518,10887519,10887564,10887565,7000825,10883418,10883419,10883420,10883421,10883422,10883423,10883424,10883425,10161847,10162114,10162218,10887065,10887164,10887165,10604405,10604409,10604410,10604411,10604412,10604646,10604647,10604651,10604652,10607652,10604653,10604654,10604655,10604656,10604658,10604659,10604660,10604661,10604662,10604663,10604664,10604668,10604670,10604672,10604674,10604676,10604677,10604678,10604679,10604680,10604681,10604682,10604687,10604692,10604694,10604695,10604696,10604697,10607702,10604702,10604704,10508227,10507568,10507569,10507570,10507571,10496779,10412130,10412131,10414331,10414332,10414333,10414334,10414335,10414336,10414337,10414338,10414339,10414340,10414341,10414342,10414343,10414344,10414345,10414346,10414347,10414348,10414349,10414350,10414351,10414365,10414366,10414367,10414368,10414369,10414370,10414371,10414372,10414635,10414636,10410638,10410639,10410640,10410641,10410642,10410643,10410644,10410645,10410646,10410647,10410648,10410649,10410650,10410651,10410652,10410653,10410654,10410655,10410656,10410657,10410658,10410659,10410660,10410661,10410662,10410663,10410664,10410665,10410666,10410667,10410668,10410669,10410670,10410671,10410672,10410673,10410674,10410675,10410676,10474748,10474749,10474750,10474751,10474752,10474753,10474754) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'