select o.url, convert_from(def.name, 'utf-8') from origin o inner join occurrence occ on (occ.origin=o.id and occ.branch='refs/heads/master') inner join revision rev on (occ.target_type='revision' and occ.target=rev.id) inner join directory dir on rev.directory=dir.id inner join directory_entry_file def on def.id = any(dir.file_entries) where o.type='git' and def.name='pom.xml';