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(10939825,9215018,10846125,10846129,7074061,7074116,7074118,7074124,7074125,7074135,8609567,11042432,10872649,8620329,8838056,8838057,8838058,8838059,8838070,8838071,8838072,8838138,8838139,8838167,8838220,8838225,10103449,8559510,10859195,8628883,8066492,8629208,8629209,4430432,4430438,4430451,4430454,4430455,11035590,11035591,11035592,11035593,11035594,11035595,11035596,11035597,11035598,11035599,11035600,11035601,11035602,11035603,11035604,11035605,8072768,8072769,8072770,8072771,8072772,10856333,11035742,11035743,11035789,11035790,11035791,11035826,11035838,11035840,10958381,10958382,10958383,10853914,4938472,4938473,4938474,4938475,4938476,8541666,10617383,10928265,8542281,10952258,10615845,10921772,10921773,10921774,10921779,10921812,10921944,10921945,10921946,8541231,3232194,10560514,9204592,9204601,9204602,9204617,9204618,9204708,8863513,8863514,10515263,8593083,9179104,9179105,9179106,9179107,9179108,6680918,6680921,10428495,10428500,10428502,9174880,9191877,10470504,10470530,10470531,10629949,10183639,10183640,10183641,10183642,10183656,10183657,10183686,10183687,10183722,10183754,10183816,10183848,10629980,10161787,10574558,10653241,10653242,10569476,10578524,10578534,10578698,10572854,10579105,10579106,10579107,10579108,10579109,10579110,10579162,10579163,10570215,10570216,10579268,10579269,10579270,10579271,10579272,10579326,10579327,10579328,10579329,10579391,10545578,10545579,10545580,10545643,10545644,10529685,10537706,10537743,10480944,10480945,10480946,10411393,10494269,10494275,10482095) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>