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,10930292,10930319,8574467,8574473,8574478,8630959,8574495,8574498,8630970,8630972,8630974,8631111,8631112,8631113,8631114,8631182,8631382,8631383,8631400,8631401,8631402,8631403,8631404,8631411,11041454,8631436,8631437,8631438,8631439,8631440,8631445,8631449,8631529,8631565,10933336,10849477,10849479,10849492,10849493,10849494,8631885,8631887,8631888,10871531,10871537,10871544,8631903,8631904,8631927,8631928,8631929,8631931,8631934,8631939,8631952,8631958,8631959,8631976,8631977,8631978,8631979,8631982,8631995,8631996,8632000,8632001,8632009,8632010,8632013,8632020,8632021,8632022,8632023,8632024,8632025,8632026,8632027,8632028,8632029,8632030,8632031,8632032,8632038,8632039,8632040,8632041,8632042,8632055,8632064,8632065,8632066,8632067,8632080,8632082,8632085,8632086,8632088,8632090,8632094,8632095,8632100,8632102,8632103,8632113,8632114,8632115,8632128,8632135,8632153,8632161,8632162,8632202,8632203,8632204,8632205,8632282,8632350,8632351,8609571,8609573,8632462,8632577,8629702,8629705,10872655,10872658,10869727,10869728,10872755,8620631,8627619,8627623,8627629,8627630,8627631,8627632,8627633,8627640,8627641,8627642,8627643,8627644,8627647,8627648,8627649,8627655,8627656,8627663,8627664,8627665,8627666,8627667,8627673,8627674,8627675,8627676,8627677,8627681,8627687,8627688,8627689,8627690,8627691,8627692,8627819,7201427,8627837,8627842,8627853,8627858,8627955,8627959,8627960,8627965,8627966,8627970,8627972,8627975,8627977,8627982,8911496,7201779,10858848,7201831,8628241,8628242,8628243,8628244,8628245,10866945,10866947,10866948,10866949,10843447,7202088,7202089,8628490,7202102,10103986,8628546,8628549,8628576,8628598,8628724,8628725,8628744,10960858,5654577,5654578,5654579,5654581,8629092,10932798,10932799,10932801,10932802,7202770,10932917,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629264,10859928,10859947,8629313,8629314,8629315,8629316,8629319,8629320,8629322,8616850,11036707,11036711,11036712,11036714,11036715,11036716,10997832,10997833,10997834,10865447,10865448,8626851,8626852,7200469,7200470,10865587,10959087,11037113,11037128,8627277,8627316,8627317,8627377,8627378,8627379,8627380,8627381,8627382,10959556,10959559,10959560,10959561,10959563,10959567,10866198,7201159,7201160,3235817,3235818,10855869,10856100,10856101,10856168,10856184,8625623,8625624,3236711,8625940,8625941,8625968,8625969,8626005,8626093,8626116,8565233,8565234,8565235,8565236,8626178,8626213,8626214,8626299,8626300,8626423,11010507,7157017,7196979,11046626,11046627,11046628,11046629,11046630,11046631,8907034,10838999,3234860,10619874,8624510,8624512,8624515,8624516,8624524,8624536,8624557,8624573,8541548,8634753,8634787,8634851,8634852,8634858,8634859,8634864,8634865,8634871,8634872,8634882,8634883,8634884,10852573,10852575,10852583,10852591,10852592,8634981,8634982,8634983,8634984,8634985,8634986,8634987,8634988,8634989,8634990,8634991,8634992,8634993,8634994,8634995,8635008,8635009,10622405,10617426,3232914,10853148,10951575,8632598,8632599,8632600,8632601,10951590,8632617,10425352,10425353,8632642,8632643,8632688,8632689,8632764,10425518,8632911,8632912,8632913,8632914,8632915,8632916,8632917,8632918,8632919,8632924,8632925,8632926,8632927,8632928,8632929,8632930,8632931,8632932,8632933,8632934,8632935,8632940,8632941,8632942,8632943,8632946,8632947,8632949,8632950,8632953,8632961,8632963,8632966,10615352,10850615,8632979,8632980,8632982,8632983,8632986,8632997,8632998,8632999,8633000,8633001,8633004,8633017,8633018,8633021,8633022,8633023,8633058,8633067,8633203,8633209,8633210,8633212,8633309,8633310,10952313,8633424,8633425,8633426,8633427,3582206,3582207,8633503,8633510,8633514,8633517,8633519,8633530,8633534,8633537,10616044,10616045,10616060,10616323,10616324,10616393,10616394,8634098,8634099,8634108,8634111,8634115,10922133,10922135,10922136,10922139,10616655,8577911,8577968,8577969,8634455,10852127,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10610964,9205324,9205341,9205343,9205346,9221440,9221456,10614203,10611416,10611417,10611443,10611450,10611451,10611452,10611455,10611457,10611517,10611560,10559722,10559723,10559724,10559725,10559726,10559743,10559744,10611646,10611830,9214198,8851259,8851278,8851279,8851442,8851443,8851446,8851449,8566586,10612987,10612988,10612989,8852344,8852345,8852346,8852347,10613191,10613192,8852356,8852357,8852358,8852359,8852360,8852361,8852362,8852376,10610233,9220574,9914820,7058800,7058801,10613311,10613475,10610677,8853095,8853096,10610954,8849330,10515327,10515328,10515329,8849429,10517670,4974715,4974716,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,4974730,4974731,4974732,4974733,4974739,8849751,10516123,10516124,10516125,10516126,10516127,10516193,8850507,9912943,8850837,8850840,10516928,9913359,8851098,8851100,8851109,10419307,10416432,6672770,6672774,6672794,6672805,6672806,6672808,6672866,6672867,6672868,6672869,6672883,6672893,10418736,10418737,10418819,6681111,10419829,10419831,10419832,10419833,6681146,6673162,8848829,8568847,8568851,8568864,8568865,8568866,8568871,8568910,8568911,8568912,9206743,10463769,8563204,9207335,10467918,10467919,10467920,10467921,10467922,10467923,10467924,10467925,10467926,8855259,8550974,8550975,8848036,8848046,10883569,10883570,10883571,10883629,10883665,10908682,10628321,10884173,10884174,10890006,10632207,10184013,10184014,10184015,10630024,10630060,10630170,10630240,10630241,10630242,10630273,10630274,10891313,10950079,10580257,10583440,10583441,10598770,10598808,10598842,10568937,10583937,10583941,10582565,10582571,10579778,10579779,10579780,10579781,10579809,10580000,10580001,10580002,10522165,10522166,10522167,10522174,10522175,10522176,10546477,10546482,10423614,10423618,10423693,10421785,10421786,10507677,10507678,10507679,10507680,10422997,10423003,10423010,10411281,10413381,10492444,10492445,10492446,10492487,10473697,10473698,10473699,10473700,10473701,10473702,10473703,10473704,10473705,10475757,10475758,10475809,10414323,10414335,10474001,10408775,10476460,10411019,10409028,10409031,10409038,10409046,10409047,10407064,10407067,10407078,10407079) 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'