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(10861152,8630779,8630780,8630781,8630782,8630783,10861444,8630918,8631046,8631047,8631048,8631049,10871051,8631600,8631602,8583522,8631812,8631828,8631857,8631868,8631870,8631872,8631890,10862737,8632192,8632303,8632312,8632323,8632329,8632332,8632343,8632352,8629520,8629625,8629877,8629982,8629990,8629992,8629997,8630023,8630025,8630027,8630030,8630149,8630150,8630152,8630153,8630157,8630159,8630160,8630163,8630165,8630166,8630167,8630168,8630169,8630197,8630209,8630387,7201221,8627707,8627710,8627712,8627785,8627786,8627787,8627788,8627852,8627853,8627854,8627855,8627856,8627881,8627883,8627935,8627936,8628047,8628058,7201974,8628575,8628612,8628613,8628614,8628615,8628627,8628724,8628725,7202519,7202520,5654683,8629178,8629257,8629261,8629399,8629403,8629404,8629409,8629413,8626465,8626466,3927233,10857145,8626672,8626673,8626702,8626896,8626898,8626899,8626900,8626901,8626915,8626926,8626932,8627010,8627089,8627090,8627107,8627120,10857890,10865941,10865944,7198678,8625083,8625085,8625094,8625096,8625098,8625100,7198700,7198701,7198710,7198711,7198712,7198713,7198714,7198731,7198736,7198750,7198752,7198765,7198769,7198772,8625203,8625269,8625270,8625271,8625272,8625287,8625289,8625324,8625325,8625327,8625328,8625329,8625331,8625334,8625335,8625336,8625337,8625338,8625339,8625340,8625349,8625350,8625351,8625359,8625360,8625363,8625365,8625367,8625370,8625478,8625479,7199508,8626057,8626064,8626065,8626375,8626444,8626445,8626446,8626447,8626448,10853411,10854361,7197456,8624348,8624402,8624415,8634461,8634462,8634463,8634464,8634465,8634467,8634472,8634474,8634475,8634477,8634482,8634483,8634484,8634490,8634491,8634492,8634493,8634500,8634504,8634505,8634511,8634514,8634515,8634519,8634520,8634525,8634526,8634529,8634530,8634531,8634532,8634533,8634534,8634537,8634538,8634539,8634540,8541459,3232382,8634623,8634633,8634638,8634779,8634781,8634783,8634786,8634791,8634792,8634845,10617409,8634960,10852649,8542254,8632464,8632637,8632638,8632639,8632697,8632741,10425551,10425556,3581873,3581878,8633172,8633189,8633233,8633326,8633328,8633329,8633330,8633341,8633342,8633548,8633553,10616058,8633562,8633575,8634170,10616911,8634458,8634459,8634460,10610984,10610985,6669828,10614499,10614501,10612293,8566661,10612937,10612938,10612942,7017945,7017954,7017965,7017974,7017985,7017994,8567072,10610480,10610481,6673532,8849323,9169964,6674249,9912378,9170828,9913294,9913369,8848124,8848141,8848150,8848178,8848187,8848193,8848203,8848205,6672898,8848815,8848914,8848916,10419110,10419113,9167554,8847613,9167988,9168121,8847996,8848003,8848014,8848021,8848025,8848034,8848050,8848060,8848087,8848094,8848095,8848103,10883587,10883588,10884421,10890111,10890154,10890163,10887472,10883143,10886910,10168025,10168072,10887465,10602168,10602171,10602176,10602184,10602189,10602192,10603684,10603696,10422598,10506823,10508035,10409076,10415152) 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>