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(7068069,11014954,11014955,8621193,11015085,11015086,11015087,11015088,11015089,11015090,4970967,10849134,10950648,11016033,11016034,11016035,11016036,11016037,11016038,11016039,11016040,11016041,11016042,11016043,11016044,11016045,11016046,11016047,11016048,11016049,11016050,10849734,10849743,10849744,10849745,10849746,10849747,10849748,7066712,7066788,11042570,11016582,11016583,11016584,11016585,11016586,11016587,11016588,11016589,11016590,11016601,11016602,11016603,11016604,11016605,11016606,11026851,8573420,7075273,10845310,11027256,11027257,11027283,11027284,11027285,11027286,11027287,11014423,7067810,11014534,10845680,4430608,11024716,11024752,11024753,11024754,11024755,11024756,8594732,7064125,7072500,10973307,11012336,8911745,11012456,11012457,11012458,11012459,11012460,11012461,7072793,7072794,8595784,10859494,10859495,10859496,10859497,8836732,11012936,11012937,11012938,11012939,11012940,8596009,8596048,8560394,8560397,8560398,8560399,8560400,8560402,8560404,11013302,11013323,8619486,8619487,11013447,11013466,10997874,11024215,7200818,7200824,10857918,10857919,10857920,10857928,10972452,8910877,8910879,8910961,8555964,7069195,10941155,7199121,7199122,3236746,10971247,10958293,3927103,10918868,11020179,10981792,11018691,11018692,11018693,11018822,11018823,11018824,11018825,11018829,10917924,10917925,10917926,10917927,10837152,10837153,10927979,11006158,11006159,11006215,11032408,11006537,11006616,11006617,10915701,10915702,10915703,10915704,10915709,11004177,8904506,11005155,10616512,10917071,10917072,10917073,10917074,11005222,11005225,8552536,8552862,9197347,9165426,9165427,9165428,9165429,9915797,6678288,9916342,9179369,8862155,10609404,9180187,9180453,10428709,4974305,4974306,4974307,9201527,9201561,9911860,9911862,8592817,8849714,8850899,8850901,8565736,8565737,8848331,8848338,6673112,10125422,10125489,6678636,8864954,6679432,6679568,8847722,9207922,9207923,9207924,6680230,6680238,9208038,10946390,10888655,10174999,10175000,10175001,10914462,10155492,10155493,10629519,10910107,10910108,10885171,10885172,10885173,10166266,10166304,10166305,10915311,10915312,10915313,10915314,10915315,10915316,10915317,10915318,10915319,10166435,10153847,10183867,10183868,10883077,10888095,10187569,10177636,10177638,10876683,10187830,10177992,10177994,10949841,10571416,10571417,10571426,10571660,10602545,10571738,10571832,10571833,10571834,10603068,10569543,10575830,10575831,10653983,10508181,10508182,10407269,10407270,10407271,10407272,10407273,10407274,10407275,10407276,10407277,10407278,10407279,10407280,10407281,10407282,10407283,10413951,10413952,10413953,10413954,10412207,10412208,10412209,10412216,10412503,10412504,10412505,10412512,10493575,10482578,10415094,10415095) 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>