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(8561991,10861439,10861440,8583199,8569869,10846756,8631662,8631719,8631721,8631725,8631728,10871831,10862977,7075424,10870089,8630482,8630483,10866385,8594760,10866809,8075293,8628266,8628269,8628270,8628272,8628273,8595296,8065853,3899391,8628658,8628735,8628736,8628749,10868115,8626585,8626586,8626587,8626588,3927538,3927539,7200682,10943221,10866113,10866131,10866134,10855584,8625146,8625430,8625971,11010445,11010446,8626543,8626544,7200173,11007159,3923923,8907102,8907104,8624333,8624340,8624341,8624342,8624343,8624344,8624497,8624512,10617128,10617129,10617130,10617131,10617132,10617133,10954007,10954008,10954009,10954010,10837164,8612498,8576210,9217146,9217147,10965294,9217742,8634008,8540886,10562342,10562343,10562344,10562345,10562346,10562347,9214163,6676015,6676028,9212309,9212310,9212311,9212313,9196451,9196460,9196464,10558473,10558474,10558475,10558476,10558477,10558510,10558511,10558512,10558513,10558514,10558515,10558516,10558517,10558518,10558519,10558520,10558521,10558522,10558523,10558524,10558525,10558526,10558527,10558528,10558529,10558530,10558531,10558532,10558533,10558534,10558535,10558536,8853017,10117845,8849522,10515725,10515727,10515820,10515823,10415375,10415376,10419386,10416542,10419674,6670769,10116150,10890023,10877114,10877115,10877116,10877117,10601174,10601230,10601231,10653403,10567320,10601053,10601054,10601055,10601056,10601057,10601085,10601086,10601087,10601088,10553763,10553764,10553765,10553766,10553767,10553768,10553769,10553770,10520811,10508142,10507485,10507486,10507495,10420724,10421988,10423135,10508099,10508100,10410748) 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'