select page_namespace, page_title, lt_title from linktarget

join templatelinks on tl_target_id = lt_id

join page on tl_from = page_id and page_namespace % 2 = 0 and page_namespace != 2

where lt_namespace = 10

and lt_title not in (select page_title from page where page_namespace = 10)

order by page_namespace;

​

/*

select page_title, pl_title from pagelinks

join page on pl_from = page_id and page_namespace = 0

where pl_namespace = 10

and pl_title not in (select page_title from page where page_namespace = 10)

limit 100;

*/