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(10943426,8583100,10849557,8067423,11029397,11029398,11029399,11029400,11029401,11029402,11029403,7066749,10990538,10990539,10990540,10990541,10990542,10872235,10872236,3227431,11026891,11026892,11026893,8573403,8573648,8573649,10988307,7067751,7067932,7072071,8559454,7072669,7072670,10867330,10867362,8560243,10867620,3237500,8617254,8617255,8617257,8617258,10102676,11024254,11024255,11024256,11024257,11024258,10857862,11024259,11024260,11024261,11024262,11024263,11024264,8617626,8617627,8617628,6000212,10944449,11035311,11035349,11035466,11035467,11035468,11035469,11035470,10840849,10841099,10841100,10997038,11023053,11023054,11023055,11023056,11023057,11023058,3926939,7199888,11010608,10837695,10837696,11006643,11006684,8612897,8612898,10618820,10968590,10968591,11020592,10968592,10968593,11020593,11020594,10968594,10838982,8555365,11021494,10839630,8563614,8611861,8611862,8611863,10836870,11031962,10927891,10852704,11042653,10990654,11042654,10990655,10425354,10920760,10920761,10920762,10920763,10920764,10620293,10620294,10620295,10952808,10952809,10952810,10952811,10952812,10952813,3231719,3231720,3231721,3231722,9165375,7027083,7019085,10565362,10565363,10565364,10565365,10565366,10565367,10565368,10565369,10565370,10565371,10565372,10565373,10565374,10565375,10565376,10565377,10565378,10565379,10565380,6669953,9197792,8864587,7025298,9171960,9171961,10563791,10563792,10610011,3653903,8852827,7026774,9185374,10515433,10515434,10515435,7023482,7023643,8551329,7056213,10516187,7024129,10514370,10119076,8552292,9187264,10427710,9160363,10427788,9176450,9176451,9176452,8918101,10420137,10420153,8549457,8549458,8549459,8549460,6666529,4971389,9182572,10467337,8916883,8550409,8550410,9167310,9199680,9199711,10123966,10123995,10462464,10462465,10462466,10462467,10909028,10909029,10909030,10909031,10909032,10894129,10170326,8594434,10884540,8068992,10909661,10887732,10153873,10153874,10153875,10153876,10153877,10153878,10153879,10153880,10153881,10153882,10153883,10153884,10883051,10176751,10891196,10891197,10891198,10891199,10891210,10167709,10626336,10167922,10168095,10945103,10643476,10643477,10643478,10643479,10643480,10643481,10643482,10643483,10602316,10602317,10602318,10602319,10652704,10650475,10647999,10648000,10648907,10529444,10529459,10529460,10529475,10521871,10521872,10521875,10522133,10522248,10522249,10538408,10533108,10420382,10423413,10477878,10477879,10493272,10409099) 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>