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(3228994,7065991,7065992,7065993,8631733,8631734,10861172,10861173,10861174,10861175,10861176,10861177,10861178,10861179,10861180,10866356,10866357,10866358,8595180,10859600,10857503,10857504,10857505,10857506,10857507,10857508,10857509,10857510,10857511,10857512,10857513,10857514,10857515,10857516,10857517,10857518,10857519,10857520,10857521,10857522,10857523,10857524,10857525,10857526,10857527,10857528,10857529,10857530,10857531,10857532,10857533,10857534,10857535,10857536,10857537,10857538,10857539,10857540,10857541,10857542,10857543,10857544,10857545,10857546,10857547,10857548,10857549,10857550,10857551,10857552,10857553,10857554,10857555,10857556,10857557,10857558,10857559,10857560,10857561,10857562,10857563,10857564,10857604,10857605,10857606,10857607,10857608,10857609,10857610,10857611,10857612,10857613,10857614,10857615,7198753,7198754,7198755,7198756,10864086,10864087,10864088,10864089,10864090,10864091,10864092,10864093,10864094,10864095,3923486,3923487,3923488,3923489,11046105,11046106,10854262,7197947,7197948,7197949,7197950,7197951,7197952,7197953,7197954,7197955,7197956,7197957,7197958,7197959,10615507,10426010,10611146,10611147,10611148,10611149,10611150,10611800,10611816,8851469,8851480,8566606,8566607,10613168,10610290,10613349,10117837,10117838,10117839,10117957,9912966,8850867,9168338,9168339,9168340,9168341,9168342,9168343,9168344,9168345,9168346,6672559,6672691,6673152,9911272,10468360,10888562,10174937,10174938,10174940,10884612,10884675,10875019,10890069,10183943,10183944,10883318,10883319,10188062,10507687,10507688,10507689,10507690,10507691,10507692,10507700,10507701,10507702,10410023,10414036,10412191,10412192,10412193,10415157,10415158,10415159,10415160) 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>