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(10845739,10845789,10845838,10845839,8620970,10845898,10845910,10988956,10448284,8569461,8583090,10849196,7065968,8575146,8575147,8575148,8575156,10849340,7066160,7066383,10862695,8609594,8609666,10872123,10872321,10872334,10872429,8573334,10872460,10929590,10938951,7075832,10930105,10845612,10845658,10845659,11011635,11011666,11011873,11011879,11011880,11011920,8559208,8559235,8559300,11012106,10999125,7201689,8595117,8911594,8911613,3899078,8595248,10103774,10103908,8572128,10999671,7073147,8618988,8619040,8619045,10859643,7202667,10844176,7073628,8572836,7073740,7073861,7200405,10857453,7200468,8064522,7200792,10865869,10865870,11011340,10866015,10866016,8910830,11011508,11011514,11011548,6000169,8064891,8558866,10100097,10100103,8563765,7198376,3235558,3235559,8563884,10855464,3235636,3235648,3235649,8556315,3655984,3656002,3656003,8615270,3656050,8908587,8556533,11009339,11047603,10957423,10840900,11009920,10101418,10101564,10101565,10101566,3926982,3926983,3926984,10857098,10857099,8834361,7156548,3233489,3233490,3233491,3233492,3233493,10923789,10618300,10618301,10838109,3233798,10968217,10924078,10924149,10838601,10838655,10981720,10981721,10838829,11046781,7157676,7157677,7157678,7157679,7157680,7157681,7157682,7157683,7157684,7157685,7157686,7157687,7157688,7157689,7157690,7157691,7157692,7157693,7157694,7157695,7157696,7157697,7157698,7157699,7157700,7157701,7157702,7157703,7157704,7157705,7157706,7157707,7157708,7157709,7157710,7157711,7157712,7157713,7157714,7157715,7157716,7157717,7157718,7157719,7157720,7157721,7157722,7157723,7157724,7157725,7157726,7157727,7157728,7157729,7157730,7157731,7157732,7157733,7157734,7157735,7157736,7157737,7157738,7157739,7157740,7157741,7157742,7157743,7157744,7157745,7157746,7157747,7157748,7157749,7157750,7157751,7157752,7157753,7157754,7157755,7157756,7157757,7157758,7157759,7157760,7157761,7157762,7157763,7157764,7157765,7157766,7157767,7157768,7157769,7157770,7157771,7157772,7157773,7157774,7157775,7157776,7157777,7157778,7157779,7157781,7157782,7157783,7157784,7157785,7157786,7157787,7157788,7157789,7157790,7157791,7157792,7157793,7157794,7157795,7157796,7157797,7157798,7157799,7157800,7157801,7157802,7157803,7157804,7157805,7157806,7157807,7157808,7157809,7157810,7157811,7157812,7157813,7157814,7157815,7157816,7157817,7157818,7157819,7157820,7157821,7157822,7157823,7157824,7157825,7157826,7157827,7157828,7157829,7157830,7157831,7157832,7157833,7157834,7157835,7157836,7157837,7157838,7157839,7157840,7157841,7157842,7157843,7157844,7157845,7157846,7157847,7157848,7157849,7157850,7157851,7157852,7157853,7157854,7157855,7157856,7157857,7157858,7157859,7157860,7157861,7157862,7157863,7157864,7157865,7157866,7157867,7157868,7157869,7157870,7157871,7157872,7157873,7157874,7157875,7157876,7157877,7157878,7157879,7157880,7157881,7157882,7157883,7157884,7157885,7157886,7157887,7157888,3235027,3235351,10617040,8553043,10953986,8612681,11006551,11006552,11006553,11006554,8553848,10925538,10615217,8570226,8576444,8576445,8576446,8576447,8576448,8576449,8576450,8570266,10925842,10848087,10615435,10426211,7154414,7154415,7154416,9217643,9217659,8904265,8904266,8904271,10953105,10953136,10953142,8611360,8611368,10616579,10616657,8541145,10953322,10616797,8904947,8853130,10614013,8853190,10121670,9915701,10614200,6669913,6669919,6669921,6669922,6669923,6669924,6669925,6669926,6669927,6669928,6669929,10611410,10611415,10611416,10611425,10611426,10611542,10611700,8864616,6670315,8864662,8864695,9198202,9166213,8568718,8851183,8542665,8542680,8851355,9187530,8851358,8851359,3652834,8851454,8851455,8851483,8851485,9211681,10612363,8851549,8851551,10609457,9914120,7058552,7058553,7058616,9180654,9180661,10610431,10610450,10610456,8567402,8567403,8567404,8567405,8567406,8567407,10610930,8853103,10610948,10610952,8853116,6673997,6674033,6674034,6674037,6674042,6674044,6674045,6674049,6674052,6674053,6674054,6674055,6674057,6674062,6674063,6674072,9912210,8551503,8551513,10118440,9178335,10514502,8850632,8850633,8850636,8850637,8850720,8850738,8850739,8850740,8850742,8850743,8850746,8850747,8850748,8850749,8850761,8850763,8850764,8850771,8850873,8850874,9913260,9913261,8848134,8848136,8848137,9160319,9160320,9160331,9160334,9160335,8848164,10416302,8848208,8848209,6672763,6672764,6672765,6672768,6672769,6672792,6672793,8848428,8848429,8848434,8848435,6672880,6672886,6672887,9160843,6673278,6673279,6673281,6673288,10419039,9161137,4974015,4974078,4974079,4974080,4974081,10419169,10419170,10419171,10419177,7055442,3962832,10465148,8549744,8549793,9182671,8549881,6679318,6679319,8916779,8916787,10115589,9183441,9199451,9199452,9199453,6667580,6667581,976363,10123807,9199674,9199709,9199751,10468349,10124061,10124062,9199880,9199881,9199882,10116203,8917709,8917723,9168107,8551305,8847996,8847997,8847998,8847999,8848000,8848001,8848002,8848003,8848004,8848014,8848020,8848021,8848022,8848023,8848024,8848025,8848026,8848027,8848028,8848029,8848030,8848031,8848063,8848065,8848068,8917915,8848099,8848111,8848112,10883572,10883576,10883577,10883589,10883590,10883602,10883603,10883703,10883819,10883821,10883837,10159973,10884025,10884035,10884036,10884043,10884044,10884045,10884049,10884052,10884058,10904118,10628700,10628701,10884230,10947113,8594408,8594410,8594431,10628986,10884513,10889664,10629234,10629286,10629287,10629288,10629289,10629322,10889843,10889847,10629378,10889894,10874932,10875003,10880359,7000665,10887508,10912605,10912606,10912607,10912608,10912663,10632300,10153863,10887970,10888075,7001266,10888078,10888079,10888088,10888105,10888107,10888113,10888114,10888137,10888138,10888143,10888146,10946015,10888263,10630040,10630041,10176600,10176618,10630100,10176702,10176747,10176748,10176749,10875749,10171764,10176948,10177000,10177012,10177013,10177014,10177057,10177058,10177059,10177060,10177270,10886420,10625952,10167482,10625984,10912024,10912025,10912026,10912065,10912072,10912099,10912100,10877102,10877104,10912165,10912166,10912167,10912364,10601963,10601974,10601996,10602021,10602033,10602102,10602112,10602116,10602117,10602118,10602119,10602120,10602121,10602122,10602123,10602124,10602126,10602128,10602141,10602144,10602148,10602152,10602156,10602157,10602160,10602162,10602163,10602164,10602166,10602169,10602172,10602177,10602178,10602180,10602201,10602205,10602234,10602237,10643471,10652487,10643745,10652749,10652814,10652815,10652816,10652817,10589799,10589800,10652889,10649911,10644208,10566262,10603396,10647644,10606697,10606709,10651353,10604390,10601412,10601413,10607431,10567826,10567827,10567828,10601730,10601754,10601759,10601760,10601774,10601815,10601816,10601828,10601836,10601839,10601843,10601878,10601915,10601923,10601924,10601927,10601945,10601946,10527206,10534392,10526438,10534443,10534444,10534445,10534446,10534447,10534448,10534449,10534450,10534451,10534452,10534453,10546933,10546934,10546935,10546936,10546937,10546938,10423321,10423467,10423575,10486179,10483555,8562903,10411937,10486613,10486614,10414075,10412175,10492977,10493128,10493130,10493160,10493161,10493162,10493163,10493208,10497225,10497226,10497227,10497228,10497229,10497230,10497231,10497232,10497233,10497234,10497235,10497236,10497237,10497238,10497239,10497240,10497241,10497242,10497243,10497244,10497245,10497246,10497247,10497248,10497249,10497250,10497251,10497252,10497253,10497254,10497255,10497256,10497257,10497258,10497259,10497260,10497261,10497262,10497263,10497264,10497265,10497266,10497267,10497268,10493269,10497269,10497270,10497271,10497272,10497273,10497274,10497275,10497276,10497277,10497278,10497279,10497280,10497281,10497282,10497283,10497284,10497285,10497286,10497287,10497288,10497289,10497290,10497291,10497292,10497293,10497294,10497295,10497296,10497297,10497298,10497299,10497300,10497301,10497302,10497303,10497304,10497305,10497306) 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'