Untitled query #9605

SQL

use enwiki_p;
SELECT p.page_title, (select cla2.cl_to
		from categorylinks cla2
		#join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
		where p.page_id=cla2.cl_from and
 cla2.cl_type="page" and cla2.cl_to rlike "(\\d+)_films"
                           limit 1                  )
FROM page p, page_props, wikidatawiki_p.page wdp
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P577' AND wdpl.pl_namespace = 120
JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'Q11424' AND wdpl2.pl_namespace = 0
WHERE p.page_namespace = 0
AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0
and exists (SELECT *
						FROM templatelinks
						WHERE tl_namespace = 10 and tl_from_namespace=0 and tl_from=p.page_id
						and tl_title="Infobox_film"
  					)
AND wdpl.pl_from IS NULL;
SQL

Checking query status...
