DELETE FROM products_description AS t1 WHERE EXISTS (
SELECT 'products_id', 'site_language_id'
FROM products_description AS t2
WHERE t2.products_id = t1.products_id
AND t2.site_language_id = t1.site_language_id
);

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as t1
where  exists (select 'products_id','site_language_id' from products_desc' at line 1

DELETE FROM products_description
WHERE product_id IN (
                     SELECT product_id FROM( Select product_id,site_language_id
                                             From products_description
                                             Group By product_id,site_language_id
                                             Having Count(*)>1
                                           ) As X
                    )As Y