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(8573334,10858725,10858726,10858727,3227190,8629422,8629423,8629424,10857665,10857666,10857668,10857669,10857670,8625424,8625425,8625426,8625427,8625428,8625429,8625430,8625431,8625432,8625433,8625434,8625435,8625436,8625437,8625438,8625439,8625440,10623063,7196376,3235063,3235064,3235065,3235066,7198056,7198057,7198058,7198059,7198060,7198061,7198062,7198063,7198064,7198065,7198066,7198067,7198068,7198069,7198070,7198071,7198072,7198122,7198123,8905201,8541833,8905869,8540637,8633986,7016973,7016974,7016975,7016976,7016977,7016978,7016979,7016980,7016981,7016982,7016983,7016984,7016985,7016986,7016987,7016988,7016989,7016990,7016991,7016992,7016993,7016994,7016995,7016996,7016997,7016998,7016999,7017000,7017001,7017002,7017003,7017004,7017005,7017006,7017007,7017008,7017009,7017010,7017011,7017012,7017013,7017014,7017015,7017016,7017017,7017018,7017019,7017020,7017021,7017022,7017023,7017024,7017025,7017026,7017027,7017028,7017029,7017030,7017031,7017032,7017033,7017034,7017035,7017036,7017037,7017038,7017039,7017040,7017041,7017042,7017043,7017044,7017045,7017046,7017047,7017048,7017049,7017050,7017051,7017052,7017053,7017054,7017055,7017056,7017057,7017058,7017059,7017060,7017061,7017062,7017063,7017064,7017065,7017066,7017067,7017068,7017069,7017070,7017071,7017072,7017073,7017074,7017075,7017076,7017077,7017078,7017079,7017080,7017081,7017082,7017083,7017084,7017085,7017086,7017087,7017088,7017089,7017090,7017091,7017092,7017093,7017094,7017095,7017096,7017097,7017098,7017099,7017100,7017101,7017102,7017103,7017104,7017105,7017106,7017107,7017108,7017109,7017110,7017111,7017112,7017113,7017114,7017115,7017116,7017117,7017118,7017119,7017120,7017121,7017122,7017123,7017124,7017125,7017126,7017127,7017128,7017129,7017130,7017131,7017132,7017133,7017134,7017135,7017136,7017137,7017138,7017139,7017140,7017141,7017142,7017143,7017144,7017145,7017146,7017147,7017148,7017149,7017150,7017151,7017152,7017153,7017154,7017155,7017156,7017157,7017158,7017159,7017160,7017161,7017162,7017163,7017164,7017165,7017166,7017167,7017168,7017169,7017170,7017171,7017172,7017173,7017174,7017175,7017176,7017177,7017178,7017179,7017180,7017181,7017182,7017183,7017184,7017185,7017186,7017187,7017188,7017189,7017190,7017191,7017192,7017193,7017194,7017195,7017196,7017197,7017198,7017199,7017200,7017201,7017202,7017203,7017204,7017205,7017206,7017207,7017208,7017209,7017210,7017211,7017212,7017213,7017214,7017215,7017216,7017217,7017218,7017219,7017220,7017221,7017222,7017223,7017224,7017225,7017226,7017227,7017228,7017229,7017230,7017231,7017232,7017233,7017234,7017235,7017236,7017237,7017238,7017239,7017240,7017241,7017242,7017243,7017244,7017245,7017246,7017247,7017248,8851420,7017249,7017250,7017251,7017252,7017253,7017254,8851704,8851705,10610260,10610692,10117845,10117889,10118060,9168764,10888589,10884513,10884796,10884797,10884798,10884799,10884800,10647711,10647713,10413266,10413267,10413268,10412263,10412264,10412267,10412268,10412269,10412270,10412271) 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>