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(10848640,10848641,10848642,10848647,10848648,10861670,10848742,10848869,10848939,10849166,10849232,7074777,10863154,10861113,10866367,7201988,7201989,7202014,7202015,7202243,10859310,10859679,10859680,10859682,7202709,7202710,7200482,7200483,7200747,7200748,7200749,7200750,7200778,7200781,8910623,8910624,8910646,7200910,3235778,7198706,7198707,7198709,7198737,7198738,7198746,7199036,7199058,10864217,8625588,8625589,8625590,8625591,10864446,10864452,10864457,10864467,10864473,7199546,10864770,10864833,10853739,7196699,8906818,10838900,7197412,8907405,8907459,8907473,3234986,3235104,7198069,8907909,7198150,7198169,10622405,10622408,10622429,8905476,3922921,10954388,10853070,8905954,10615165,10851048,10615838,10615839,10615856,10615864,10615865,10426277,10426281,10426288,10426289,10426296,10426308,10426312,10426364,8540619,8904285,8904405,10616852,8904951,10614117,8853336,8853337,10614177,8853339,10614411,10611462,10611464,10611465,10611466,10611469,10611472,10611475,10611485,10611488,10611489,10611494,10611497,10611498,10611506,10611508,10611509,10611510,10611670,10612018,10609259,8851447,10612345,10612462,10612463,10612845,10609990,10613584,10613599,10613606,10613693,10610846,10610851,8853114,6673528,6673622,6673628,8849319,8849320,8849324,8849325,8849329,8849331,6673816,6673843,6673939,9912040,6674112,6674123,6674131,10118180,10118654,9912816,8850516,8850615,8850616,8850719,9913167,9913168,8850909,8850911,8850912,8850913,8850914,8850915,8850916,8850917,8850919,8850920,8850922,8850923,8850924,8850926,8850927,8850929,8850930,8850931,8850932,8850934,8850935,8850936,8850940,8850941,8850945,8850953,8850954,8850960,8850968,8850970,8850976,8850978,8850980,8850986,8850991,8850992,8850993,8850997,8851003,8851014,8851018,8851029,8851032,8851034,8851039,8851042,8851049,8851056,8851060,8851063,8851067,8851071,8851083,8851087,8851099,8851103,8851105,8851111,8851112,8851120,8848124,10419372,10416386,6672808,10415543,10417549,6672837,9168671,9168688,6672907,10416703,10417757,10417763,10417768,10417778,10417784,8848717,8848728,8848734,8848746,8848756,8848761,9168945,8848775,8848779,8848782,6673170,8848797,6673181,8848821,8848829,8848830,8848835,6673217,8848836,8848843,8848845,8848875,8848913,10418086,10117387,10117388,10418155,8550102,8550181,8847295,9167553,10470218,8847493,10470272,10470287,10470288,8847541,8847542,8847545,10470347,10470359,10470360,10470361,10470384,10470394,10470440,10470453,10470510,10470511,10470577,10470578,10470600,10470601,10468685,10468741,8848034,9168269,8848102,8848103,8848107,8848108,8848116,10883629,10884019,10889250,10889251,10889297,10889298,10889299,10889300,10889301,10884716,10889902,10889904,10890005,10890047,10890069,10885353,10632108,10632110,10887870,10883126,10883127,10883128,10883129,10883400,10876815,10876817,10886985,10887005,10887304,10643545,10643546,10643547,10643551,10602482,10602483,10602498,10602694,10602695,10602696,10602697,10602698,10602699,10602709,10602723,10602727,10602728,10602739,10644404,10647704,10604196,10604197,10604202,10604203,10604211,10604216,10601554,10601868,10521186,10507967,10409307,10413357,10413522,10413741,10414109,10414110,10414112,10408164,10497064,10414724,10406901,10406902,10406903,10406908,10406909,10406910,10415055,10415056,10415057,10415119) 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>