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
Find the name and attribute ID of the attribute definitions with attribute value 0.
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
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 = value
Find the name and attribute ID of the attribute definitions with attribute value 0 .