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(10939584,10861402,10870595,7076320,10459088,10459089,10459111,10847378,7075930,10866797,10866798,10866799,10866800,10866801,10960400,10843560,3899586,5654730,10102993,10995653,10839833,7198729,10941835,10941836,10941931,7199610,7199613,7199617,7199619,7199622,7199626,7070780,11010573,3233375,11045730,11045851,11045852,11045946,11045964,10618307,10618308,10618311,11045976,3234911,3234912,3234913,3234914,3234915,3234916,3234917,3234918,3234919,3234920,3234921,3234922,11047558,11047559,3232363,10992846,10992847,10992848,10992849,10992850,10992851,10992852,10992853,10992854,10992855,11044912,10837211,8542255,8542362,10951604,3230410,10460714,10460720,10460726,10460732,10460738,10460744,10460750,10460756,10460762,10460768,10460774,10460780,10460786,10460792,10460798,10460804,10460810,10460816,10460822,10460828,10460834,10460840,10460952,10460971,10952053,10952054,10952055,10952335,10926340,9217552,10991660,10991772,10991773,10991774,8541142,10927425,10927426,10565187,10565188,9165557,9213577,9213603,9213604,9213605,9189637,9189650,9189739,9189740,10122201,9214063,10611758,10122329,10122332,10122333,7057474,7057475,10609238,9211672,9188242,9188243,9188282,8566966,9188482,9188524,9188536,9188575,9188580,10558597,8567453,9189025,9189026,9189030,9189258,9189259,9189260,9189261,9189262,9209430,9185527,9185528,9193529,9185529,9209605,10125983,9169985,4975237,9170867,9160302,9176389,10415343,10419661,10419662,10419663,10419664,10419665,9168760,9209067,9161280,9198935,9198941,9198999,9175006,8854887,9175453,9175461,976473,10470678,10884591,10875133,10880200,10905215,10905278,10630100,10910858,10910859,10646190,10601160,10589189,10589190,10589191,10589192,10589193,10589194,10589195,10589196,10589197,10589198,10589199,10589200,10589201,10589202,10589203,10589204,10589205,10589206,10589207,10589208,10589209,10586587,10586588,10586589,10586590,10586591,10586592,10586593,10599101,10599102,10599103,10587136,10566137,10587137,10566138,10587138,10566139,10599204,10590230,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10590492,10590493,10567546,10607475,10607476,10607477,10607478,10607479,10585703,10588713,10588714,10588715,10588716,10588717,10588718,10588719,10588720,10588721,10588722,10588723,10579787,10533121,10533125,10533126,10539142,10539143,10529149,10521281,10521289,10521290,10537474,10521840,10547894,10547895,10547896,10547897,10548027,10522078,10522079,10522085,10522087,10522210,10532218,10538322,10538323,10538324,10534387,10538468,10522509,10550603,10546745,10546746,10546747,10546748,10538769,10538784,10538845,10546929,10546930,10527023,10422259,10508304,10506837,10507977,10488165,10488168,10493103,10493345,10493346) 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>