# Pastebin vDX3X8ni
Edition Group

SELECT DISTINCT (idtype.label), count(*)
FROM edition_group 
LEFT JOIN identifier_set__identifier idens ON idens.set_id =  edition_group.identifier_set_id
LEFT JOIN identifier iden on idens.identifier_id = iden.id
LEFT JOIN identifier_type idtype on iden.type_id = idtype.id
WHERE master = 't' 
AND edition_group.identifier_set_id IS NOT NULL  
AND idtype.id in (1, 2, 3, 17, 32)
GROUP BY idtype.label;


Literary Work

SELECT DISTINCT (idtype.label), count(*)
FROM work 
LEFT JOIN identifier_set__identifier idens ON idens.set_id =  work.identifier_set_id
LEFT JOIN identifier iden on idens.identifier_id = iden.id
LEFT JOIN identifier_type idtype on iden.type_id = idtype.id
WHERE master = 't'
AND work.identifier_set_id IS NOT NULL 
AND idtype.id in (1, 2, 3, 17, 32)
GROUP BY idtype.label;


Publisher

SELECT DISTINCT (idtype.label), count(*)
FROM publisher 
LEFT JOIN identifier_set__identifier idens ON idens.set_id =  publisher.identifier_set_id
LEFT JOIN identifier iden on idens.identifier_id = iden.id
LEFT JOIN identifier_type idtype on iden.type_id = idtype.id
WHERE master = 't' 
AND publisher.identifier_set_id IS NOT NULL  
AND idtype.id in (1, 2, 3, 17, 32)
GROUP BY idtype.label;