Find the name and attribute ID of the attribute definitions with attribute value 0.
create table catalog_contents_additional_attributes (attribute_id varchar, attribute_value varchar, PRIMARY KEY (attribute_id)); create table attribute_definitions (attribute_name varchar, attribute_id varchar, PRIMARY KEY (attribute_name))
select t1.attribute_name, t1.attribute_id from attribute_definitions as t1 join catalog_contents_additional_attributes as t2 on t1.attribute_id = t2.attribute_id where t2.attribute_value = 0