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(8630810,8630811,7066106,10860725,10860732,10860753,10860757,10860763,10860764,10860767,10860770,10860771,10860773,10860774,10860776,10860778,10860783,10860794,10860801,10860803,10860822,10860824,10860828,10860837,10860838,10860840,10860841,10860842,10860843,10860845,10860847,10860848,10860853,10860854,10860855,10860856,10860858,10860859,10860861,10860862,10860865,10860867,10860870,10860871,10860872,10860873,10860875,10860881,10860882,10860883,10860886,10860887,10860889,10860891,10860892,10860893,10860894,10860895,10860896,10860899,10860901,10860903,10860904,10860905,10860906,10860907,10860923,10860926,10860927,10860934,10860935,10860937,10860966,10860970,10860974,10860975,5654624,7199005,7199008,7199012,8612652,3923467,10853411,3923566,10838834,8905766,8905767,10850371,8634445,10613964,10613980,10613981,10613985,10614018,10614038,10614048,10614049,10614055,8566689,8852018,8852019,8852020,10613819,10613824,10613844,10613899,10613903,10613910,10613924,10613926,10613930,10613954,10613956,10613959,10613960,10613961,6673699,9912657,9169053,9169054,9169063,9169065,9169079,9169086,10469378,10469380,10469384,976533,10884653,10886064,10886065,10886071,10886080,10886081,10886082,10162097,10886097,10886119,10886120,10886121,10886158,10886176,10886180,10886183,10886246,10886247,10886248,10886250,10886283,10886293,10886294,10886345,10886379,10886404,10886405,10886406,10886407,10886408,10886409,10886410,10886411,10886414,10886417,10886418,10886419,10886428,10886436,10886447,10886448,10886449,10886474,10886479,10886485,10886486,10886487,10886488,10886492,10886493,10886514,10886515,10886516,10886517,10886531,10886536,10886537,10886549,10886552,10886589,10886597,10886598,10886623,10886678,10886682,10886685,10886686,10886687,10886694,10886700,10886709,10886710,10886711,10886712,10886771,10886809,10886813,10886814,10886851,10886862,10886863,10647542,10647575,10508280,10414972,10414973,10414980,10414989,10414995,10414996,10414998) 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>