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(10962679,10962680,10962681,10962684,10962685,8630682,8574501,10849764,10872720,10872725,10872727,10872728,10872733,10872735,10872738,10872743,7075460,11040243,8559028,10973039,10973040,10973041,10942598,11036681,8627350,7198457,7198458,7198459,7198463,8625411,8625412,11007196,11007197,7196891,10838833,3234546,11047093,11047117,11047127,11047167,11047168,3234919,3234965,3234971,3234972,3234973,10852960,10852972,10991249,10991250,10991251,10991252,10991253,10991254,10991255,10991256,10991257,10991592,10562851,9914259,9205233,10126115,9179212,10463005,10463024,10467108,10467109,10463392,10463393,10463394,10463395,10467433,10463745,10463746,10465771,10465772,10463772,10465773,10465774,10465775,10465910,10464040,10466313,10466314,10466315,10466316,10466317,10466318,10462409,10462429,10462474,8848067,10466851,10888566,10628512,10628515,10628516,10628521,10628522,10628523,10628530,10628531,10889172,10889226,10628943,10167339,10167340,10167341,10167342,10897008,10626711,10602739,10547882,10547917,10547918,10547920,10547921,10528118,10528119,10528120,10528121,10528122,10528123,10528124,10528125,10528126,10528127,10528128,10528129,10528130,10528131,10528132,10528133,10546510,10546511,10546512,10423661,10423666,10423668,10423669,10423670,10423675,10423677,10423680,10423683,10505583,10407300) 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'