nlwiki Template redirects to check

SQL

SELECT COUNT(page_title) AS `without category`
FROM page
WHERE page_namespace=10 AND page_is_redirect=1 AND NOT EXISTS (SELECT * FROM categorylinks WHERE cl_from=page_id);

SELECT page_title, COUNT(SELECT * FROM templatelinks WHERE tl_namespace=10 AND tl_title=page_title) AS `tl`, rd_namespace, rd_title
FROM page LEFT JOIN redirect ON (page_id=rd_from)
WHERE page_namespace=10 AND page_is_redirect=1 AND rd_namespace!=10;

SELECT page_title, COUNT(tl_from) AS `tl`, rd_namespace, rd_title, rd_interwiki, rd_fragment
FROM page LEFT JOIN redirect ON (page_id=rd_from)
WHERE page_namespace=10 AND page_is_redirect=1 AND (rd_interwiki!='' OR rd_fragment!='')
SQL

Checking query status...
