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(7068716,8574988,8574989,8583658,10977215,10868860,10868865,10868883,10951328,10951341,8609594,10447702,10972644,10971700,10971734,10971735,10971797,10984849,10971858,10971859,10984889,10842100,10985042,10985043,10972188,10972189,10100077,8908135,8908136,10940753,10982853,10982854,10982855,10982856,10982857,10982858,10982859,10982860,10982861,10982862,10982863,10982864,10982865,10982866,7069259,7069311,10983518,10983587,10983658,10983665,10983696,10983697,10983698,10983699,10983761,10983762,10984143,10984144,10984145,10984146,10984147,10984148,10984149,10984150,10984151,10984152,10984153,10984154,10984155,10984156,10984157,10984158,10984159,10984160,10984161,10984162,10984163,10984164,10984165,10984331,10984590,10984591,10984597,8554543,8554546,8554547,8554548,8554550,3924199,8614002,8614067,3924658,10982068,10982069,10982070,10982071,3924789,3924790,8614246,3924821,10982138,10982139,10982140,10982141,10982142,10982143,10982144,10982145,10982146,10982147,10982148,10982149,10982150,10982151,10982152,10982153,10982154,8907797,8541500,8541501,10425576,3582077,3582086,3582088,3582091,3582096,3582097,8904343,9181326,8853176,8853194,8853195,9181377,9181379,9181380,9181419,9181422,9181564,9181588,9181589,9181590,9181591,9181592,9181593,9181594,9181595,8853474,9181665,9181666,9181705,9181706,9181707,10714238,9182197,6675659,6675660,10119840,6675990,6675991,6676229,9914438,8566815,8852306,9914756,9914757,9914758,9914781,8567099,8567100,8567101,8567102,8567103,8567401,9181032,9181033,8863712,8863714,9181209,9181210,9181290,9181298,9177892,9177893,9177894,7057031,8848771,8848772,8848773,8848774,6673289,9169197,9182369,9182400,8550314,4972430,4972452,10468206,8847500,8847502,10462315,10462317,10462318,10462319,10462320,10462321,10462322,10462323,10462324,976129,8848042,8848043,8848044,10899411,10899412,10899413,10899449,10899526,10899527,10899528,10170603,10894710,10894777,10899792,10899801,10166746,10167172,10949124,10949125,10167353,10162649,10162650,10162651,10162652,10162653,10162704,10162749,10162750,10162751,10897172,10649508,10649951,10649952,10649993,10603689,10603690,10647958,10647959,10525197,10525250,10525251,10525252,10523654,10523655,10524329,10524330,10524331,10524332,10524333,10524334,10524335,10524336,10524337,10524338,10524387,10524388,10524389,10524390,10524391,10524412,10524529,10524530,10524531,10524532,10524608,10524761,10524762,10524763,10524764,10524778,10421211,10480943,10480985,8562376,10481165,10479167,10479168,10481395,10481396,10481397,10481482,10481600,10481601,10481602,10481608,10496753,10481796,10478044,10478045,10497051) 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>