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(8559122,8559123,8559124,8559125,8559126,8559127,8559128,8559129,8559130,8559131,8559132,8559133,10820543,10820544,10820545,10820546,10820547,10103830,10103831,10103832,7073679,7073680,7073681,7073682,8565189,8073460,8969103,8969104,8969105,3235540,3235541,3235542,3235543,3235544,6000105,6000106,6000107,6000108,7150859,8576411,8576412,8576413,8576414,8576415,8576416,8576417,8576418,8576419,8576420,3582189,10845590,10845591,10845592,10099133,3899466,10250808,10250809,10250810,10250811,10250812,10250813,10250814,10250815,10250816,10250817,10250818,8618945,10250819,8618946,8596116,8067426,7058519,7058520,7058521,7058522,9220498,2809651,8552474,8550881,8917697,8917698,3655963,3655964,3655965,3655966,3655967,3655968,6679295,9199314,9199315,9199316,9199317,9199318,9199319,9199320,9199321,9199322,9199323,9199324,9199325,9199326,9199327,9199328,10123806,10123807,10123808,10123809,10123810,8864557,8864558,8864559,8568678,8568679,10697132,10697133,10697134,10697135,10697136,10697137,10697138,10697139,10628893,10628894,10628895,10628896,10176585,10176586,10176587,10176588,10176589,8594398,8594399,8594400,8594401,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>