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(10848703,10848704,10848706,10848707,10848709,10848710,10848712,10848714,10848728,10848729,10848731,10848733,10848744,10848746,10848748,10848750,10848759,10848760,10848766,10848767,10848768,10848774,10848775,10848777,10848782,10848783,10848786,10848788,10848791,3228956,10950728,8631902,8631904,8631933,8631957,8631959,8631960,8631981,8631984,8631986,8631996,8631997,8632003,8632015,8632016,8632018,8632019,8632044,8632046,8632056,8632058,8632086,8632099,8632101,8632109,8632110,8632112,8632121,8632122,8632123,8632125,8632127,8632128,8632129,8632134,8632136,10939409,7201181,7201182,7201190,7201191,3238537,3238538,7201407,7202194,5654537,10859666,10859672,10859674,10859676,10859677,10859681,10859684,10859688,10859689,7201170,7201171,7201172,7201173,7201174,7201175,7201176,7201177,7201178,8624698,10864191,11048411,11048412,3923536,3924393,8907462,8634886,8634887,8905838,8905839,8632699,8632700,8632701,3231149,10615924,8540604,8540605,10611826,10612997,10612999,10613003,10613005,10613009,10613010,10613016,9188512,10118333,10516919,10516920,9910570,9160471,9168745,7014552,7014553,7014554,7014555,7014556,7014557,7014558,7014559,7014560,7014561,7014632,7014633,7014658,7014659,10117323,7014905,7014906,7014907,7014908,7014909,7014910,7014911,7014912,7014913,7014914,7014915,7014916,7014917,10899536,10627714,10161947,10603695,10603696,10604387,10507771,10507772,10507773,10507774,10507775,10486267,10486269,10486276,10486277,10486278,10486279,10486280,10486281,10486282,10486284,10486285,10486288,10486289,10486291,10486293,10486295,10486296,10486297,10486298,10486299,10414096,10414101,10414104,10414106,10414107,10414111,10414114,10414115,10414120,10414121) 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>