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(10862005,7065915,7065981,8067928,3227396,3227397,3227399,3227400,8628003,8628004,8628024,8628025,8628026,10858746,10858763,10858783,10858814,10858820,8595193,10858996,5654676,5654677,10859669,10859671,10859673,10859674,10844339,10857168,3237351,10865442,10865572,10865573,10865578,10865582,10865583,10865586,10865587,10865591,10865592,10865595,10865598,10865600,10865601,8626974,10865625,10865627,10865628,10865632,8626991,10865634,10865635,8627052,8627057,8627058,7200714,8627116,7200881,7200936,7200937,7201004,7201005,10863116,10863117,10863901,10863902,7198889,10864086,10856184,10864222,10864224,10864229,10856569,10101578,8860436,8905895,10623333,10623427,10853721,10853722,10853724,10853727,7196925,7196926,7197843,7197847,7197848,7197852,7197854,7197855,8624440,10617014,10617119,10617144,10617145,10617146,8553747,8632620,9217086,9217087,9217088,10850788,10850789,10850790,9217218,10615952,10426291,8540604,10426471,8611237,10616563,10614089,10614289,10611363,10614492,10122061,10611772,10611898,10611899,10611900,10611901,10611902,10611903,10611904,10611905,10612186,10612187,10612188,8851653,8851654,10612575,10612578,8851773,10609715,10609716,10612941,10613000,10613001,10613002,10613003,8852377,10610268,10610349,10613380,10610484,10610498,10610499,8852729,8852846,8852864,8852865,8852866,8852887,8853016,8849409,8849410,8849411,10117798,9169692,10118674,10417340,10417341,10417554,10417556,10417558,10417560,10416665,10416666,10418733,10415786,10418806,10418811,10418815,10418816,10418818,10418819,10418822,10418826,10418828,10418829,10418855,10418857,10418858,10418862,9169264,9161289,10468500,10468516,10468517,10470631,10888538,10879919,10879920,10627720,10626263,10626264,10626445,10887436,10603850,10603851,10603852,10603853,10604436,10604456,10604459,10604556,10604610,10604611,10604644,10604660,10604674,10604688,10604702,10544010,10544011,10544012,10544013,10544014,10544015,10544016,10544017,10544018,10544019,10538380,10538381,10538382,10538383,10507629,10507630,10507631,10507632,10507777,10507922,10413274,10411281,10413291,10413292,10413324,10413344,10407359,10413364,10413369,10413484,10413501,10411588,10409740,10409741,10409743,10409746,10411983,10408024,10408025,10408026,10414099,10414103,10414104,10410625) 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>