Find Unused Product Attributes

Just to keep things tidy!

SELECT attribute_id, attribute_code, frontend_label
FROM eav_attribute
WHERE entity_type_id = 4
AND attribute_id NOT IN(SELECT attribute_id FROM eav_entity_attribute);
Mike Whitby Almost 11 years ago