For each catalog id, show the attribute ids and values!!
select attribute_id, attribute_value from catalog_contents_additional_attributes
Show me just those that a value of 1!
select attribute_id, attribute_value from catalog_contents_additional_attributes where attribute_value = 1
Actually, how about those with a value of 0?
select attribute_id, attribute_value from catalog_contents_additional_attributes where attribute_value = 0
What are the just the names and attribute IDs of each?
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