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(10873281,3228418,11027701,11027702,11027703,11027704,11027705,11027706,8838592,3228530,7076325,8621179,8621648,11041580,8622203,8622204,3229814,8622242,11042205,8561012,3227664,7067264,8620116,10872621,7075753,7075754,7075755,7075757,3238411,3238412,3238413,10985922,11025223,10960307,10960483,10843556,10843575,10843576,8836752,8560309,10867889,3927585,3927586,10865868,8910830,8970238,11034650,11034651,11034652,10940970,7198713,8615621,8615633,10856190,10856191,3236376,7199517,7199518,3656905,3656906,3656907,8557443,3236932,3237183,11006642,11006659,11006665,11006666,11006667,11006668,11006669,11006670,11006671,3233447,10928595,11046033,8554391,3233887,3233891,3233933,8554576,10618856,10838651,10854288,11046752,10619460,3925255,3925256,8541567,11019084,10617538,8612459,11006607,11006608,11006609,10926143,10926173,10952458,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921402,10921403,10921406,10965565,10965569,10965571,10965870,10966192,10610994,9189348,7019117,9213649,9213650,8864219,9213758,8864298,8864299,8864300,8864304,8864305,8864310,8864311,8864315,8864316,3655009,9173942,6666269,6666270,6666271,6666272,6666273,9187406,9187408,10119623,8861968,7025286,10563457,10612381,10609385,7025579,7025785,8862837,8862838,9189107,9189111,9189116,7018874,9165248,10125554,10125555,7023033,10125603,10117608,10125611,7055682,9170120,9170122,9162139,7024344,8861623,10119346,10119347,9176434,7022101,8918212,10416861,10125359,9166392,10122642,8865028,7020229,7020673,9917233,9917235,9917236,6667108,7020779,6473428,7020925,10123479,10123480,9207570,4972584,4972585,9175776,9208013,7021951,10174875,10174878,10174880,10174883,10174884,10174885,10174893,8594107,10884100,10884101,10877720,10163783,10883125,10905997,10905998,10906003,10906004,10172261,10172263,10187577,10187595,10187596,10172745,10182966,10182967,10182968,10182969,10182970,10182971,10182972,10187994,10183381,10652487,10583854,10583934,10583935,10583936,10599171,10599172,10599173,10599174,10599175,10599176,10599177,10599215,10599216,10599217,10578239,10578240,10578241,10578242,10578243,10599420,10601412,10601413,10521717,10538445,10538451,10538452,10538453,10538454,10538455,10538461,10521027,10420576,10423606,10498698,10423970,10423979,10495905,10495906,10411284,10411285,10488201,10477254,10477255,10477256,10477384,10496498,10496499,8562903,10487111,10495201,10495202,10495211,10714981,10476583) 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>