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(10848672,10848673,10848674,10848675,8595206,5654563,5654567,9794571,7200202,10857417,10857418,10857419,10857420,10857421,10857422,10857423,10857424,10857425,10857426,8627254,8627506,8627507,8627508,8627509,8627510,8627511,8627512,8627513,8627514,8627515,8627516,8627517,8627518,7198702,7198704,10863842,10863843,10101457,10101458,10857132,7196489,7196497,8906619,8906770,7197246,7197247,7197248,7197249,7197259,7197260,10854409,10854410,10854411,10854479,10854480,10854481,10854482,10854483,10854484,10854485,10854486,10854487,10854488,10854489,10854490,10854491,10854492,10854493,10854494,10854495,10854496,10854497,10854498,10854499,10854500,10854501,10854502,10854503,10854504,10854505,10854506,10854507,10854508,10854509,10854510,10854511,10854512,10854513,10854514,10854515,10854516,10854517,10854518,10854519,10854520,10854521,10854522,10854523,10854524,10854525,10854526,10854527,10854528,10854649,10854650,10854651,10854652,10854653,10854654,10854674,10854675,10854676,10854677,10854695,10854696,10854697,10854698,10854735,10854736,10854737,10854738,10854739,10854740,10854741,10854742,10854771,10854772,10854773,10854800,10854801,10854802,10854803,10854804,10854826,10854860,10854861,10854862,10854863,10854864,10854865,10854870,10854871,10854872,10854873,10854874,10854875,10854876,10854877,10854878,10854889,10854921,10854922,10854923,10854924,10854925,10854927,8904996,8904997,8904998,8905011,8905012,8905066,8905203,3232882,3232883,10615051,3581874,10615571,10426359,10426360,10616641,10616642,10616643,8904984,8904985,8904987,8904992,10714111,10609846,10609847,10609848,10609849,10609850,10609851,10609852,10609853,10609856,10609859,10609860,10609861,10609862,10609863,10609864,10609867,10609868,10609869,10609870,10609874,10609877,10609878,10609879,10609882,10609893,10609895,10609900,10609912,10609913,10609914,10609915,10609925,10609926,10609927,10609929,10609935,10609936,10609952,10609953,10612973,10610131,10610133,10610691,10610694,10117504,10117508,9911808,9911809,9911810,9911811,9911813,9911815,9911824,9911836,9911837,9911844,9912018,9912019,9912020,8850105,8850106,8850107,8850108,9912648,8552174,10417293,10417294,10417295,6672659,6672660,6672663,6672666,6672676,6672721,6673165,6673298,8549938,8549948,10467604,10467605,10467609,10467610,10467611,10467612,10467613,10467623,10467624,10467625,976431,9167800,9167831,9167836,9167837,9167852,10468528,9168019,10884420,10882902,10882903,10882905,10882906,10882910,10882916,10882917,10882928,10882929,10882930,10882937,10882938,10882941,10882945,10882946,10882947,10882950,10882952,10882960,10882977,10882978,10882979,10882983,10882984,10882986,10882987,10882990,10882991,10882993,10882996,10883003,10883005,10883017,10883021,10883023,10883024,10161820,10161821,10161822,10602313,10608810,10608811,10608812,10647349,10647350,10647352,10410142,10410143,10410144,10410145,10410146,10410147,10410148,10410149,10410150,10410173,10410174,10410175,10410176,10410177,10410322,10406935,10406936,10406937,10406938,10406939,10406940) 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>