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(8630661,8630662,8630698,8630710,8630724,8630729,8574467,8574474,8574475,8574486,8574487,8574492,8574493,8574507,8574516,8574517,8574518,8574521,8630993,8630994,8630995,8574528,8630996,8631013,8631064,8631485,8631486,8631487,8631510,3229285,10868598,8609602,8632548,8630356,10972981,10972995,10972999,10973002,10973003,10973004,10973020,10973021,10973022,10973030,8628836,8628837,3227260,3227261,8626594,8627059,8627351,3655602,3655603,3655604,8624774,11035922,11010506,11046090,11046615,11046616,3924347,11046901,11047040,11047041,3924813,11047253,11047269,8907881,8541669,10425388,10425391,10425483,10425551,10425578,10425580,10425583,10425584,8633208,10425934,8633241,8633266,10426016,10930733,10930737,10426194,3232241,8853320,8853326,8853336,8853347,8853355,8853356,8853372,8853383,8853389,8851257,8851444,9914116,9914117,9914226,10557972,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,9204757,9197133,9197135,8849319,8849329,9185656,9171077,9171078,8850907,8850935,8851105,8851106,8848726,8848760,8848761,8848843,8848866,8848889,10463023,10467125,10467146,10463587,10463588,10463648,10463649,10463650,10463651,10463652,10465682,10465683,10465684,10465685,10463730,10463741,10463742,10463743,10463744,10465759,10465760,10463768,10463769,10463770,10465770,10463771,10465796,10465797,10465798,10465799,10465800,10465857,10465858,10465859,10465860,10463876,10463877,10465913,10466206,10466207,10466208,10466209,10466210,8847511,10466303,10466304,10466310,10466311,10462312,10466312,10462313,10466343,10466344,10466345,10466346,10466402,10466403,10466404,10466405,10462406,10462407,10462408,10462426,9167850,10462427,10462428,10462472,10462473,10462581,10462582,10462583,8848014,8848024,10466850,9168281,10893756,10882987,10882988,10882989,10882990,10883045,10166781,10166875,10167031,10167040,10167041,10167042,10167043,10167045,10167122,10167125,10167126,10167127,10167128,10167305,10167307,10167308,10167310,10167311,10167312,10949382,10949383,10949384,10626124,10896985,10603684,10522404,10522459,10522460,10522461,10522466,10522467,10522468,10425325,10421097,10483159,10483160,10714524,10714736) 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>