{"body":"SELECT DISTINCT (idtype.label), count(*)\nFROM author \nLEFT JOIN identifier_set__identifier idens ON idens.set_id =  author.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 author.identifier_set_id IS NOT NULL  \nAND idtype.id in (1, 2, 3, 17, 32)\nGROUP BY idtype.label;","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/Z3Qhhe8Z","modified":1660732150,"id":"Z3Qhhe8Z","size":381,"lines":9,"own_paste":false,"theme":"","date":1660732150}