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(10950707,10950708,10862896,10862897,10862898,10862899,10862900,10862901,10862902,10862903,10862904,10862905,10862906,10862907,10862908,10862909,10862910,10862911,10862983,10858715,10858716,10858717,10858718,10858719,10858720,10858721,10858722,10858723,10858724,8628215,8628626,8628627,9794589,8910075,10958953,10958954,10857684,10857685,7201027,8624679,8624680,8624693,8624694,8624925,10863690,8554311,8624433,7198054,7198055,8541832,8905382,10616541,8611450,10616655,7016953,7016954,8851125,7016955,7016956,8851127,7016957,7016958,7016959,7016960,7016961,7016962,7016963,7016964,8851136,7016965,7016966,7016967,7016968,8851139,7016969,7016970,8851142,7016971,7016972,8851150,8851153,8851158,8851165,8851171,8851173,8851176,8851179,8851185,8851189,8851210,8851215,8851223,8851237,10612087,10612088,10612089,8851252,10612090,10612091,10612092,10612093,10612094,10612095,10612096,10612097,8851266,8851267,8851273,8851278,8851288,8851300,8851304,8851310,8851312,8851315,8851352,8851363,8851396,8851408,8851431,8851470,8851476,8851486,8851497,8851502,8851513,8851516,8851519,8851522,8851525,8851533,8851534,8851542,8851702,8851703,8566611,8566612,8566613,8566614,8566615,8566616,8566617,8566618,10613376,10613377,10610503,10610505,10610653,6673562,10117732,10117733,10117830,10117831,10117832,10117833,10117834,10117887,10117888,9169777,9912192,9912225,9912226,8850620,8850623,8850625,8850630,8850632,8850639,8850653,8850656,8850664,8850693,8850703,8850735,8850744,8850824,8850829,8850891,8850892,8850911,8850913,8850914,8850919,8850922,8850924,8850946,8850969,8851023,8851088,8851090,7016941,7016942,7016943,7016944,7016945,7016946,7016947,7016948,7016949,8851121,7016950,7016951,7016952,9168392,9168393,6672656,6672726,6672729,6672730,6672733,10416465,10416466,10416467,10416468,10416469,10416470,10416471,10416472,10416473,10416474,10416475,10416476,10416477,10416478,10416479,10416480,10416481,10416549,9168876,6673317,10417162,10471069,10467774,10888643,10883672,10884589,10884590,10884794,10884795,10889796,10627724,10627725,10627726,10162053,10887441,10413257,10413258,10413259,10413260,10413261,10413262,10413263,10413264,10413265,10414647) 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>