use frwiki_p;

select page_title, page_namespace

from page p inner join externallinks el on p.page_id = el.el_from

where el.el_to like 'http://www.unifrance.org/film/%'

and page_namespace = 0