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(8838521,8838522,10930359,10930448,11040881,11040882,11040883,11040884,11040885,11040886,11040887,11040888,11040889,11040890,11040891,11040892,11040893,11040894,11040895,11040896,11040897,11040898,11040899,11040900,11041112,11041113,11041114,11041115,11041116,11041117,11041118,8621285,8621286,8621287,8621288,8621289,8621290,8621291,8621292,8621293,8621294,8621295,8621296,10870795,10873835,10873867,10874050,10874058,7068793,7068794,11041552,10933302,10933303,11041643,11041644,10933328,10933329,7073986,10846933,10846934,10846935,10846936,10846937,10846938,10846939,10846940,10846941,7074329,10977432,7075096,7075097,11039985,11039991,8630094,8630095,10447655,10873159,11037621,11037654,11037655,11038163,11038212,8075264,8911723,11038355,11038402,11038403,11038404,10867283,11038698,11038699,11038700,11038701,10104290,10104291,10104292,8560167,8560168,10104354,10867761,10099834,3227110,10099941,10100056,11049371,11049372,11049385,10943117,10943249,3238238,10995828,10840256,10944978,10944979,10944980,10944981,3236265,3236266,3236267,3236268,3236269,3236270,10840714,10996688,3656626,10841548,10841549,10841550,10841551,10841552,8613450,7157437,3924374,8613837,8613838,8613839,10927493,10927494,8579004,8579011,10847891,3230632,10925751,10925752,10925753,10925754,10925755,10921020,10921021,10921022,3582234,3231451,10926723,8611308,8541154,10979475,10979476,10979477,10979478,10979479,10979480,10979481,10979482,10979483,7059720,6670449,9179329,9179330,9179331,9211344,9211355,9211356,7025076,8542711,9212129,6676488,9220553,9220554,9220555,7026344,7026511,7018540,7026544,7026841,7023686,9178069,9178070,9178071,9178072,9178073,9178074,7023812,4975017,4975018,4975019,4975020,4975021,9912437,3286065,3286066,7056591,7056592,7056593,8917995,7022039,10427858,10427859,7022199,10125287,7022759,9209106,9209141,10420110,10428673,10428674,7019970,8569182,8569183,8569184,8569185,8569186,7020486,9207072,9207073,9207074,9207075,9207076,9207077,9207078,9207079,9207080,9207081,9207196,9207197,9207198,9207199,6671499,8563443,8563546,7021459,9208103,10169543,10169544,10169606,10169774,10169856,10892481,10892482,10912862,10168907,7001350,10895677,10895678,10187401,10187402,10187403,10187404,10187474,10187475,10187476,10187477,10631178,10949840,10631832,10631833,10631834,10631835,10631836,10583747,10583748,10583749,10583750,10583751,10605953,10653919,10653920,10653921,10653922,10653923,10653924,10584891,10653977,10654036,10654037,10654038,10654039,10582324,10582325,10582326,10582327,10582328,10582329,10582330,10582331,10582332,10582333,10582334,10582335,10582336,10582337,10582338,10582339,10582340,10582341,10582342,10582343,10582344,10582345,10582346,10582455,10582456,10582457,10523828,10520765,10422396,10422435,10424462,10420489,10424495,10424643,10424647,10423887,10481242,10481243,10481244,10481245,10492379,10492380,10492381,10480148,10480149,10480150,10495160,10487308,10487309) 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>