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(3229079,3229169,7066050,7074666,10859809,10859810,10859811,10859812,10859813,10859814,10859815,10859816,10859817,10859818,10859819,10859820,10859821,10859822,10859823,10859824,10859825,10859826,10859827,10859828,10859829,10859830,10859831,10859832,10859833,10859834,10859835,10859836,10859837,10859838,10859839,10859840,10859841,10859842,10859843,10859844,10859845,10859846,10859847,10859848,10859849,10859850,10859851,10859852,10859853,10859854,10859855,10859856,10859857,10859858,10859859,10859860,10859861,10859862,10859863,10859864,10859865,8626821,8626822,8626823,8626824,8626825,8626826,8910243,8910244,8910245,8910246,8910652,7069277,7069279,10863836,10863838,8860371,8860372,8860373,7155286,7017409,7017410,7017411,7017412,7017413,7017414,8862528,8851931,8851932,10613055,10118047,10417286,10417288,9168791,10888632,10888633,10888634,10888635,10887714,10885508,10885509,10885510,10885511,10885512,10162029,10654265,10507987,10507997,10414223,10414224,10414225,10414226,10414227,10414228,10414229,10414230,10414231,10414232,10414233,10414234,10414235,10414236,10414237,10414238,10414239,10414240,10414241,10414242,10414243,10414244,10414245,10414246,10414247,10414248,10414249,10414250,10414251,10414252,10414253,10414254,10414255,10414256,10414257,10414258,10414259,10414260,10414261,10414262,10414263,10414264,10414265,10414266,10414267,10414268,10414269,10414270,10414271,10414272,10414273,10414274,10414275,10414276) 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>