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(10858715,10858716,8595226,8595227,8595228,10859110,4970745,10857843,7201192,10857053,10857407,10857408,10857409,10857410,10857411,10857412,10857413,10839143,8541873,10866104,10866105,10866106,10866107,10866108,10866109,10866110,3923613,8860439,10854382,10838945,10838948,10838951,10863804,10863806,10863807,10863808,8540536,8540537,8541780,8905337,10617009,10617010,10617011,10863411,10863412,10863413,10615042,10615043,10615044,10615045,10615316,10615317,10615318,10615319,10615371,10615372,10615373,10615374,10615375,10615376,10615377,10615378,3228869,3228910,10431640,10431686,10612088,10612262,8566710,8852338,7055534,9169477,9169482,9169483,7055722,7055724,10117829,7055836,9912202,7015716,7015717,7015718,7015719,7015720,7015721,7015722,7015723,7015724,7015725,7015726,7015727,7015728,7015729,7015730,7015731,7015732,7015733,7015734,7015735,7015736,9912290,7015737,9912291,7015738,9912292,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,7015804,7015805,7015806,7015807,7015808,7015809,7015810,7015811,7015812,7015813,7015814,7015815,10118680,9912976,9913308,9913309,10419243,10419244,10419245,10419246,10419247,10419248,10419249,10417268,10417270,10417271,7054936,10416946,10416947,10416948,6673317,10469951,10469952,976474,10884577,10889910,10888350,10888402,10888403,10888404,10888405,10611764,10611765,10611766,10611767,10611768,10611769,10508197,10413257,10413258,10413612,10411909,10410110,10412148,10412149,10412150,10412151,10412432) 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>