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(8574792,8574793,8574794,8574795,8574796,8574797,8574798,8574799,9215317,8583815,8583816,8583817,8583818,8583819,8583820,8583821,8583822,8583823,8583824,8583825,8583826,8835668,8835669,8066887,10102462,10102463,10940568,10940569,7069067,7069068,7069070,7069071,10841675,10841676,10841677,10841678,10841679,10841680,10841681,10841682,10841683,10841684,10841685,10980874,10980875,10980876,10980877,10980878,10980879,10980880,10980881,10980882,10980883,10980884,10980885,10980886,10980887,10980888,10980889,10980890,10980891,10980892,10980893,10980894,10980895,10980896,10980897,10980898,10980899,10980900,10980901,10980902,10980903,10980904,10980905,10980906,10980907,10980908,10980909,10980910,10980911,10980912,10980913,10980914,10980915,10980916,10980917,10980918,3924600,3924601,3924602,3582012,3582013,10427015,10427016,10427017,10427018,10427019,10427020,10427021,10427022,10427023,10427024,10427025,10427026,10427027,10427028,8853428,9179694,9179695,9179696,9179697,9179698,9179699,9179700,9179701,9179702,9179703,9179704,9179705,9179706,9179707,9179708,9179709,9179710,9179711,9179712,9179713,9179714,9179715,9179716,9179717,9179718,9179719,9179720,9179721,9179722,9179723,9179724,9179725,9179726,9179727,9179728,9179729,9179730,9179731,9179732,9179733,9179734,9179735,9179736,9179737,6676548,9914549,6676549,6676550,6676551,6676552,10120555,8567320,8567321,8567322,8567323,8567324,8567325,8567326,8567327,8567328,8567329,8567330,8567331,8567332,8567333,8567334,8567335,8567336,8567337,8567338,8567339,8567340,8567341,8567342,8567343,8567344,8567345,8567346,8567347,8567348,8567349,8567350,8567351,8567352,8567353,8592800,8592801,8592802,8592803,7056866,7056867,7056868,7056869,7056870,7056871,7056872,7056873,7056874,7056875,7056876,7056877,7056878,7056879,7056880,10427864,10427865,10427866,10427867,10898592,10898593,10898594,10898595,10898596,10898597,10898598,10898599,10898600,10898601,10898602,10898603,10898604,10898605,10898606,10898607,10169699,10169700,10169701,10169702,10169703,10169704,10169705,10169706,10169707,10169708,10169709,10169710,10169711,10169712,10169713,10169714,8594083,8594084,10649823,10649824,10649825,10649826,10649827,10649828,10523736,10523737,10480494,10480495,10480496,10480497,10480498,10480499) 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>