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(10870724,8631091,8631092,8631093,8631094,8631095,8631096,8631188,10846325,8631588,8631589,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632014,8632015,8632016,8632017,8632018,8632019,10951394,8629607,8629608,8629609,8629610,8629611,8629612,8629613,8629638,10869281,8629640,10869282,10869283,10869284,10869285,8629827,8629828,7201320,7201325,7201326,7201327,7201328,7201329,7201330,7201331,10842887,10842900,10842901,8627795,10842902,8627796,8627797,8627801,8627802,8627833,8627870,8627871,7201520,7201521,7201522,7201523,7201524,7201525,8628038,8628039,7201644,7201705,8836067,8911755,8628790,8629287,8629288,8629289,8629290,8629291,8629292,8629293,8629294,8629295,8629296,8629297,8629382,8629383,8629384,8629385,8629386,8629387,8629388,8629389,8629390,8629568,8629569,8629570,8629571,8629572,8629573,8629574,8626679,8626680,8626681,8626695,8626699,8626700,8626838,8625089,3926474,8626260,8626392,8626393,8626394,8626395,8626396,8626397,8626398,8626399,10618229,8634611,8634943,10620175,8632899,10615552,10848450,10848451,8633435,8633436,8633437,8633438,8633439,8633440,8633441,8633442,8633443,8633444,8633445,8633446,8633447,8633448,8540757,8540797,8540798,8540799,8540800,8540801,8540802,8540986,8540987,8540988,8540989,8540990,8540991,8540992,8540993,8540994,8540995,8540996,8540997,8540998,8540999,8541000,8541001,8541002,8541003,8634364,8634365,8634366,8634367,8634368,8634369,8634370,8634371,8634372,8634373,8634374,8634375,8634376,8634377,8634378,8634379,8634380,8634381,8634382,8634383,8634384,8634385,8634386,8634387,8634388,8634389,8634390,8634391,8634392,8634393,8634394,8634395,8634396,8634397,8634398,8634399,8634400,8634401,8634402,8634403,8634404,8634405,9198156,9198157,9198158,9198159,10609717,7058796,8850411,10119222,9176428,9183060,8855346,8855353,10908659,10631995,10631996,10631997,10631998,10631999,10632000,10627779,10626951,10626952,10598523,10602402,10580000,10580001,10580002,10422360,10421486,10421487,10421488,10421489,10421490,10424936) 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>