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(8628997,8628998,8629324,8629332,8629336,8629337,8629514,10860277,10860278,10860279,8629638,10860280,10860281,8629639,10860282,8594787,8594788,7198677,7198678,7198679,7198680,7198681,7198682,7198683,7198684,7198685,7198686,7198687,7198688,7198689,7198690,7198691,7198692,7198693,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198705,7198706,7198707,7198708,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198732,7198733,7198734,7198735,7198736,7198737,7198738,7198739,7198740,7198741,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198758,7198759,7198760,7198761,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198771,7198772,7198773,8624366,8624367,8624368,8624369,8624370,8624371,8624372,8624373,8624374,8624375,8624376,8624377,8624378,10838804,8860428,3234503,3581866,10850886,10850887,10850888,10850889,10850890,10850891,10850892,10850893,10850894,10850895,10850896,10850897,10850898,10850899,10850900,10850901,10850902,10850903,10850904,10850905,10850906,10850907,10850908,10850909,10850910,10850911,10850912,10850913,10850914,10850915,10850916,10850917,10850918,10850919,10850920,10850921,10850922,10850923,10850924,10850925,10850926,10850927,10850928,10850929,10850930,10850931,10850932,10850933,10850934,10850935,10850936,10850937,10850938,10850939,10850940,10850941,10850942,10850943,10863003,10863004,3228942,10861817,10861828,10612320,10612321,8851564,8862529,10612788,8851975,8851976,10613332,10613333,10613334,10613335,10613336,10613337,10117812,10117813,10117814,10117815,10117816,8849705,8849706,9169941,8850962,6670853,6670854,8550009,10470096,10468336,10116224,10116225,10116226,10116227,10116228,10116229,10116230,10116231,10116232,10116233,10116234,10116235,10116236,10903862,10883943,10883944,10889321,10884502,10884503,10884504,10884505,10884506,10884507,10890222,10877480,10877481,10877482,10877483,10877484,10877485,10877486,10877487,10608610,10611691,10611692,10611693,10611694,10604385,10508547,10508548,10508549,10415664,10415673,10507803,10408086,10408087,10408088,10408089,10408090,10408091,10408092,10408093,10408094,10408095,10408096,10408097,10408098,10408099,10408100,10408101,10408102,10408103,10408104,10408105,10408106,10408107,10408108,10408109,10408110,10408111,10408112,10408113,10408114,10408115,10408116,10408117,10408118,10408119,10408120,10408121,10408122,10408123,10408124,10408125,10408126,10408127,10408128,10408129,10408130,10408131,10408132,10408133,10408134,10408135,10408136,10408137,10408138,10408139,10408140,10408141,10408142,10476334,10476335,10476336,10476337) 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>