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(10861634,10861739,8569568,8569569,8583432,8583433,10950695,7201448,7201449,8595133,7201875,7202609,7202610,10857112,10857113,10857114,10857115,10857116,10857117,10857118,10857119,10857120,10857121,10857122,10857123,10857124,10857125,10857126,10857127,10857128,10857129,10857130,10857131,7200930,7200931,7200937,8908229,10856565,10958353,8905906,10854226,10854227,7197888,7197889,7197890,7197891,7197892,7197893,8905093,8905094,10622424,10622441,10622508,10615435,10615495,3581874,3581875,3581876,3581877,3581878,3581879,8611449,10611351,10611352,10611705,10611706,10611707,10611811,10614820,10614821,10614822,10614823,10614824,10612330,10612331,10612332,10612333,10612334,10612335,10612336,10612337,10612338,10612339,10612340,10612341,8851583,8851811,10609697,8566600,8566601,10610791,9169370,7015350,7015351,7015352,7015353,10117967,10117968,10117969,9912146,9912147,9912148,9912336,9912337,9912338,8850605,8850606,8850607,9913032,6672590,9168506,9168507,9168508,7014208,7014209,7014210,7014211,7014212,7014213,7014214,7014215,7014216,7014217,7014218,7014219,10415596,8550245,10468300,9167766,9167767,10468526,10468527,10468528,9168215,10888540,10174933,10174934,10884431,10884432,10884433,10884434,10884435,10884436,10884437,10884438,10885134,10885135,10885136,10885137,10885138,10885139,10885140,10885141,10885142,10885143,10885144,10885145,10887522,10887561,10882665,10882666,10632186,10161945,10161946,10162851,10626845,10626846,10626847,10602187,10589894,10589895,10601574,10601828,10425238,10507798,10411585,10411950,10411951,10411952,10411953,10411954,10411955,10411956,10411957,10411958,10411959,10409989,10409990) 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>