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(8630779,8630780,8630781,8630782,8630783,8630918,8574502,8631046,8631047,8631048,8631049,8631600,8631602,8631605,8631812,8631828,8631857,8631868,8631870,8631872,8631890,10862795,8632192,8632303,8632312,8632323,8632329,8632332,8632343,8632352,8632464,8629625,8629877,10860531,8629982,8629990,8629992,8629997,8630023,8630025,8630027,8630030,8630149,8630150,8630152,8630153,8630157,8630159,8630160,8630163,8630165,8630166,8630167,8630168,8630169,8630197,8630209,8630387,10861152,10861153,8627707,8627710,8627712,8627785,8627786,8627787,8627788,8627852,7201453,8627853,8627854,8627855,8627856,8627881,8627883,8627935,8627936,10866640,8628047,8628058,7201974,8628575,8628612,8628613,8628614,8628615,8628627,8628724,8628725,10859526,8629257,8629261,8629399,8629403,8629404,8629409,8629413,8629520,8626672,8626673,8626702,8626896,8626898,8626899,8626900,8626901,8626915,8626926,8626932,8627010,8627089,8627090,8627107,8627120,10857890,10857891,10865941,10865944,10866015,10866016,8627499,10863522,10863545,10855576,10855577,10855578,8625083,7198684,8625085,8625094,8625096,8625098,8625100,7198700,7198701,8625104,7198710,7198711,7198712,7198713,7198714,7198717,7198720,8625127,8625128,7198728,7198729,7198736,7198737,7198738,7198742,7198743,7198759,7198762,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,8626057,8626064,8626065,8626321,8626324,8626329,8626332,8626334,8626339,8626342,8626344,8626346,8626375,8626429,8626430,8626431,8626432,8626435,8626444,8626445,8626446,8626447,8626448,8626465,8626466,3927233,10853411,10854361,7197602,8624348,8624402,8624415,8624535,8634623,8634633,8634638,8634779,8634781,8634783,8634786,8634791,8634792,8634845,8634892,10617324,8634960,8542165,8632637,8632638,8632639,8632697,8632741,10425555,8632837,8632844,3581873,8633172,8633189,8633217,8633233,8633326,8633328,8633329,8633330,8633341,8633342,8633548,8633553,8633562,8633575,10426445,8634170,8634356,8634357,8634358,8634458,8634459,8634460,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,10616911,8634530,8634531,8634532,8634533,8634534,8634537,8634538,8634539,8634540,10610984,10610985,8853216,8853227,6669828,10611365,10614501,10609287,10612381,7017945,7017954,7017965,7017974,7017985,7017994,8567072,10610479,10610480,10610481,6673532,6673548,8849378,9911858,9169964,6674249,9912378,9170828,8848124,8848157,10416358,10419514,6672898,8848916,10417057,10417078,10419110,10419113,10419169,10419170,10419171,10419177,9168121,8847998,8848003,8848006,8848014,8848018,8848021,8848024,8848028,8848034,8848036,8848062,8848067,8848103,8848116,10883570,10883571,10883588,10889622,10890111,10883429,10162091,10187807,10602162,10602165,10602166,10602171,10602176,10602182,10602184,10602194,10602195,10602236,10603684,10601693,10601694,10601702,10413982,10410740,10410741,10410742,10414812,10415152,10415153) 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>