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(8630812,10846495,10846496,8631622,8631623,8631624,8631625,8631627,8631635,8575179,8575180,8575181,9215825,3229946,9216231,10990326,10990327,10990328,8632413,8573252,8573253,8573254,8573255,8837570,8573395,10939168,8630225,10860868,10860869,8630228,8630234,8630235,8630240,8630243,8630244,10860958,10939512,10858309,10858310,8617865,8627793,8627985,8627986,8627989,8627990,8628008,8628009,8628011,8628012,8628014,8628016,8628018,8628019,8628020,8628021,8628022,8628023,8628024,8628025,8628027,8628028,8628029,8628194,8628229,8628230,8911786,8911787,10843854,10859705,8572826,8572827,8626830,8626831,8626832,10102355,10857567,8627062,8627063,10102661,10865995,8624585,8624629,8624630,8624631,8624632,8624633,8624634,8624635,8624636,8624637,8624638,8624639,8624640,8624641,8624681,8624682,8624683,8624684,8624685,8624686,8624687,8624688,8624689,8624690,8624691,8624692,8624693,8624694,10863842,8625382,8625383,8625384,10941366,8625390,10941368,8615770,8615771,10941638,10864741,10101585,8626394,10854067,10619203,10619204,3234834,8624437,3233010,8632705,8632707,9216841,9216845,9216849,8632852,9217052,9217055,9217061,9217069,9217071,9217074,9217077,9217082,9217096,9217107,9217109,9217110,9217111,9217193,10615813,10615814,8633543,8633544,8633545,8633546,8633547,8633548,9217932,8634241,8634264,8577869,8578011,10616898,10613974,9205320,3654570,10611516,10610282,9164790,9164791,9164792,8852658,9164953,10610678,10610724,9169637,9162447,8552055,9913149,10417293,6672605,9910991,6673072,6673143,6673144,10418048,10117439,9911455,8549796,10469516,976410,976411,10468838,10468842,10946775,10947067,10947068,10947658,8069240,10888264,10948614,10948615,10948616,10948617,10948618,10948619,10948620,10948722,10948723,10948724,10948725,10161929,10948799,10886086,10948947,10886551,10886791,10608291,10608292,10608370,10605445,10605446,10605927,10605928,10606379,10606380,10606381,10606382,10606383,10606602,10606603,10607073,10505387,8562476,8562477,10494354,10494355,10494356,8562811,8562814,8562898,8562899,10414133,10412196,10412842,10412843,10414994) 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>