{"body":"Edition Group\n\nSELECT DISTINCT (idtype.label), count(*)\nFROM edition_group \nLEFT JOIN identifier_set__identifier idens ON idens.set_id =  edition_group.identifier_set_id\nLEFT JOIN identifier iden on idens.identifier_id = iden.id\nLEFT JOIN identifier_type idtype on iden.type_id = idtype.id\nWHERE master = 't' \nAND edition_group.identifier_set_id IS NOT NULL  \nAND idtype.id in (1, 2, 3, 17, 32)\nGROUP BY idtype.label;\n\n\nLiterary Work\n\nSELECT DISTINCT (idtype.label), count(*)\nFROM work \nLEFT JOIN identifier_set__identifier idens ON idens.set_id =  work.identifier_set_id\nLEFT JOIN identifier iden on idens.identifier_id = iden.id\nLEFT JOIN identifier_type idtype on iden.type_id = idtype.id\nWHERE master = 't'\nAND work.identifier_set_id IS NOT NULL \nAND idtype.id in (1, 2, 3, 17, 32)\nGROUP BY idtype.label;\n\n\nPublisher\n\nSELECT DISTINCT (idtype.label), count(*)\nFROM publisher \nLEFT JOIN identifier_set__identifier idens ON idens.set_id =  publisher.identifier_set_id\nLEFT JOIN identifier iden on idens.identifier_id = iden.id\nLEFT JOIN identifier_type idtype on iden.type_id = idtype.id\nWHERE master = 't' \nAND publisher.identifier_set_id IS NOT NULL  \nAND idtype.id in (1, 2, 3, 17, 32)\nGROUP BY idtype.label;\n\n","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/vDX3X8ni","modified":1660732241,"id":"vDX3X8ni","size":1214,"lines":38,"own_paste":false,"theme":"","date":1660732241}