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(10861801,10861815,10861816,10849641,10849642,9216281,9216282,9216283,9216284,9216285,9216286,9216287,9216288,9216349,10858433,10858434,10858435,10858436,10858437,10858438,10858457,10858458,10858459,10858460,10858461,10858462,10858476,10858477,10858478,10858479,10858480,10858481,10858497,10858498,10858499,10858500,10858501,10858502,10858524,10858525,10858526,10858536,10858537,10858538,10843474,4967061,7202527,7202528,10868146,10865370,10865371,10865372,7200738,10856744,10856745,10864959,10864983,10864984,10857054,10928353,3581881,10714168,10614651,8851565,8851977,10610318,10610319,10613356,10613357,8852780,10610880,10118514,10418275,10418276,10415663,10115664,976485,10884301,10884489,10153870,10162054,10877373,10602353,10602354,10602355,10602356,10602357,10602358,10508550,10420750,10411661,10411662,10412968,10412969,10412970,10412971,10412972,10412973,10412991,10412992,10412993,10412994,10412995,10412996,10413011,10413012,10413013,10413014,10413015,10413016,10413031,10413032,10413033,10413034,10413035,10413036,10413058,10413059,10413060,10413072,10413073,10413074) 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'