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(8631075,8631255,8631256,8631259,8631260,8631263,8631264,8631267,8631268,8631271,8631272,8631301,8631307,8631313,8631319,8631325,8631331,8631337,8631343,8631509,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631560,8631561,8631562,8631563,8631564,8631565,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631578,8631579,8631580,8631582,8631624,8631625,8631743,8631749,8631752,8631755,8631757,8631766,8631767,8631768,8631769,8631770,8631771,8631772,8631773,8631774,8632510,8632547,8629968,8629970,8629975,8629978,8629998,8630003,8630007,8630008,8630014,8630018,8630023,8630028,8630135,8630143,8630144,8630148,8630168,10845280,10845281,8630395,8630396,8630427,9214462,8630487,8617860,8627793,8627907,8627909,8627910,8627920,8627931,8628118,8628119,8628154,8628158,8628164,8628205,8628210,8628219,8628220,8628221,8628222,8628223,8628224,8628225,8628226,8628233,8628234,8628235,8628236,8628252,8628253,10843459,8628384,8628385,8628386,8628387,8628388,8628389,8628390,8628391,8628392,8628393,8628394,8628395,8628396,7202265,8628666,7202266,8628667,8628668,8628796,7073161,8628873,10104393,10104394,10104395,10104396,10104397,10104398,8629016,10104538,8629095,8629096,8629099,10104591,8629222,8629227,8629228,8629229,8629230,8629231,10104805,8629340,8629341,8616854,8626914,8624592,8624687,8624786,8624787,8624788,8624789,8624790,8624791,8625077,8908517,8625235,8625368,8625462,8625486,8625558,8625639,8625728,8625772,8625810,8625811,8625814,10841032,8626074,8626226,10101771,8626421,8626422,8626423,8626424,8626425,8626426,8626427,8626428,8626429,8626430,8626431,8626432,10967764,8634686,11045030,11045209,11045210,8542215,10847754,10847755,8632756,8632759,8632760,8632789,8570413,8633793,8633831,8633865,8633886,8540757,8633907,8540797,8540798,8540799,8633932,8540800,8540801,8540802,11044084,11044085,11044103,11044108,8540986,8540987,8540988,8540989,8540990,8540991,8540992,8540993,8540994,8540995,8540996,8540997,8540998,8540999,8541000,8541001,8541002,8541003,8634259,8634260,8634261,8634407,8634420,7059608,9171915,9171916,9171917,9171918,10609986,10613144,10613220,10613221,9188640,6681280,6681281,9207230,10893949,10893986,10626300,10602775,10528214,10544815,10544816) 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>