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(10939914,10950293,7073924,8621872,7066159,7066160,9215892,10849561,8622491,10847513,10872441,11001184,11001185,10929935,9214346,9214347,9214348,9214349,9214350,9214351,10866203,6000248,11012007,7201635,10866683,10866684,10866685,10866750,10866751,10866752,10866753,10866754,8559422,7201789,10843428,7201925,10103908,8595493,8628571,8628590,8628615,8619129,8619130,8619131,8560310,7073429,8837033,7073722,11011355,10865958,8558736,10996199,10996200,10996207,10996209,10996210,10996223,10996240,10996263,11009281,11009282,11009284,10840356,3926883,3926884,8612947,10967806,10618282,10618283,10618296,10618303,10618320,10618324,10618326,8541453,8541675,11044988,11044989,11044990,10928195,10928196,10928197,10928248,10928249,10928250,10928251,8542310,11043194,11043195,10848365,10848366,10848367,10848368,10930687,9217603,9217659,9217660,9217661,9217662,9217663,9217664,8540987,8634199,8634200,8634201,8634202,8634203,8634204,8634205,8634206,8634207,8634208,8634209,8634210,8634211,8634212,8634213,8634214,8634215,8634216,8634217,8634218,8634219,8634220,8634221,8567846,8567851,9189558,7059748,7059749,10611359,9197765,3654973,9197766,9197767,9173787,9173788,10614862,10612263,10609271,9211681,9195874,9195916,9195917,9195959,9195963,9188969,9188976,9188977,9189015,9193519,9185533,9193549,9161756,7055962,7055993,10517657,9193848,9170340,9170391,10419312,10419558,10419559,10419560,10419561,10419607,10419608,10419609,10419121,8864917,10122621,10122622,9174509,9174645,9174720,9174892,9199062,8917100,9207684,9175946,8917763,8917764,8917765,8917766,10629408,10905348,10176651,10905639,10176652,10176653,10176654,10176655,10176656,10905666,10905696,10905697,10177102,10177103,10177104,10177105,10177106,10177107,10912023,10912024,10912025,10912026,10912027,10912028,10912029,10912030,10912031,10912032,10912033,10912034,10912149,10652678,10587143,10587144,10607419,10607420,10522499,10522500,10510160,10510161,10510162,10510163,10510164,10510422,10510423,10510424,10510425,10510426,10423559,10423560,10508530,10510552,10510553,10510554,10510555,10510606,10509821,10509822,10509872,10509889,10509890,10509891,10509892,10509893,10509894,10509895,10509900,10509912,10509913,10509914,8562318,10477393,10715336,10407146) 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>