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(7074369,8067552,8067553,10437570,10437571,10872854,8620659,8620660,8911165,8911166,8559753,8559754,8559755,8559756,10104077,10932973,10932974,10932975,11037215,11037216,11037217,11037218,11037219,11037220,11037221,11037222,11037223,11037224,11037225,3235826,3656393,3927257,3927258,3927259,8578016,8578017,9205379,9205380,9205381,9205382,9205383,9205384,9205385,9205386,10714441,10714442,10714443,8864795,976333,976334,10124795,10124796,10124797,10124798,10124799,10124800,8568923,8568924,9916960,8594480,8594486,10184338,10184339,10184340,10184341,10184342,10184343,10184344,10184345,10184346,10184347,10184348,10184349,10184350,10184351,10184352,10184353,10184354,10184355,10184356,10184357,10184358,10184359,10184360,10184361,10184362,10184363,10184364,10184365,10184366,10184367,10184368,10184369,10184370,10184371,10184372,10184373,10184374,10184375,10184376,10184377,10184378,10950150,10950151,10580406,10580407,10580408,10580409,10580410,10580411,10580412,10580413,10580414,10580415,10653458,10490719,10490720,10474089) 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'