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(7075996,11014714,11014715,11014716,11014717,11014718,11014719,11014735,11014736,11014737,11014738,11014739,11014836,11014839,11014840,11014892,11015355,11015356,11015357,11015358,11015359,11015383,11015384,11028697,11028698,11028699,11028700,11028701,11028702,11028805,11028806,11028807,11028808,11028809,11028810,11028824,11028825,11028826,11028827,11028828,11028829,11028830,11028831,11028832,11013685,11013809,8837666,11014442,11014466,11014467,7201415,11012747,11012748,11012770,11012771,11012772,8836751,8619325,11026205,11026206,11013207,11026207,11013208,11026208,11026209,11026210,11026211,11013226,11026306,11026307,11026308,11026309,11026334,11026335,8837284,8837285,11013530,11013531,11013532,11013536,11013537,11023750,11023962,11023963,11022288,11022289,11022290,11022291,11022292,11022293,11022294,11022295,11022715,11023007,11023008,11023213,3927057,10971370,10971371,10971442,10971443,10971444,10971447,11006638,11006639,11019650,11019651,11032662,11032663,11032664,11032665,11032666,11032667,11032668,11032669,11032670,11032680,10918648,11006803,11006804,10918686,11032905,11032906,11032934,11020076,11020333,11020334,11020335,11020336,11020337,11020364,11020365,11020366,11021211,11021212,11021252,11021253,10920384,10920385,10920386,10920387,10920388,10920389,11005634,11005635,11005644,11005645,10917613,10917614,10917615,10917616,10917617,10917618,10917619,10917620,10917621,10917622,10917623,10917624,10917625,11005778,10917641,10917855,10917870,11006018,11019260,11019261,11019262,11019263,11019264,11019265,11019266,11019267,11019268,11019269,11019281,11019282,11019283,11019284,11019285,11019286,11019287,11019288,11019289,7156223,11006370,11006561,11006569,11019576,11019577,8576727,11004239,11004243,11004244,11004438,8576968,11030535,11030536,11030537,10916608,10916609,10916610,10916611,10916612,10916613,10916614,10916615,10916616,10916617,10916618,10916619,10916620,10916621,10916710,10916711,10916712,10916713,10916714,11018008,11018009,11018010,11018011,11018012,11005013,11005025,11031084,11031089,11005111,11018116,11018117,11018118,11018119,11018120,11018121,11018122,11018123,11018124,11018125,11018126,11018127,11018128,11018129,11018130,11018131,11018132,11018133,11018134,11018135,11018136,8577680,10917349,6677703,6677706,9916006,6678071,6678083,8864742,9916487,6678487,8542783,9914017,9201410,9201424,8849264,8849269,9169841,9201860,8593036,8849829,8849870,9202358,9203023,9203024,9203092,9203097,10517029,10517030,10517031,10517032,4973256,6680646,6680821,8848553,8848570,9176821,6673049,9200908,9201099,8865068,10469586,10469599,10115633,10470040,6679729,6679814,9200132,10179600,10913600,10913603,10174798,10913812,10913813,10913814,10913822,10914290,10914291,10914292,10914293,10914294,10914295,10914322,10914323,10914324,10914325,10914326,10914327,10914330,10914331,10914332,10914530,10914735,10915179,10915180,10915181,10166373,10166374,10178977,10178978,10178979,10178980,10178981,10178982,10178983,10178984,10178985,10179065,10179066,10179067,10179068,10179076,10179077,10179078,10179079,10888128,10166511,10166512,10167025,10877330,10602049,10574207,10574208,10574209,10602070,10602071,10574544,10608549,10608550,10568823,10568824,10568825,10568826,10653050,10653051,10572819,10572820,10572821,10572822,10572823,10572824,10572825,10572826,10572827,10572828,10572841,10572842,10575943,10575944,10575945,10575946,10575947,10575948,10606980,10601660,10570925,10570926,10570927,10570933,10570934,10570935,10493653,10493654,10493655,10493656) 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>