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(7076349,7076350,8622733,10859504,3927881,3927882,3927883,3927884,3927885,3927886,11049536,10943391,10943392,10943393,10943394,10943395,10863286,10863331,10863332,10863333,8625117,8625127,8625128,3656366,11006620,11006621,11006622,11006623,11006624,11006625,11006626,11006627,11006628,11006629,11006630,11006631,11006632,11006633,11006634,11006635,11006636,11006637,11006638,11006639,11006640,11006684,11006685,11006686,11006687,11006688,11006689,11006690,11006691,11006692,11006693,11006694,11006695,11006696,11006697,11006698,11006699,11006700,11006701,11006702,11006703,11006704,11006705,11006706,11006707,11006708,11006709,11006710,11006711,11006712,11006713,11006714,11006715,11006716,11006717,11006718,11006719,10618296,10618316,10854076,11046936,11046937,11046938,11046939,11046940,11046941,11046942,11046943,11046944,11046945,11046946,11046947,11046948,11046949,11046950,11046951,11046952,11046953,11046954,11046955,11046956,11046957,11046958,11046959,11046960,11046961,11046962,11046963,11046964,11046965,11046966,11046967,11046968,11046969,11006611,11006612,11006613,11006614,11006615,11006616,11006617,11006618,11006619,10848192,10927066,9213838,9213839,9213840,9213841,9213842,9213843,9213844,9213845,9213846,9196161,9196162,9196163,10126152,10126153,10126154,10126155,8593232,8593233,10416814,10416815,10416863,10416864,10416865,6678688,8550917,10884925,10599981,10599982,10599983,10599984,10599985,10599986,10599987,10599988,10599989,10599990,10599991,10599992,10599993,10599994,10599995,10599996,10599997,10599998,10599999,10600000,10600001,10600002,10600003,10600004,10600005,10600006,10600007,10600008,10600009,10600010,10600011,10600012,10600013,10600014,10600015,10600016,10600017,10600018,10600019,10600020,10600021,10600022,10600023,10600024,10600025,10600026,10600027,10600028,10600029,10600030,10600031,10600032,10600033,10600034,10600035,10600036,10600037,10600038,10600039,10600040,10600041,10600042,10600043,10600044,10600045,10600046,10600047,10600048,10600049,10600050,10600051,10600052,10600053,10600054,10600055,10600056,10600057,10600058,10600059,10600060,10600061,10600062,10600063,10600064,10600065,10600066,10600067,10600068,10600069,10600070,10600071,10600072,10600073,10600074,10600075,10600076,10600077,10524189,10424917,10424918) 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>