# Pastebin Z3Qhhe8Z SELECT DISTINCT (idtype.label), count(*) FROM author LEFT JOIN identifier_set__identifier idens ON idens.set_id = author.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 author.identifier_set_id IS NOT NULL AND idtype.id in (1, 2, 3, 17, 32) GROUP BY idtype.label;