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(9214766,9214767,9214768,9214926,10861921,3229110,10868250,8631908,8631909,8631937,8631938,8631963,8631964,8631985,8631986,10862796,8575734,8629712,10860583,10872660,10860833,10860834,10860835,10860836,10860837,10860838,8630196,10860839,9214431,10866542,10866840,8628382,10999916,10999942,10999943,10999944,11000099,11000100,10844183,10857266,10857267,10857268,10857269,10102114,8834907,4430183,7200903,7200904,10857953,10857995,8624646,8624679,7198386,10863518,10863519,10863520,10863521,10863522,10863523,7198703,7198722,7198728,7198730,7198737,7198738,7198742,7198748,7198766,8557162,7196451,11045994,3234119,3234120,3234121,10838966,8541574,8541575,8541576,8541577,8541578,8541579,8541580,8541581,8541582,8541583,8541584,8541585,8541586,8541587,8541588,8541589,8541590,8541591,8541592,8541593,8541594,8541595,8541596,10617400,10617401,10617402,10617427,10617448,3230358,3230359,10951828,10848004,10620303,8633118,8633119,8633120,8633121,8633122,8633123,8633173,8633174,8633175,8633176,8633177,8633178,8633179,8633182,8633286,8633287,8633288,10620791,10615889,10615890,10615891,8540564,8540568,8634456,10613971,8853324,8853348,8853349,9173740,10611459,10611615,10611649,10611778,9211555,8566683,9172467,8863272,10613922,10613923,10613924,10613925,10613926,9169952,10518682,10518683,10518684,10518685,10518686,8552203,7057449,7057450,9176428,10416359,10428147,10419711,6673126,9169051,9169052,9169053,9169054,9193119,9193120,9193121,10417053,10417054,10417055,10417056,10417057,10417058,10467122,10123167,9199033,9199034,9199035,9199036,9199037,9199038,9199039,10467796,9175255,9207632,10466317,10466323,10462517,9176200,9192218,10903557,10894115,10883283,10886391,10886392,10886393,10886394,10886395,10886396,10886397,10886398,10886399,10886400,10886401,10886402,10886403,10886404,10886405,10886406,10886407,10886408,10886409,10886410,10886411,10886412,10886413,10886414,10886415,10886416,10886417,10886418,10886419,10188046,10188048,10173116,10173120,10173121,10892208,10892209,10163475,10602173,10602174,10647551,10603684,10529861,10550357,10550358,10498392,10423617,10423620,10420850,10506825,10486954,10412540,10412581,10414829,10487543,10487544,10478866) 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>