Show me each catalog entry id and their catalog level numbers.
select catalog_entry_id, catalog_level_number from catalog_contents_additional_attributes
Which ones have more than one catalog level number?
select catalog_entry_id, catalog_level_number from catalog_contents_additional_attributes group by catalog_entry_id having count (distinct catalog_level_number) > 1
Which ones have a catalog level number of 8?
select catalog_entry_id, catalog_level_number from catalog_contents_additional_attributes where catalog_level_number = "8"
Show me the entry names of each!
select t1.catalog_entry_name from catalog_contents as t1 join catalog_contents_additional_attributes as t2 on t1.catalog_entry_id = t2.catalog_entry_id where t2.catalog_level_number = "8"