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(9214653,8630690,8630738,8630740,8630743,8630744,8630745,8630913,8630914,8630916,8630919,8631024,8631025,8631026,8631027,8631028,8631029,8631069,8631070,8631072,8631074,8631075,8631077,8631079,10870734,10870735,10870736,10870737,10870738,10870739,10870740,10870741,10870744,8569453,8631125,8631126,8631130,8631131,8631133,4970738,8631188,8631190,8631191,8631254,10871052,8631471,8631472,8631473,8631474,8631475,8631476,8631477,8631478,8631479,8631480,8631481,8631482,8631496,10950485,8631506,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,9215621,8631622,8631623,8631624,8631625,8631626,8631677,8631678,8631679,8631711,8631716,10849374,8631807,8631846,8631849,8631852,8631854,8631867,8631900,10849680,10849681,10849684,8575658,8575659,8575733,8575734,8575735,10437503,8632508,8632510,8632512,8632513,8632517,8632519,8632522,8632523,8632528,8632530,8632537,8632538,8632575,8629639,8629643,8629746,8629747,8629748,8629754,8629755,8629756,10844866,8629765,8629834,8629838,8629856,8629890,8629913,8629917,8629927,8629930,8629932,8629937,8629938,8629947,8629958,8630177,8630294,8630324,8630357,8630406,8630435,8630453,8630454,8630455,9214492,9214504,8627581,8627582,8627583,8627596,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,7201335,7201336,8627907,8627909,8627910,7201632,7201633,7201634,8628118,8628119,8628120,7201727,7201728,7201729,8628135,8628136,8628137,8628138,8628139,8628153,8628154,8628156,8628158,7201761,8628164,8628166,8628176,8628180,8628216,8628217,8628218,8628257,8628258,8628259,8628261,8628263,8628264,8628265,7201905,7201906,8628340,8628341,8628342,3899204,7201977,8628395,8628396,8618687,8618743,8628570,8628571,8628576,8628582,8628585,8628588,8628589,8628590,8628597,8628598,8628600,8628608,8628613,8628614,8628615,8628622,8628623,8628632,8628633,8628634,8628643,8628644,8628645,8628646,8628647,8628648,8628649,8628652,8628653,8628677,8628683,8628687,8628689,8628693,8628706,8628721,8628722,8628723,8628729,8628730,8628796,8628816,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,8628826,8628827,8628828,8628829,8628830,8628831,8628832,8628833,8628834,8628835,7202439,8628880,8628881,8628882,8628883,8628884,8628885,8628886,8628887,8628888,8628902,8628903,8628904,8629101,8629102,8629103,8629104,8629107,8629166,8629188,8629235,8629236,8629256,8629270,8629271,8629310,8629375,8629378,8629379,8629380,8629381,8629413,8629415,8572971,10868151,10868152,10868153,10868154,10868155,10868156,10868157,10868158,10868159,10868160,10868161,10868162,10868163,10868164,10868165,10868166,10868167,10868168,8629553,8629554,8626627,8626643,8626654,8626664,8626711,8626727,8626728,8626729,8626730,8626731,8626732,8626733,8626734,8626735,8626736,8626737,8626738,8626739,8626740,10997793,10997794,8626771,8626803,8626804,3927619,8626884,10958987,10958988,10958989,7200636,7200637,7200640,7200641,8627085,10985137,3927847,7200807,7200817,7200847,3238029,7200861,7200869,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627574,8627575,8627576,8627577,8627578,8627579,8627580,3925334,8624589,3925337,10839700,8624593,8624612,8624749,8624750,8624751,8624752,8624753,8624786,8624787,8624788,8624789,8624790,8624791,8624944,8624945,8624961,8624985,8625025,8625055,8625058,8625059,8625079,8625080,8625081,7198697,8625106,7198711,7198714,7198716,7198719,8625146,8625165,8625178,8625179,8625183,8625184,8625185,8625186,8625191,8625192,8625193,8625194,8625195,8625196,8625200,8625201,8625259,8625296,8625305,8625306,8625309,8625312,8625315,8625337,8625356,8625397,8625398,8625486,8625575,8625576,8625621,8625622,8625623,8625624,8625625,8625626,8625628,8625629,8625630,8625631,8625632,8625633,8625634,8625635,8625636,8625637,8625638,8625639,8625640,8625641,8625642,8625643,8625644,8625645,8625646,8625647,8625648,8625649,8625650,8625651,8625652,8625653,8625654,8625655,8625656,8625657,8625658,8625659,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625667,8625668,8625669,8625670,8625671,8625672,8625673,8625674,8625675,8625676,8625677,8625678,8625679,8625680,8625681,8625682,8625683,8625684,8625685,8625686,8625687,8625688,8625689,8625690,8625691,7199402,7199403,10101477,10101492,8565097,8626072,8626074,10101564,10101565,10101566,8626089,8626090,8626091,8626092,8626093,8626094,8626095,8626201,8626202,8626203,8626206,8626207,8626208,8626213,8626214,8626215,8626216,8626217,8626218,8626225,8626228,8626246,8626247,8626248,8626249,8626250,8626251,8626252,8626253,8626254,8626255,8626256,8626257,8626378,3233390,11045714,11045715,11045716,7196307,7196316,7196317,7196337,7196508,7196512,7196516,7196527,7196890,7196891,7196892,3234123,3924356,10838967,10839048,8907434,8907435,10839142,8624318,8624319,8624326,8624327,8624328,8624329,8624330,8624331,8624332,8624333,8624334,8624335,8624336,8624337,8624338,8624339,8624345,8624346,8624380,3235171,8624410,8624415,8624416,8624417,8624418,8624441,10619864,10619865,10619895,10619896,8624525,3925290,3925324,8634615,8634616,8634617,8634688,8634689,8634690,8634691,8634692,8634693,11044800,11044801,10617329,10953995,10617448,8612272,3232902,3232903,10954313,3923187,10853107,8632605,8632606,8632647,8632716,8632717,8632718,8632754,8632756,8632759,8632760,8632764,3230564,3230566,10620183,8632830,8632831,8632832,8632833,8632834,8632835,8632836,8632837,8632838,8632839,8632840,8632841,10615222,8632842,8632843,8632844,8632891,8632892,8632893,8632908,8632909,8632910,10951941,8576528,8633103,8633105,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,8633216,8633217,8633218,8633219,8633220,8633221,8633222,8633223,8633224,8633225,8633226,8633227,8633228,8633229,8633230,8633231,8633232,8633233,8633234,8633235,8633236,8633237,8633238,8633239,8633240,8633241,8633252,8633254,10848385,10848386,8633292,8633309,8633312,8633314,8633315,8633316,8633317,8633318,8633319,8633320,8633325,10848519,10965470,8633449,8633450,8633451,8633452,8633453,8633454,8633455,8633456,8633457,8633458,8633459,8633460,8633461,8633462,8633463,8633464,8633465,8633466,8633467,8633468,8633469,8633470,8633471,8633472,8633474,8633475,8633476,8633477,8633478,8633479,8633480,8633482,8633483,8633484,8633485,8633486,8633488,8633489,8633490,8633491,8633492,8633542,8633545,8633576,10616005,10616033,10621034,10621036,10621037,10621038,10621041,8540543,8540566,8540567,8540589,8540591,8633754,8633765,8633780,8633793,8633797,8633831,8633837,8633865,8633871,8633886,8633892,8633907,8633913,8633932,8634139,8634147,8634148,8634149,8541017,10616553,8634177,8634406,8634407,8634420,8634422,8634424,8634428,8634429,8634434,8634435,8634448,8634574,10562767,6666259,9214288,9211688,8851658,9211948,8566586,8566588,8566635,8566639,8566643,8566651,8566652,8566653,8566655,8566665,8566744,9212309,9212310,9212311,10609988,10610030,9220473,10613306,9197129,9169475,10515327,10517614,10517615,10517616,10517617,10517618,9169959,8565537,8565538,9913294,4973244,4973903,9193226,9193255,8855351,9191534,10893950,10893983,10893986,10893990,10884653,10626963,10632106,10632107,10632108,10632109,10632110,10632166,7000890,7000891,10627319,7001145,10161923,10161924,10161926,10161927,10161928,10626144,10631885,10601174,10583441,10608654,10598808,10598832,10598841,10608857,10590278,10566666,10566667,10566668,10604037,10604038,10604039,10604040,10604041,10604082,10525567,10537758,10537759,10551823,10522256,10522257,10522260,10550993,10499116,10499117,10499118,10499119,10499120,10499121,10499122,10499123,10499124,10422372,10422373,10422374,10422375,10422376,10422377,10422378,10422379,10422382,10508322,10508323,10508324,10508325,10508326,10422599,10508593,10508594,10508595,10508596,10508597,10508598,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10420768,10420769,10506820,10506821,10506822,10506824,10424998,10507920,10507921,10407228,10407229,10407232,10486561,10486562,10486563,10486564,10486565,10486566,10486567,10486568,10486569,10486570,10486571,10487109,10487110,10487111,10487112,10406981) 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'