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(8628626,8628627,8628634,8628724,8628725,7202683,7202684,8629164,8629166,8629173,8629174,8629177,8629178,8629188,8629250,8629303,8629393,8629396,8629472,8629523,8629525,8629559,8629585,8629617,8629618,8629619,8629620,8629621,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,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,8627581,8627582,8627583,7201200,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,8627707,8627708,8627709,8627710,8627711,8627712,8627713,8627793,8627795,8627796,8627797,8627801,8627802,8627821,7198681,7198696,7198697,7198710,7198711,7198714,7198716,7198724,7198742,7198743,7198749,7198750,7198760,7198762,7198770,8625879,8626201,8626211,8626212,8626227,8626234,8626248,8626253,8626469,3237391,3237392,8626749,8626750,8626751,8626752,8626753,8626834,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,8624379,8624389,8624397,8624449,8624681,8624682,8624683,8624684,8624688,8624690,8624691,8624692,7198381,10853141,10853335,10853411,10866566,10866569,10866570,10866571,10866572,10866573,10866574,10866576,10866577,10866578,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,8633279,8540589,8540591,8634411,8634412,8634451,8634452,8634453,8634454,8634455,8634541,8634542,8634543,8634544,8634545,8634546,8634811,10852524,8634899,10852572,8632190,8632191,8632192,8632193,10849868,10849869,8632480,8632490,8632495,8632496,8632497,8632500,8632502,8632503,8632538,8632540,8632627,10425386,10425391,10425555,8632862,8632863,8632864,8632866,8632867,8632868,8632869,8632878,8632879,8632881,8632884,8632908,8632909,8632910,10620195,10620196,10620197,10620198,10620199,10615341,8630753,8630756,8630912,8630918,8630993,8631003,10616417,10616426,8631476,8631477,8631478,8631479,8631630,8583487,8631678,8631712,8631856,8631857,8631858,8631859,10616888,6666259,10612938,10612939,10613736,8849329,8849378,8848024,10893984,10893985,10893986,10893987,10893988,10889231,10883415,10886057,10886058,10886059,10886060,10887096,10887097,10611408,10604146,10409350,10407369,10407370,10409501,10408988,10409025) 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>