select o.url, convert_from(def.name, 'utf-8')
from origin o
inner join occurrence occ on occ.origin=o.id
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 def.name='pom.xml';