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(9215026,10871154,10871155,10871156,10871157,10871158,10871159,8575152,8575153,8583517,8622209,8632202,8632203,8622459,8622462,8622463,8622464,7074632,8622469,7066882,10860312,10860313,10860314,10860315,10860339,10860361,10860399,10860441,10860453,10860519,10860525,10860533,10860535,10860583,10860584,10860585,10860789,10860801,10860802,10860803,10860804,10860805,10860806,10860807,10860808,10860817,10860823,10860827,7075912,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,7072072,8627794,10843100,10866660,10866661,10866662,10866663,10866664,8559386,8628340,8628401,8628402,10867258,10867259,10867260,10867261,7202396,10859491,10859498,10999917,10104395,10999958,11000034,11000035,11000036,11000037,11000038,11000064,10844182,10844183,8629484,8626652,8626653,8626679,8626680,10997832,10997833,7200578,7200606,10865693,10865694,10865695,7200780,10858031,10102876,10858094,8071696,8071761,8071826,7198394,8071891,8071956,10863537,10863549,8072021,10863616,10863617,10863618,10863625,10863626,10863627,8072086,8072151,7198678,7198681,7198684,7198685,7198696,7198697,7198698,7198699,7198700,7198701,7198712,7198713,7198724,7198725,8072216,7198727,7198730,7198731,7198733,7198736,7198739,7198748,7198749,7198752,7198757,7198763,7198764,7198766,7198782,7198783,8072281,10996276,10996281,10996301,10996302,7199009,7199010,10856103,10856104,10856105,10856106,10856107,10856228,10856229,10840912,8626082,8626083,8626320,8557822,7200129,10993665,10993666,3233699,4937302,4937370,8554623,4937435,10968422,10968457,10838528,4937500,8906888,8906889,8906892,4937565,4937630,3924315,4937695,4937760,4937825,4937890,4937955,10838993,4938020,11008221,7197814,7197820,10624632,10624633,10839429,10855037,8071564,8071631,10839674,10839677,10839678,10852265,10852266,10852267,10852268,8634673,8634676,11044801,8634776,8905263,10617328,10617356,10617357,10617358,10617359,10617360,8612190,10617428,10617429,3922910,8905662,8905719,10993409,10993410,8542364,8632769,8632770,8632773,10425582,3581898,3581902,3581907,10425910,8633404,8633405,8633406,8633408,8540530,8540852,8541008,3231990,3232023,3232024,3232025,3232047,3232097,3232327,3232336,8634579,10565155,10611037,8853209,8853215,8853231,7059608,6670026,6670028,10614496,10611521,10611526,10611571,6665998,3962374,9206288,10612104,10612105,7017836,7017837,8852019,9172211,9172212,9172214,9172215,9172216,9172218,9172219,9172226,10612909,10610065,6676764,10613391,10613394,9204759,10613434,10613547,9189014,10613899,10613900,10613901,10613906,10613907,10613917,9169317,10517143,10517144,6673541,10117645,10117646,8849322,7055725,989979,989982,9169941,9169961,990444,9912386,10118391,10118392,6674466,9912531,10118678,9912865,10516574,10516575,9186799,9186801,8552192,8552193,991414,991415,10516953,10516954,9913352,8848141,8848142,8848145,9192336,6672598,6672758,10419532,10419533,10419534,10419535,6672888,8848740,8848741,8848742,8848744,8848765,8848766,8848767,9168969,6681179,10418915,10418916,10418917,10418918,10418919,6681231,8848866,8848867,9169048,6673293,9193118,10417065,10417070,10417082,10420084,10420085,10420086,10420087,10417131,10417132,10417136,10417137,10417138,10469349,9166855,8550077,6679311,9191117,9191118,9191119,9191265,8916924,10123546,8847270,8563360,8847309,8847310,976357,8847476,8847477,8847478,8847480,8847495,8847496,8847568,10468326,8848010,8848036,8848037,8848038,9192232,9192235,9192242,9192249,9192252,10888553,10883562,10883593,10883597,10883628,10883661,10884042,10894378,10879888,10632012,10153992,10153993,10153994,10153995,10883045,10630070,10885772,10885957,10172196,10886285,10886286,10886287,10886288,10886319,10886320,10886321,10886322,10886323,10886324,10886361,10886368,10881537,10881538,10188047,10188049,10887097,10173122,10882127,10887225,10887229,10945213,10602168,10602176,10602177,10602190,10602191,10602196,10602730,10647518,10647535,10590811,10601574,10648973,10601930,10529424,10549734,10548299,10548300,10548301,10548302,10548303,10528521,10528522,10422688,10422689,10422690,10422691,10422692,10422693,10422694,10411227,10411228,10411229,10411230,10411316,10411317,8562839,10486569,10413948,10413955,10410251,10496940,10496980,10496982,10496987,10478004,10497034,10497036,10497042,10412615,10414650,10414651,10414653,10412675,10414679,10414686,10414701,10414732,10414738,10414805,10414809,10414815,10414817,10414829,10414830,10410952,10414982,10414983,10414984) 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'