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(8574466,7076292,8631111,8631112,8631113,8631114,10871050,8631477,8631479,8631995,8629906,10447778,10447794,10447801,10447803,8627619,8627623,8627629,8627630,8627631,8627632,8627633,8627720,8627722,8627847,10867701,8629093,8629285,8629286,8629407,7200609,8627316,8627317,10858055,10102995,10959556,10959559,10959560,10959561,8627574,8627575,8627576,8627577,8627578,8627579,8627580,10995711,10995716,10995720,3925441,8624724,8624743,7198457,10996416,10941757,10941763,10941773,10941782,10994159,3234744,10995382,10855031,10855032,11047476,11047492,11047501,8624510,8624515,8624516,8624524,10995579,10617426,8542254,10951667,10951668,10848006,8633309,8633310,10991493,10991499,10991500,8540363,8540364,8540365,8633510,8633514,8633517,8633519,8633530,8540400,8633534,8633537,8540408,8540409,8540410,10991589,8633556,8540544,10991733,10991734,8540564,8540568,8540588,8540590,8540592,10991935,8540781,8540782,10991956,10991957,10991958,8634444,8634451,8634452,8634455,9189360,8567864,9189363,9189364,9214180,9211649,9211650,9212322,10558297,10613369,6677319,6677320,6677363,8849329,8849330,9185606,9185607,9185609,9185630,9185737,9185738,9185744,9185856,9185857,9185866,9185879,9185896,9185897,9185944,9185945,9185946,8849926,9186800,9186804,10119183,9913359,8848157,4973195,8848728,8848746,8848756,8848782,8848829,9193119,3963601,3963602,8847273,8550648,8550696,8847541,8847542,8848036,8848046,8848103,10908628,10883629,10903637,10632189,10172076,10626235,10626602,10626815,10626842,10598620,10598653,10598654,10598655,10598656,10598657,10598658,10598659,10598660,10598661,10598662,10598673,10598674,10598675,10598676,10598687,10598688,10598689,10598690,10598691,10598692,10598693,10598694,10598695,10598696,10598697,10598698,10598699,10598700,10598701,10598702,10598703,10598704,10598705,10598706,10598707,10598708,10598709,10598710,10598711,10598712,10598713,10598714,10598715,10598716,10598717,10598718,10598719,10598720,10598721,10598722,10598762,10598763,10598764,10598765,10598766,10598767,10598768,10598769,10598770,10598771,10598808,10602723,10590270,10590279,10590280,10579778,10579779,10579780,10579781,10601688,10528106,10528107,10528108,10528115,10528116,10528117,10528142,10528146,10528162,10528176,10528177,10546315,10532856,10532857,10532858,10532859,10420427,10422597,10410245,10410246,10412633) 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>