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(11001744,7076127,10989072,8631480,8631481,8631482,8631603,9215737,9215738,10849376,10849379,10849380,10849384,8631912,8631913,8631942,8631943,8631944,8631967,8631968,8631989,8631990,8631991,8583905,8575733,8575735,8632291,8632292,8573270,10869433,8629827,10860518,10860584,10860585,10860596,10860600,10860601,10860602,10860603,10860604,10860871,8559046,10866542,8595165,10843459,10859193,10859194,10986752,10986753,10986754,10986755,10986756,8628724,8628726,8626959,8910466,8910599,10857947,7201156,10863282,10863298,10863552,10863647,10863648,10863650,10863651,10863652,10863653,10863654,10863655,7198695,8625113,7198722,8908547,7198770,11009281,11009282,8626454,8626455,8626456,8626457,8626458,8626459,8626460,8626461,8626462,8626463,8626464,10617974,7196369,7196376,3923526,10618280,3923672,8554358,8906644,10853919,3234099,3234116,7196950,10623731,10623732,10623733,10623734,10623735,10623736,10623737,10623738,10623739,10838519,3234357,3234366,3234367,3234368,3234372,10838965,10838980,10838983,8907409,7197647,10854925,8624417,8624570,8905086,11044803,10617354,10617378,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10617405,10617448,8905711,8542251,10425351,10951904,10620330,10620331,3581904,8633259,8633268,8633278,10426013,8633295,8633296,10992331,10616790,8634467,8634468,8634474,3232255,10613962,8863877,8853225,8853236,10714483,9211562,9211563,9211564,8862146,8851703,9211926,9211971,9212322,10613545,6673576,9161476,10517670,9169951,6674247,9912269,9912571,8552205,9913360,9913361,7057450,6672515,8848176,8848195,9160377,9910860,10416810,8848717,8848728,10416826,9176907,8848734,8848746,8848756,8848911,10417085,10417148,10417149,10417150,10417151,10417152,10417153,10463003,10463030,10463032,10463033,10467113,10467142,10469361,10469362,10463400,10463401,10467443,8550087,8550266,10463728,10463730,10463738,10463740,10463760,10463761,10465767,10465768,10465780,10465784,9175261,9175262,9183540,8847591,8847610,10462401,10462402,10462408,10462452,10462453,9192133,10462726,10462727,9192241,10466847,10466848,10466852,10466853,10427656,10883587,10884089,10884596,10889775,10885072,10890110,10890150,10890151,10890152,10890153,10890252,10885374,7000845,10883458,10900931,10900932,10900933,10900934,10900935,10900936,10162248,10886513,10886514,10886515,10886516,10886517,10886518,10886519,10886520,10886521,10886522,10886523,10886524,10886525,10886526,10911848,10882007,10626876,10626877,10602167,10602727,10602728,10590271,10590272,10590273,10590276,10590290,10590291,10590292,10590293,10590294,10590295,10590296,10599386,10523075,10498393,10498395,10498396,10421605,10506819,10425041,10508037,10483453,10483454,10483455,10483456,10483457,10483458,10483459,10484531,10410177,10478023,10412533,10478231,10414830,10414843,10414846,10414847,10414848,10414849,10482610,10406982,10406985,10406986,10406990) 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>