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(11014714,11014715,11014716,11014717,11014718,11014737,11014738,11014739,11014839,11014840,11014892,10846138,11002109,9215265,9215266,9215267,9215268,9215269,9215270,8574844,11015355,11002363,11015383,11015384,11028824,11028825,11028826,11028827,11028828,11028829,11028830,11028831,11028832,11042364,7066703,8619784,8837666,11039886,7067655,9214415,11014467,7201321,7064308,10986582,11012771,11012772,8836751,11013226,11026334,11026335,8629549,3927384,7071009,8557993,8558065,10102378,10102381,10102382,11034917,3925688,11022294,11022715,11035915,11023007,10841376,10841377,10841378,3927057,10971371,10971444,10971445,10971447,11006638,11006639,11032662,11032663,11032664,11032665,11032666,11032667,11032668,11032669,11032670,11032680,10918648,11006803,11006804,11032905,11032906,11032934,11033043,11033044,11020076,11033227,11033228,11033229,11033230,11033231,11033232,11033233,11033234,11033235,11033236,11033237,11033238,11033239,11033240,11033241,11033242,11020335,11020364,11020365,11020366,11033403,11033404,11033513,10919432,10919433,8613891,11033869,11034055,11021253,10920384,10920385,10920386,10920387,10920388,10920389,7198134,11005644,11005645,8578138,10917614,10917615,10917616,10917617,10917618,10917619,10917620,10917621,10917641,11006018,10917870,10917985,11019260,11019261,11019262,11019264,11019281,11019284,11019285,11019286,11019287,11019288,11019289,7156223,11006370,11006561,11006569,11019576,11019577,8576727,11004239,11004243,11004244,11004438,8576945,11004603,10978635,10978636,10978637,10978643,10916608,10916609,10916610,10916611,10916612,10916613,10916619,10916620,10916710,11018011,11018116,11018117,11018119,11018120,11018121,11018122,11018123,11018126,11018127,11018128,11018129,11018130,11018131,11018132,11018133,11018134,11018135,11018136,8577680,8577700,8577725,10621705,10621706,10621707,10621710,10621714,10621716,10917349,8853157,6669910,9916007,6678083,8864742,9916487,6678487,8851483,8851485,8851496,8851499,8851500,8851503,8851511,8851515,8851516,8851517,8851519,6676383,9180354,10610019,9201423,9201424,4974386,9201777,9201778,8849829,8849870,7056354,7056472,9203024,9203092,9203097,8848189,8848190,6680647,6680804,6680821,9176821,6673049,8848905,8848906,9201108,3963632,10115633,10470040,9175517,6679815,8847605,8847606,10179600,10179601,10179602,10179603,10913600,10913603,10883653,10898713,10913813,10913814,10913822,10169881,10169882,10169894,10169895,10169896,10169898,10169902,10169903,10169905,10914292,10914293,10914294,10914295,10914322,10914323,10914324,10914325,10914326,10914328,10914330,10914331,10914332,10904669,10914743,10905105,10905106,10905107,10905108,10915179,10915180,10915181,10627000,10178979,10178981,10178985,10179066,10179069,10179070,10179071,10179073,10179074,10179075,10179076,10179077,10179078,10179079,10179080,10179081,10179082,10179083,10179084,10179085,10179086,10179087,10179088,10179089,10913078,10179090,10167025,10881506,10896702,10168090,10168091,10168092,10168102,10168103,10168105,10168119,10168127,10168135,10168136,10168137,10168138,10571180,10602049,10574208,10574209,10602069,10602070,10602071,10574242,10574243,10574244,10574544,10574550,10608549,10608550,10587079,10569648,10569649,10569650,10569651,10572841,10572842,10572843,10572844,10572845,10572846,10572847,10572848,10572849,10572850,10575943,10575944,10575945,10575946,10575947,10575948,10570923,10570938,10570939,10524173,10524174,10524175,10524256,10480929,10480930,10480931,10479557,10479558,10493653,10493654) 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>