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(11014660,11014661,11014662,11014663,11014664,11014665,8068889,8068890,8068891,8068892,8068893,8068894,8068895,11028198,11028199,11028200,11015226,11015239,11015240,11015241,11015242,11015243,11028319,11028320,11028321,10848942,11041601,10847118,10847121,10847156,10437630,8575980,11013659,11013660,8837653,11012671,11012672,11025715,11025716,11025821,11025822,11025823,11025824,11013104,11013105,11013138,11013139,11013140,11013141,8619306,8619411,8837238,11013502,8560784,8560802,8560803,8560823,8619747,11024054,11024055,11024056,7198734,7198735,10944993,10944994,10944995,11035900,11035901,8616385,8616386,8616387,8616388,8616389,11006710,10919362,10920268,10920290,10925367,10925368,10925369,10925370,11005703,11005943,11005944,11005945,11019106,11019107,11006116,11006123,11019157,11006305,11006319,11006320,8542175,11019539,11032584,11032585,11032606,11030286,11030287,10916283,10916284,10916285,10916286,10916287,10916288,10916289,10916290,10916291,10916292,10916293,10916294,10916295,10916296,11017523,11017524,11017525,11017526,11017527,11017528,11017529,11017530,11017531,11017532,10916400,10916401,10916402,10916403,10916404,10916405,10916406,10916407,10916408,10916409,11017670,11017671,11017672,11017673,11017674,11017675,11017676,11017677,11017678,11017679,11017680,11017681,11017682,11017683,8577625,11005378,10917275,10917276,11005612,8568134,9915945,9915946,9915960,9916148,9916150,9916431,8849189,4974222,9201371,9209531,4974530,4974531,9202016,9202996,9202997,9202998,9200358,8848497,9200860,9201064,6679466,3963631,6679676,6679780,9207709,9207776,9207806,8551241,6680412,10179538,10179539,10179540,10179707,10174839,10178673,10178674,10178675,10178676,10178677,10178678,10178686,10178687,10178688,10913416,10913417,10177468,10882038,10574120,10574121,10601984,10601985,10601997,10571262,10571558,10571559,10568763,10568764,10568765,10608624,10608625,10572028,10572029,10572047,10601615,10601625,10525381,10525382,10492435,10493569,10487639) 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>