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(11014721,11014722,11014723,11014724,11041094,11015340,11015341,10848971,10848972,7073983,10950617,10849279,11028695,7074022,8621937,11028794,11028795,11028796,11028797,10869263,11013730,11013731,11014436,10873198,10867036,8836393,11012745,11012746,11012759,11012760,11012761,10867442,10867443,10867444,10867445,10867446,10867447,10867448,11026193,11026194,11026195,11026196,11026197,11026296,11026297,3237415,3237416,10943195,10959614,10959615,10101325,10957998,11023400,11032656,11032657,11032658,11032659,11032676,10967980,10854084,10854085,10854086,10919412,10920401,11019249,11019250,11019251,11019252,11032310,11006365,10837493,11042656,8576838,11004437,11030531,10916583,10916584,10916585,10916586,10916587,10916669,10916670,10916671,10926729,11017988,11017989,11017990,11018071,11018072,11018073,11018074,11018075,11018076,8577641,8577645,9189320,7027061,6677702,9213736,9915996,9916004,6678422,6678423,9916483,6675583,7025194,7026224,7026424,7026646,8852908,8852909,8852910,8852911,8852912,8852913,8852914,8852915,7018846,7026940,7023009,4974252,9201409,8849239,8849257,10125910,4974567,7023771,4975114,7023947,7024034,10514472,10514473,10514474,10514475,10514476,10514477,10514478,10514479,10514480,10514481,10514482,10514483,10514484,9203095,7022091,10117027,10419922,9209107,9209108,7020205,9166552,6670838,6678897,7020628,8854967,8854969,7021914,6680492,10179587,10169795,10170445,10170446,10170568,10170569,10170570,10170571,10170572,10156038,10166369,10166370,10168884,10168885,10178945,10178946,10178947,10178948,10178949,10178950,10179027,10169332,10166505,10166506,10171789,10167900,10167901,10167902,10167903,10167904,10631458,10168070,10631559,10877370,10586122,10586123,10602047,10602058,10586279,10572130,10572153,10645613,10420230,10420231,10420232,10420233,10420234,10420235,10420236,10421473,10423912,10409883,10409884,10409885,10495194) 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>