cswiki-wantedtemplates.sql

select P.page_namespace, P.page_title, tl_namespace, tl_title 
from page as P 
join templatelinks on tl_from = P.page_id  
left join page as X on X.page_namespace = tl_namespace and X.page_title = tl_title 
where X.page_title is null