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(8618637,8618638,10944006,10944007,10944008,10944009,10944010,8628725,8628727,7068603,10843942,4971082,8569765,8836977,8572967,4969270,4969271,4969272,4969273,4969274,4969275,4969276,4969277,4969278,4969279,4969280,4969281,8910654,10236386,10236387,10236388,10236389,10236390,10236391,10236392,10858084,10858085,7067413,8558913,10103152,7072001,7072002,10247480,10931860,10856829,7073542,7073590,10194145,10194146,10194147,10194148,10194149,10194150,10194151,10194152,10194153,10194154,10194155,10194156,10194157,10194158,10194159,10194160,10194161,10194162,10194163,10194164,10194165,10194166,10194167,10194168,10867958,10867959,10867960,10867961,8634998,8634999,8635000,10837534,10837535,10837536,10866842,10425912,10425913,10425914,10425915,10425916,10425917,10425918,10425919,10425920,10425921,10425922,10425923,10425924,10425925,10425926,10425927,10425928,10425929,9217578,8610857,8541007,10852018,10852019,10619508,10619509,10213230,10930657,10861677,10621066,10431466,10616539,9165403,9165404,9165405,9165406,9165407,9165408,9165409,9165410,8853425,8864539,8864540,10940323,7019929,7019930,7019931,7057911,10120261,9173121,9177631,9177632,9177633,9177634,9177635,9177636,10517693,8849812,8849855,6674681,6674686,10116699,10428160,10419713,10117370,10117371,10117372,9174591,9174592,3655822,8854754,9190997,9190998,4971922,4971923,4971924,4971925,10465730,10465731,10465732,10465733,9207971,9207972,10883491,10159544,10169671,10879858,10879859,10879860,10657176,10879861,10879862,10657177,10879863,10657178,10657179,10171244,10156280,10887504,10907688,10907689,10907690,10907691,10907692,10627229,10627230,10168836,10164036,10905488,10896316,10162344,10162345,10162346,10659340,10659341,10659342,10659343,10912111,10163307,10602763,10584408,10584409,10584410,10584411,10590638,10590639,10590640,10590641,10590642,10590643,10590644,10590645,10590646,10590647,10590648,10590649,10590650,10590651,10590652,10590653,10590654,10590655,10590656,10590657,10590658,10590659,10590660,10590661,10590662,10590663,10606803,10606804,10606805,10606806,10606807,10606808,10606809,10606810,10606811,10606812,10606813,10606814,10606815,10606816,10606817,10606818,10606819,10606820,10588006,10651752,10645878,10645879,10645880,10645881,10579887,10543170,10543171,10543172,10543173,10541589,10541590,10541591,10541592,10541593,10541594,10541595,10541596,10519963,10519964,10554454,10415550,10479100,8562629,10411744,10714729,10714730,10714731,10412663,10412664,10408687,10472717,10472718,10472719,10472720,10472721,10476788,10476789,10476790,10476791) 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>