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(10861476,10861477,10861871,10861999,10862081,7066170,10862502,10862527,10862585,8067925,10860438,10860530,10860540,10861072,8595127,10859895,7200286,10857402,7200467,3927721,3927722,10865864,8624646,7198307,10855515,7198727,10863886,7198958,7199089,7199165,7199315,7199316,7199331,10864790,7200099,10838890,7197411,10855166,8905039,8635059,8905706,8905853,8905939,10615016,10615147,10615249,3230997,10615815,8611430,10616720,10616789,10616794,10616795,10614138,10559298,10559305,10614413,10614879,10614918,10612652,8566628,8566688,8852147,8852148,10610471,8852691,10610723,10613903,9169782,9169785,10118125,6674199,10118283,9912369,8850087,8552183,9168319,9168320,10417326,9168589,10415806,10419036,10418113,10416138,10416166,8550012,10469554,10469649,10467703,10467819,10469854,10468518,10468552,10888838,10883942,10884569,10889690,10889692,10889693,10889694,10889695,10889696,10889851,10889939,10885085,10885086,10885175,10887577,10887908,10625077,10162087,10886184,10886196,10162240,10896288,10886364,10886373,10886384,10886426,10886597,10886659,10886676,10886718,10886719,10886731,10886734,10602144,10608625,10647271,10647568,10607517,10604518,10508263,10410349,10410681,10414811,10414822,10415086) 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'