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(10939654,10861790,10849070,10862922,10862923,10861038,10866650,10866651,10867411,10857175,10857176,10857177,10857178,10857179,8627231,8627270,10864144,10856751,8860439,7196248,7196249,7196250,10615061,10850584,10850585,10850586,10850587,10850588,10850589,10850590,10850591,10850592,10850593,10850594,10850595,10850596,10850597,10850598,10850599,10850600,10850601,8634192,8634193,8634194,10614441,8852311,8852826,8852833,8852834,8852835,8852836,8852837,8852838,8852839,8852840,8852841,8852842,8852843,8852844,8852845,8852846,8852847,8852848,8852849,8852850,8852851,8852852,10610723,8849419,8849420,8849421,8849422,8849423,7015716,7015717,7015718,7015719,7015720,7015721,7015722,7015723,7015724,7015725,7015726,7015727,7015728,7015729,7015730,7015731,7015732,7015733,7015734,7015735,7015736,7015737,7015738,7015739,7015740,7015741,7015742,7015743,7015744,7015745,7015746,7015747,7015748,7015749,7015750,7015751,7015752,7015753,7015754,7015755,7015756,7015757,7015758,7015759,7015760,7015761,7015762,7015763,7015764,7015765,7015766,7015767,7015768,7015769,7015770,7015771,7015772,7015773,7015774,7015775,7015776,7015777,7015778,7015779,7015780,7015781,7015782,7015783,7015784,7015785,7015786,7015787,7015788,7015789,7015790,7015791,7015792,7015793,7015794,7015795,7015796,7015797,7015798,7015799,7015800,7015801,7015802,7015803,10118347,7015804,7015805,7015806,7015807,7015808,7015809,7015810,7015811,7015812,7015813,7015814,7015815,10118596,10118597,8552221,7014220,7014221,10420202,10469453,6667453,976353,10889912,10889913,10889914,10887795,10876804,10876805,10876806,10411667,10407886,10407887,10407888,10407889,10407890,10407891,10407892,10407893,10407894,10407895,10407896,10411990,10411991,10411992,10411993,10411994) 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>