Removing invalid rows from Magento eav_attribute_option and catalog_product_entity_int

magento-remove-invalid-fk-option-entity-int-rows.sql

# Delete option rows pointing to non-existent attributes
DELETE `option`
FROM `eav_attribute_option` AS `option`
LEFT JOIN `eav_attribute`
	ON `eav_attribute`.`attribute_id` = `option`.`attribute_id`
WHERE `eav_attribute`.`attribute_id` IS NULL;

# Delete product attribute int rows pointing to non-existent attributes
DELETE `entity_int`
FROM `catalog_product_entity_int` AS `entity_int`
LEFT JOIN `eav_attribute` AS `attribute`
	ON (`attribute`.`attribute_id` = `entity_int`.`attribute_id`)
WHERE `attribute`.`attribute_id` IS NULL;