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(8628118,8628119,8628139,8628153,8628154,8628164,8628165,10859291,8628736,8628739,8628742,8628744,8628745,8628746,8628747,8628748,8628796,10860088,10860104,8629467,8625060,10856219,10856220,10857505,7198375,10855517,8633356,8634319,8634344,10862880,8632886,8632889,8583479,10614085,8853356,8851131,8851135,8851144,8851155,8851160,8851161,8851162,8851181,8851182,8851204,8851206,8851208,8851213,8851222,8851265,8851270,8851277,8851283,8851299,8851306,8851316,8851328,8851332,8851341,8851348,8851366,8851378,8851383,8851386,8851389,8851392,8851402,8851418,8851428,8851432,8851436,8851464,8851467,8851468,8851469,8851480,8851481,8851492,8851495,8851510,8851538,8851563,10612428,10613082,10613513,10613514,9911525,9912339,9912340,10118333,10118334,10118335,10118336,10118337,9178433,9912690,8850627,8850628,8850635,8850647,8850651,8850662,8850674,8850678,8850683,8850697,8850710,8850731,8850737,8850743,8850748,8850755,8850757,8850758,8850760,8850762,8850773,8850782,8850794,8850801,8850802,8850804,8850814,8850815,8850823,8850831,8850858,8850859,8850865,8850867,8850872,8850896,8850901,8850910,8850918,8850921,8850925,8850928,8850931,8850938,8850959,8850962,8850965,8850972,8850976,8850985,8851009,8851017,8851021,8851024,8851026,8851027,8851033,8851040,8851043,8851045,8851064,8851077,8851085,8851110,8851116,8851123,8851124,8851129,10416446,10418877,6673347,10888697,10884326,10884483,10889804,10880305,10627772,10886290,10886350,10886359,10886370,10611444,10611515,10611550,10611678,10611812,10603503,10603504,10603505,10603506,10508118,10508119,10412191,10414495,10410683) 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'