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(8630696,8630702,8630716,8630717,10873398,8631008,8631009,8631010,8631011,8631012,8631013,11041364,8631554,8621831,10437308,8622308,8622309,10849777,10849778,10849780,10849812,10951296,10871960,10871971,8609565,11042463,8609617,8632433,8632434,8632522,8632523,8632524,8632525,8632528,8632530,10869179,8632540,8629678,3227728,7075434,10845258,8835686,8835687,8835688,8835689,8835690,8835691,7072246,8559578,7064663,10960508,10960509,10960510,10960511,10960512,8595915,7202734,10932971,10932972,8626596,10942595,10942655,8627061,10842237,8558643,8558647,8910824,8625139,7069672,10996729,10996730,3926724,11010052,11010081,8626054,8612925,10967823,10967824,10967825,10967826,10994397,10994398,10994399,10994400,10994401,10838803,3234717,10839142,10839568,10839592,10839593,8541517,8541542,8541546,10992863,10617223,8541808,8542083,10993403,10993404,10993405,8542288,8542289,8542290,10622811,10622812,10622818,10622819,3233275,10615037,10615339,9217210,10965311,10965312,10965313,8540376,8540377,8540378,8540427,10621044,10621046,10621049,8540659,8540707,8540708,8540709,9218040,8541114,8541121,8611513,8611514,8541258,10953441,10562208,10562215,10614245,10614246,10614256,10614260,10614261,10614267,10562611,10562612,10562613,8853643,8853644,10611762,9166144,9198212,9198234,9179823,9179824,9179825,9179826,9179827,9179828,9179829,9179830,9179831,9179832,9179833,9179834,6676120,7017806,3653431,8852117,8852118,10564139,10564140,10564148,10120557,10120558,10120559,10120560,10120561,10120562,10564199,10561698,10561699,10561700,9204973,9204978,10562071,10562072,10517813,10517814,9170170,9187291,7014202,7014203,6681112,9185235,9185236,9185237,8568841,8568842,8568922,9198636,9916919,6666805,9166868,10471543,10471544,9175048,10123323,8916815,9183266,10469949,8917094,9183472,9183486,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,10468421,10468423,9168168,10427672,10898679,10898680,10898681,10898682,10898683,10628525,10628526,10628537,10875297,10875298,10875299,10875300,10875301,10875302,10875303,10184233,10176644,10176645,10176646,10176647,10176648,10176649,10176650,10625372,10167019,10601222,10601223,10601233,10608526,10608529,10599364,10599365,10599366,10599382,10599383,10599389,10653456,10653457,10603515,10527138,10527139,10527140,10527141,10527142,10527143,10527144,10527145,10527146,10527147,10527148,10527149,10527150,10527151,10527152,10527153,10521255,10521256,10521257,10521259,10529425,10529426,10551911,10551919,10528398,10534402,10534403,10534439,10522576,10520919,10421396,10508350,10424067,10423208,10407308,10407309,10407311,10407322,10473892,10473958) 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>