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(9214653,11014833,10939806,10939807,10870753,10870762,10870786,11015320,11015321,11015322,11015323,11015324,11015325,10848966,10848967,11015365,11015366,11015367,11015368,11015369,11015370,11015371,10849273,8621822,10849274,11028672,7074021,11028726,11028727,11028728,11028729,11028730,11028731,11028732,11028733,11028734,10847160,11042363,10929399,8837664,8629972,8629973,8630012,7067463,7067464,11012749,11012750,11012751,8066050,11026166,11026167,11026168,11026169,11026170,11026171,11013196,8619349,11013209,11013210,11013211,11013212,11026235,11026236,11026237,11026238,11026239,11013526,11013527,11013528,11013533,11013534,10865852,8910934,11037561,8910935,11035125,11022250,10840432,10840433,11048619,11032651,11032652,11032674,11006772,11006773,11019829,11019830,10919410,8907345,10619598,10619599,10619600,10619601,11005636,10917626,10917852,11006019,8635012,10954177,11019240,11019241,11019242,11019271,11019272,11019273,11019274,11019275,11019276,11019277,11032305,11006359,11019572,11019573,8570059,8570080,8632763,10964963,10964964,10964965,10964966,10964967,10964968,10848130,10848132,8576708,11004434,11030511,11030512,11030513,11030514,11030515,10916569,10916570,10916571,10916572,10916573,10916574,10916640,10916641,10916642,10916643,10916644,10916645,10916646,10916647,10916648,10916649,11017972,11017973,11017974,11017975,11017976,11017977,11017978,11017979,11017980,11017981,11018016,11018017,11018018,11018019,11018020,11018021,11018022,11018023,11018024,11018025,11018026,11018027,11018028,11018029,11018030,11018031,11018032,11018033,11018034,11018035,11018036,11018037,11018038,11018039,11018040,11018041,11018042,11018043,11018044,8577640,8577643,8541150,8541252,10917341,9915994,9915998,10559628,9916176,9916480,10119501,6675582,8862896,8566958,8849246,4974557,4974564,4974565,9201772,7056010,9202359,8552272,9203093,9200366,9209005,9209006,10419022,9185227,4974092,4971214,4971215,4971216,4971217,6678898,9174829,9174830,6679485,6679714,6679715,6679716,9175561,9167637,10179725,10179726,10894674,10914733,10629511,10912576,7000914,10178913,10178914,10178915,10178916,10178917,10178918,10178919,10178920,10178921,10178922,10178923,10178924,10178925,10178926,10178927,10178928,10178929,10178930,10178931,10178932,10178933,10178934,10178935,10178936,10178937,10178938,10178939,10178940,10178992,10178993,10178994,10178995,10178996,10178997,10178998,10178999,10893019,10893020,10893344,10913441,10166504,10171780,10877349,10877358,10877368,10602050,10602051,10574203,10574204,10571341,10571342,10571343,10571682,10572139,10572783,10572784,10572785,10572786,10572787,10572788,10572789,10572790,10572791,10572792,10572793,10572794,10572795,10572796,10572797,10572798,10572799,10572800,10572801,10572802,10572803,10572804,10572805,10572806,10572807,10572808,10572809,10572810,10572811,10572812,10651086,10573165,10573166,10573167,10573168,10573169,10573170,10573171,10573172,10573173,10573174,10573175,10573176,10573177,10573178,10573179,10573180,10573181,10573182,10573183,10573184,10573185,10573186,10573187,10573188,10573189,10573190,10573191,10573192,10573193,10573194,10573195,10570212,10648588,10648589,10648590,10646092,10586032,10538269,10538270,10528360,10528361,10538769,10538784,10528959,10422391,10422401,10422425,10493601,10493611,10476856,10476857,10476858,10476859,10476860,10476861,10476862) 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>