Magento 2 db data checking

deleteDuplicatesOnAttributeOptionValues.sql

DELETE FROM eav_attribute_option_value
WHERE value_id IN (
    SELECT tmp.value_id from (
        SELECT value_id
        FROM eav_attribute_option_value
        GROUP BY option_id, store_id
        HAVING COUNT(*) > 1
    ) as tmp
);

getDuplicatesOnAttributeOptionValues.sql

SELECT eaov.value_id, eao.attribute_id, ea.attribute_code
FROM eav_attribute_option_value as eaov
LEFT JOIN eav_attribute_option as eao ON eaov.option_id = eao.option_id
LEFT JOIN eav_attribute as ea ON eao.attribute_id = ea.attribute_id
GROUP BY eaov.option_id, eaov.store_id
HAVING COUNT(*) > 1;