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(8068807,7067831,10939561,10939575,10939581,8068885,8068886,7067943,10939738,10939747,10943669,10939882,10939885,10939905,10939907,10939915,10940010,10940011,10943814,10940166,4970861,4970862,4970863,4970864,4970865,4970866,4970867,4970868,4970869,7068533,4970870,4970871,4970872,4970873,4970874,4970875,4970876,4970877,4970878,4970879,4970880,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,10944065,4970891,4970892,4970939,4970944,4970945,10940324,10940325,10940326,7068612,10940327,10940328,10940329,10940330,4970970,4970972,4970973,4970974,4970975,7068664,7068707,7068708,7068709,7068710,10940465,4971128,8066938,8066939,10933358,10933359,7066017,8067199,8067299,10437347,10437353,10437354,10437355,10437356,10437357,10437358,8067481,10437359,10437406,7066518,10437497,8067691,7066691,8067808,7066757,7066778,7066849,7066850,7066858,7066868,7067004,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068026,8068027,8068028,8068029,8068030,8068031,8068032,8068033,8068034,8068035,8068036,8068037,8068038,8068039,8068040,8068041,8068042,8068043,8068044,8068045,8068046,8068047,8068048,8068049,8068050,8068051,8068052,8068053,8068054,8068055,8068056,8068057,8068058,8068059,8068060,8068061,8068062,8068063,8068064,7067168,7067198,7067218,7067244,7067260,7067261,7067615,7067618,7067668,7067669,7067670,7067687,7067688,7067767,8068789,7067810,7067811,7064075,7064079,7064080,7064081,7064082,7064083,10931771,10931848,8075287,10932013,10932016,10932017,10932018,10932019,10932068,10932069,10932107,4967027,8065967,8065981,8065982,8065983,8065984,10932355,10932356,7064936,8066069,10932493,10932494,10932495,7065154,10932617,10932625,10932634,8066268,8066269,8066270,8066271,8066272,8066273,8066274,8066275,8066276,8066277,8066278,10932648,8066279,8066280,8066281,8066282,8066283,8066284,10932654,8066285,10932661,10932674,10932676,10932684,10932692,10932876,10932904,10932980,10932981,10932982,10932984,10932985,10932986,10932987,10933038,4968072,4968073,10933212,10942543,10942592,10942600,10942698,8861049,10942916,8861140,10942966,10942967,8861202,10943051,8861313,10943157,10943174,10943178,10943182,10943184,8861383,8861389,8861390,10943227,10943229,8064653,8064654,8064655,8064656,5999930,8970238,10931198,10931199,6000083,6000091,10944389,10944469,10944471,3655681,3655682,10940708,10940709,10940710,10940711,10940712,10940713,10940714,10940715,10940716,10940717,10940718,3655797,3655820,3655821,10944679,10944693,10944745,10944759,10944849,10944918,10944927,3656108,8072304,10944993,8072648,8072649,8072650,8072651,8072652,3656629,8072809,8072810,8072811,8072812,8072813,8072814,8072815,8072816,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072825,8072826,8072827,10941689,8072828,8072829,8072830,8072831,8072832,3656703,8073016,8073017,8073018,8073019,8073020,8073021,3656889,3656890,3656901,8073096,10942063,10942064,8860265,8860266,10942107,10942150,10942151,8860383,10942212,10942213,10942268,10942278,10942279,10942280,10942281,10942282,8860618,10942517,10918475,10918476,10918477,10918478,10918479,10918480,10918481,10918482,10918483,10918484,10918485,10918486,10918487,10918488,10918489,10918496,10918497,10923576,10923577,10923578,10923579,10923587,10923588,10923589,10923590,10918604,10918605,10918606,10923623,10923624,10918719,10918730,10918787,10918789,10918790,10918791,10623291,10623292,10623293,10623294,10623295,10623313,10623403,10924028,10924029,10924030,10924031,10924032,10924033,10924034,10924035,10919189,10919190,10919222,10924325,10924326,10924327,10924328,10924329,10924330,10924331,10924332,10924333,10924334,10924335,10924336,10924337,10924338,10924339,10924340,10924341,10924342,10924343,10924344,10924345,10924346,10924347,10924348,10924349,10924350,10924351,10924352,10924353,10924354,10924355,10924356,10924357,10924358,10924359,10924360,10924361,10924362,10924363,10924364,10924365,10924366,10924367,10924368,10924369,10924370,10924371,10924372,10924373,10924374,10924375,10924376,10924377,10924378,10924379,10924380,10924381,10924382,10924383,10924384,10924385,10924386,10924387,10924388,10924575,10924576,10924577,10924578,10924579,8070826,8070827,8070828,8070829,10919818,10919819,10919820,10919821,8071020,10919822,10919823,10919824,8071022,10919825,10919826,10919827,10919828,10919829,10919830,10919836,8071096,8071097,8071098,8071100,8071101,8071102,8071104,10919954,10919955,10919956,10919957,10919958,10920012,10920013,10920014,10920015,10920016,10920017,8071308,8071309,8071326,8071342,8071354,10624667,10624841,10925372,10925373,10925450,10621982,10621983,10621984,10621985,10621987,10621988,10927538,10927539,10922539,10927540,10922540,10927541,10922541,10922542,10922543,10922555,10922562,10922565,10922568,10922576,10922577,10922578,10922605,10922640,10922641,10922642,10922643,10922644,10922645,10922646,10922647,10922648,10922649,10922650,10922651,10922652,10922653,10922654,10922655,10922656,10922657,10922658,10922659,10922660,10922661,10922662,10922663,10922664,10922665,10922666,10922667,10922685,10917694,10917695,10917696,10917697,10917698,10917699,10917700,10917701,10917702,10917703,10917704,10917705,10917706,10917707,10917708,10917709,10917710,10917711,10917712,10622270,10622271,10622272,10622273,10622274,10622275,10622276,10927908,10927931,10922954,10922955,10922956,10927966,10927976,10917992,10917993,10928026,10928028,10928092,10928162,10928185,10928248,10928249,10928250,10928251,10918272,10918273,10918274,10918275,10918276,10918303,10920692,10925720,10920847,10920848,10920849,10620346,10925863,10925878,10920954,10920955,10920956,10921057,10921058,10921059,10921060,10926100,10926142,10926151,10926158,10926159,10926183,10926205,10926266,10926268,10926330,10921333,10921402,10921403,10921636,10921666,10921668,10926693,10926694,10921695,10921696,10926697,10921697,10926711,10926712,10921720,10921721,10921722,10921723,10921724,10921725,10921726,10921727,10921728,10921729,10921730,10921731,10921732,10921733,10921734,10921735,10921736,10921737,10921738,10621265,10621266,10621267,10621268,10621269,10621270,10621271,10621272,10921874,10917006,10917038,10927058,10927081,10927082,10927200,10922208,10922209,10927244,10922270,10922271,10917441,10917442,10927448,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10611050,10611051,10559233,10611114,10611157,10565324,10565325,10565326,10565327,10614253,10559484,10559485,10559487,10559488,10559489,10559490,10559491,10614574,10614577,10614581,10614582,10614585,10614595,10559875,10559876,10559877,10559878,10559879,10559880,10559881,10559882,10559883,10559884,10559885,10559886,10559887,10559888,10559889,10559890,10559891,10559892,10614742,10559893,10559894,10559895,10559896,10559897,10559898,10559899,10559900,10559901,10559902,10559903,10559904,10559905,10559906,10559907,10559908,10559909,10611763,10614793,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611920,10611921,10566085,10566086,10566087,10566088,10566089,10566090,10566091,10566092,10566093,10566094,10566095,10566096,10566097,10566098,10566099,10566100,10566101,10566102,10566103,10566104,10566105,10566106,10566107,10566108,10566109,10566110,10566111,10611971,10563133,10563134,10563135,10612005,10612008,10612010,10612114,10612115,10612116,10563374,10563375,10563376,10609279,10609356,10609379,10563535,10563536,10609387,10612532,10612547,10612611,10612620,10610105,10613137,10610183,10610184,10610185,10610186,10610187,10610188,10564614,10564615,10564616,10564617,10564627,10564628,10564629,10564630,10564647,10564648,10564684,10564685,10564699,10564700,10564701,10564702,10564740,10564741,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10610694,10613745,10564992,10564993,10610941,10610958,10517220,10517221,10555289,10555290,10555291,10555292,10555293,10555294,10555295,10555296,10555297,10517525,10517560,10555796,10555797,10555798,10555943,10512118,10512119,10512120,10512663,10512808,10512809,10512815,10512832,10512833,10512838,10518845,10518846,10518847,10518848,10518849,10518850,10518851,10518852,10518853,10518854,10513042,10415288,10415289,10415290,10416553,10419668,10419669,10419670,10419686,10419689,10419690,10419691,10419692,10416720,10416721,10416722,10416723,10416724,10416725,10416726,10416727,10415803,10415851,10415852,10415853,10415854,10415970,10420067,10417088,10417089,10417090,10417091,10417092,10417093,10416126,10416127,10471482,10471483,10471484,10471485,10471486,10471493,10471494,10471495,10471499,10471500,10471501,10471502,10471503,10471505,10463694,8563268,8563280,8563463,10462715,10462716,10462717,10462718,10462719,10462720,10462721,10462722) 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'