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(10250106,10250107,10250108,10250109,10198481,10198482,10198483,10251127,10844963,8910590,10234652,10101306,10101558,10196384,10102075,7073438,7073720,10839439,10839640,10218433,10866202,7156543,8554591,8907103,10850680,10229175,10229176,10229177,10229178,10229179,10229180,10229181,10229182,10229196,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,10618284,10864067,8540618,9217879,9217880,8541152,10851987,10851988,10851989,10851990,10851991,10851992,10851993,10851994,10851995,8904782,8541471,10204698,8611880,8541653,10849661,10928193,10928194,10848035,10848036,10848037,10848038,10848039,10848040,10848041,10848042,10620098,10845420,9214343,10845573,10930138,10188328,10431323,10431325,9215785,9189556,9197762,9197763,9197775,9197776,9197777,8864514,9171408,9195919,9195958,9172010,9172011,9172012,9172013,9172014,9212107,9188212,7058447,7058543,9188528,9188529,9189165,9189166,9189287,9189288,9193548,9185601,9185633,9161754,9193847,10517673,10517674,10517675,9170390,9162419,6674800,6674803,7056924,9187293,10419311,9168495,10116695,10417444,9174841,9199021,9175137,8916886,9199336,9175955,9175956,9176290,10628540,10879846,10879847,10905288,10657940,10910880,10910881,10891236,10876666,10912141,10912142,10601379,10583485,10583486,10583548,10606743,10606744,10606745,10606746,10606747,10606748,10609839,10590991,10648834,10529875,10524075,10524076,10522398,10522515,10522516,10538725,10510154,10510155,10510418,10510419,10510420,10510421,10507491,10507492,10509503,10509527,10510544,10510545,10510546,10510547,10510605,10509654,10509817,10509849,10509850,10509851,10509852,10509870,10509871,10509874,10509911,10509937,10509938,10413683,10407942,10408662,10408663,10408664,10408665,10408666,10408667,10408668,10408669,10408670,10407209) 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>