Task: Text to Code
Input (English): Which attribute definitions have attribute value 0? Give me the attribute name and attribute ID.
Output (English): 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