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(4970410,4970411,4970412,4970413,4970414,4970415,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,3228807,3228808,3228809,3228810,3228811,8574920,8574921,10944211,10944212,10944213,10944214,8583587,9215830,9216588,10929218,10929219,10929220,8573188,10939340,10939341,10939342,10939343,10959861,10959862,10959863,10959864,10959865,10959866,10959867,10959868,8594932,8065697,8065698,8065699,8065700,8065701,8065702,8065703,8065704,8065705,8065706,8065707,8065708,7202063,8595576,8595577,8595578,7065550,7065551,11049787,11049788,11049789,11049790,8834696,8834697,8834698,10940668,10940669,10940670,7069162,7069163,7069164,7069165,8556247,8556248,8556249,8556250,8556251,8556252,8556253,8556254,8564637,8564638,10996665,10101285,11048355,8553901,8554009,8554010,8554011,10618169,10618170,10618171,10981527,10981528,3924651,7156245,10853029,10426120,10426121,8610977,8904846,3232230,3232231,10621950,10621951,8567929,9189533,10611987,9171407,8862340,8862341,8862342,8862343,8862344,8566493,8566494,8566495,8566496,9180022,9180023,9180024,9180025,3653259,10120686,7058767,7058768,7058769,7058770,7058771,7058772,7058773,8863687,8863688,6677379,6677380,6677381,8592907,8849940,6674436,6674437,2809278,7056907,8552117,8552355,4973413,4973414,4973415,10116984,9911431,9911493,9911494,9911495,10466963,10466964,10466965,10466966,10466967,10466968,9166716,9166717,9166718,9166719,9166720,9166721,9166722,9166723,9166724,10471516,4972392,4972393,6672436,6672437,6672438,6672439,6672440,10170114,10899243,10899244,10899245,10899246,10899247,10899248,10899249,10160819,10160820,10160821,10161342,10161343,10161344,10161345,10161346,10161347,10161348,10161349,10161350,10161351,10161352,10161353,10161354,10161355,10161356,10161357,10161358,10161359,10161360,10161361,10161362,10161363,10161364,10161365,10161366,10161367,10161368,10161369,10161370,10161371,7000814,10905934,10905935,10948819,10948820,10948821,10948822,10948823,10948824,10948825,10948826,10948827,10948828,10948829,10948830,10881386,10881387,10881388,10881389,10881390,10881391,10881392,10881393,10949494,10172784,10172785,10162846,10911949,10911950,10911951,10949874,10877202,10608379,10608380,10646934,10646935,10646936,10646937,10646938,10646939,10650703,10567440,10567441,10567442,10567443,10567444,10567445,10567446,10649149,10488124,10714967,10480820,10480821,8562176) 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>