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(8574580,8569814,10940468,10940494,8569875,10868609,10868611,10868612,10951276,10951281,10497745,10497746,10497747,10497748,10497749,8591192,10497750,10497751,8591193,10497752,10497753,10497844,10497845,10497846,10497898,8591362,8591363,8591364,10497982,10497983,10497984,8591427,8068109,8068110,8068111,8068112,8068113,8591486,10498077,10498078,10498079,8591552,8068212,8068213,8068214,8068215,8068216,10498183,10498184,8068284,8591665,8591666,8591667,8591668,8591669,8591670,8591671,8068361,8068362,8068429,8068480,8068488,8068489,8068559,8068560,8068561,8068562,8068563,8068564,8068565,8066318,8066345,8066346,8066400,8066520,8066521,8066522,8066523,8066524,8066525,8066526,8066527,8066528,10497585,10497586,10497587,10497588,10497589,7068963,8555943,7069001,7069002,8555947,7069003,8555954,8564799,8564809,10984118,10841397,10841422,10841427,10425518,10978866,10978977,10978978,10978979,10978980,10978981,10621345,10621346,10621347,10621348,10979023,10979037,10979038,10979039,10621400,10621401,10621402,10621403,10621404,10621405,10979064,10979100,10979101,10979102,10979103,10979104,10979105,10979106,10979107,10979108,10979109,10979110,10979111,10979112,10979113,10426874,9182003,6676262,6676414,6676441,6676442,6676451,10120459,6676478,10120579,8567217,8567218,8567252,8567253,8567254,8863320,8863391,8863414,8863415,8863416,8863512,8863559,8863560,8863561,9178955,9178956,9178999,9179089,9179090,9179102,9179103,9179111,9179112,9179145,9179146,9179147,9179148,9179149,9179150,9179151,9910799,10468045,10468063,8593731,8593732,8593733,8593734,10898733,8593782,8593783,8593784,8593886,8593887,8593888,8593889,8593890,10899857,10897473,10897474,10897656,10897688,10897792,10897793,10897794,10897848,10897849,10897850,10897851,10897852,10167047,10949230,10949249,10949310,10949371,10949372,10949373,10949374,10949375,10949393,10949394,10949395,10649649,10524494,10524786,10479818,10479819,10479820,10479821,10481938,10479964,10714909) 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>