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(8067426,10872299,10872300,10872301,10872302,10872303,10845590,10845591,10845592,8559122,8559123,8559124,8559125,8559126,8559127,8559128,8559129,8559130,8559131,8559132,8559133,10103830,10103831,10103832,3899466,8618945,8618946,8596116,7073679,7073680,7073681,7073682,10942644,10942645,10942646,10942647,11011329,11011330,11011331,11011332,11011333,11011334,11011335,11011336,11011337,11011338,11011339,11011340,6000105,6000106,6000107,6000108,3235540,3235541,3235542,3235543,3235544,10944788,3655963,3655964,3655965,3655966,3655967,3655968,8565189,8073460,8576411,8576412,8576413,8576414,8576415,8576416,8576417,8576418,8576419,8576420,3582189,8864557,8864558,8864559,8568678,8568679,7058519,7058520,7058521,7058522,9220498,2809651,8552474,6679295,9199314,9199315,9199316,9199317,9199318,9199319,9199320,9199321,9199322,9199323,9199324,9199325,9199326,9199327,9199328,10123806,10123807,10123808,10123809,10123810,8550881,8917697,8917698,8594398,8594399,8594400,8594401,10628893,10628894,10628895,10628896,10176585,10176586,10176587,10176588,10176589,10911957,10911958,10911959,10911960,10911961,10911962,10911963,10911964,10652664,10652665,10567483,10567484,10567485,10567486,10567487,10567488,10567489,10567490,10567491,10567492,10567493,10567494,10567495,10423453,10423454,10423455,10423456,10423457,10493064,10493065,10493066,10493067,10493068,10493069,10493070,10493071,10493072) 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>