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(8630761,8630762,8630763,8630764,10870427,3228994,3228995,3229002,3229003,3229004,3229005,3229006,3229007,10862816,10862817,10862818,10862924,3230163,3230167,3230175,3230177,3230178,3230184,10863054,3230185,3230186,3230187,3230188,3230189,3230190,3230191,3230192,3230193,3227391,3227392,3227393,3227394,3227396,3227398,3227399,10939101,10939416,10858313,10858314,10858315,10858316,10858317,10858318,10858319,10858320,10858321,10858322,10858323,10858324,10858325,10858326,10858327,10858328,10858329,10858330,10858331,10858332,10858333,10858334,10858335,10858336,10858337,10858338,10858339,10858340,8628128,8628129,8628130,8628131,8628132,8628133,8628134,8628135,10859864,10859924,10859959,10859987,3227190,3237392,7198756,10864497,10864499,7200087,3233948,7197823,7197824,3235107,8624417,8541482,3230579,10615389,3231689,8611392,8611393,10616655,10614282,10119748,8851801,10613088,10610271,10613305,10613455,10610902,10515123,10515124,9169474,7015354,7015355,7015356,7015357,7015360,7015361,7015362,7015363,7015364,7015365,10118100,10118122,10118242,9912805,9912806,10416378,10416379,10416380,10416495,10417807,10417809,8550100,9168081,9168082,10627712,10167990,10168016,10604531,10508244,10508245,10508246,10498369,10498370,10422154,10414320,10414352,10414354,10414380,10414637,10414638,10412845,10412846,10412847,10412848,10412849,10412850,10412851,10412852,10412853,10412854,10412855,10412856,10412857,10412858,10412859,10412860,10412861,10412862,10412863,10412864,10412865,10412866,10412867,10412868,10412869,10412870,10412871,10412872,10412873,10412874) 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'