Voci di cinema con più link a voci inesistenti

SQL

USE itwiki_p;
select page_title, count(pl_title), group_concat(concat('[[', replace(pl_title, '_', ' '), ']]') separator ', ') as pages
from page
join templatelinks on tl_from = page_id
and tl_namespace = 10
and tl_title = 'Bio'
join pagelinks on pl_from = page_id
AND NOT EXISTS (
    SELECT *
    FROM page
    WHERE page_namespace = 0
    AND page_title = pl_title
)
where page_namespace = 0
and pl_namespace = 0
and (select count(*) from pagelinks where pl_from = page_id and pl_namespace = 100 and pl_title = 'Cinema') > 0
group by page_title
order by count(pl_title) desc
limit 100

SQL

Checking query status...