SELECT 
    bar_code,
    COUNT(bar_code) AS duplicate_count
FROM 
    `eb_store_product`
WHERE 
    bar_code IS NOT NULL AND bar_code != ''
GROUP BY 
    bar_code
HAVING 
    COUNT(bar_code) > 1
ORDER BY 
    duplicate_count DESC;