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(10497666,10497667,10497779,10497780,10497781,8591292,8591293,8591294,8591295,8591296,8591297,8591298,8591299,10497866,10497867,10497908,10497909,8068058,8068059,8068060,8068061,8068062,8068124,8835509,8835510,8068586,8068587,8068588,8068589,8068590,10221145,10221146,10221147,10221148,10221149,10221150,8564812,8564813,10102439,8907768,8908013,8908055,8555980,8555981,10868610,8613571,8613609,8613677,8613678,3924435,10219825,10426718,10426719,10426720,10426721,3232195,7155623,10215054,10215055,10215431,10215704,8569808,10498200,10498201,10498202,10498203,10498204,10498205,8591704,8591705,8591706,8591707,8591708,8591709,8591710,8591711,8591712,8591713,8591714,8591715,8591716,8591717,8591718,8591719,8591720,8591721,10447673,8574405,8574465,10930756,10621130,10621131,10621145,9215306,10214462,10214463,10214464,10214465,10214466,10214467,10214468,10214469,10621414,10621415,10621416,10621417,10621418,10621419,8583564,10214937,10214938,10214939,10214940,10214941,10214942,10214943,10214944,10214945,10214946,10214947,10214948,10214949,10214950,10215053,8853364,6669917,10120358,10120359,9914411,9914412,6676425,6676460,6676480,6676481,8863370,8863581,8863582,8863583,9178252,9178322,9178323,9178324,9178363,9178364,9178525,9178526,9178561,9178562,8066550,8066551,8066552,8066553,8066554,9179118,9179176,9179177,9179178,9179179,9179180,8851114,6672773,6672881,4971990,4972004,4972124,10463929,10463930,976086,8848120,8593640,8593903,8593904,8593905,8069036,8069037,10899856,10897630,10897871,10897872,10897873,10897874,10897875,10897876,10897877,10897878,10897879,10896509,10896516,10949406,10949407,10949408,10949409,10896617,10896949,10897225,10897226,10897227,10897453,10897454,10897455,10897456,10897457,10897458,10897459,10649550,10649567,10479405,10479406,10479502,10479503,10479759,10479967,10479968,10479969,10479970,10480011,10480012,10480013,10497072,10480095,10480096,10497147,10497148,10480216,10480217,10480218,10480284,10480343,10480344,10480450,10480476) 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>