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(8630753,8630756,10861439,10861440,8630912,8630918,8630993,8631003,8631476,8631477,8631478,8631479,8631630,8583487,8631678,8631712,8631856,8631857,8631858,8631859,8632190,8632191,8632192,8632193,10849869,8632480,8632490,8632495,8632496,8632497,8632500,8632502,8632503,8632538,8632540,8629585,8629617,8629618,8629619,8629620,8629621,8629622,8629670,8629741,8629742,8629754,8629755,8629756,8629832,8629834,8629836,8629838,8629841,8629843,8629849,8629852,8629854,8629856,8629863,8629865,8629868,8629870,8629873,8629881,8629913,8629915,8629917,8629920,8629921,8629923,8629925,8629930,8629932,8629934,8629936,8629938,8629939,8629942,8629945,8629947,8629950,8629953,8629957,8627581,8627582,8627583,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,8627707,8627708,8627709,8627710,8627711,8627712,8627713,8627793,8627795,8627796,8627797,8627801,8627802,8627821,7201453,8628626,8628627,8628634,8628724,8628725,8629250,8629303,8629393,8629396,8629472,8629523,8629525,8629559,3237391,3237392,8626749,8626750,8626751,8626752,8626753,8626834,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,8627050,8627052,8627055,8627056,8627057,8627058,8627059,8627060,8627061,8627064,8627065,8627066,8627068,8627072,8627074,8627075,8627083,8627084,8627089,8627090,8627093,8627094,8627099,8627106,8627107,8627108,8627109,8627110,8627112,8627117,8627119,8627120,8627121,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627530,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8624681,8624682,8624683,8624684,8624688,8624690,8624691,8624692,7198696,7198697,7198710,7198711,7198714,7198716,7198728,7198742,7198743,7198749,7198760,7198762,7198772,8626201,8626211,8626212,8626227,8626234,8626248,8626253,8626319,8626320,8626321,8626322,8626323,8626324,8626325,8626326,8626327,8626328,8626329,8626330,8626331,8626332,8626333,8626334,8626335,8626336,8626337,8626338,8626339,8626340,8626341,8626342,8626343,8626344,8626345,8626346,8626347,8626348,8626349,8626469,8624379,8624389,8624397,8624400,8624449,8634685,8634686,8634811,8634899,10617324,10425553,10425555,10425577,8632862,8632863,8632864,8632866,8632867,8632868,8632869,8632878,8632879,8632881,8632884,8632908,8632909,8632910,10615338,8633186,8633187,8633188,8633189,8633190,8633191,8633192,8633193,8633194,8633195,8633196,8633197,8633198,8633199,8633200,8633201,8633219,8633220,8633221,8633222,8633223,8633224,8633225,8633226,8633227,8633228,8633229,8633230,8633231,8633232,8633233,8633234,8633272,8633273,8633274,8633275,8633276,8633277,8633278,8633279,8540589,8540591,8634411,8634412,8634443,8634444,8634445,8634451,8634452,8634453,8634454,8634455,8634541,8634542,8634543,8634544,8634545,8634546,10611408,8849319,8849320,8849321,8849322,8849323,8849329,8849378,10118342,8848124,8848157,10415375,10415376,8848725,8848726,8848728,8848746,8848747,8848756,8848760,8848761,8848767,8848782,8848843,8848845,8848866,8848877,8848889,8848909,8848911,8848920,8847268,8847273,8847274,8847310,8847478,8847480,8847493,8847496,8847500,8847511,8847514,8847529,8847541,8847542,8847584,8847613,8847998,8848003,8848006,8848014,8848018,8848021,8848024,8848028,8848034,8848036,8848062,8848067,8848103,8848116,10883568,10883627,10883629,10893984,10893985,10893986,10893987,10893988,10886057,10886058,10886059,10886060,10602171,10602176,10602182,10602185,10602191,10602197,10602198,10602696,10602697,10602700,10602704,10602705,10603684,10601686,10601687,10601693,10601695,10601702,10601704,10407370) 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>