CS-Cart MySQL find duplicate product codes

gistfile1.txt

SELECT `product_code`, COUNT(*) c FROM [prefix]_products GROUP BY `product_code` HAVING c > 1

#Show product names

SELECT a.product_code,a.status,b.product
FROM xxx_products AS a
LEFT JOIN xxx_product_descriptions AS b
ON a.product_id= b.product_id
WHERE a.product_code
IN (SELECT product_code FROM xxx_products GROUP BY product_code HAVING COUNT(product_code) > 1)
AND a.status='A'
AND b.lang_code='el'
ORDER BY a.product_code