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(7200270,7200271,7200272,8067940,8595281,10838927,10813830,10813831,10813832,10813833,10813834,10813835,10813836,10813837,10813838,10813839,10813840,10813841,10813842,10813843,10813844,10813845,8906759,8906760,8906761,8906762,8906763,8906764,10426440,7155310,10623965,10616598,10616599,10616600,10616601,10616602,10616603,10616604,10616605,10616606,10616607,10616608,10616609,10616610,10616611,10616612,10616613,10616614,10616615,10616616,10616617,10616618,10616619,10616620,10616621,10616622,10616623,10616624,10616625,10616626,9169780,9169781,9169782,9169783,9169784,9169785,6674255,6674256,6674257,6674258,6674259,10118554,10118555,10613207,9913217,9913218,9913219,10418932,10418933,10418934,10418935,10418936,10418937,10418938,10418939,10418940,10418941,10418942,10418943,10418944,10418945,10418946,10471056,10471057,10471058,10471059,10471060,10471061,10714193,4970761,10162209,10674803,10674804,10674805,10674806,10674807,10674808,10674809,10674810,10674811,10674812,10670029,10647681) 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'