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(tl_from) AS `tl`, COUNT(pl_from) AS `pl`, rd_namespace AS `rdns`, rd_title
FROM page 
	LEFT JOIN redirect ON (page_id=rd_from) 
    LEFT JOIN templatelinks ON (tl_namespace=10 AND tl_title=page_title)
    LEFT JOIN pagelinks ON (pl_namespace=10 AND pl_title=page_title)
WHERE page_namespace=10 AND page_is_redirect=1 AND rd_namespace!=10
GROUP BY page_title;

SELECT page_title, COUNT(tl_from) AS `tl`, COUNT(pl_from) AS `pl`, rd_namespace AS `rdns`, rd_title, rd_interwiki, rd_fragment
FROM page
	LEFT JOIN redirect ON (page_id=rd_from) 
    LEFT JOIN templatelinks ON (tl_namespace=10 AND tl_title=page_title)    
    LEFT JOIN pagelinks ON (pl_namespace=10 AND pl_title=page_title)
WHERE page_namespace=10 AND page_is_redirect=1 AND (rd_interwiki!='' OR rd_fragment!='')
GROUP BY page_title;

SELECT page_title, COUNT(tl_from) AS `tl`, COUNT(pl_from) AS `pl`, rd_namespace AS `rdns`, rd_title
FROM page
	LEFT JOIN redirect ON (page_id=rd_from) 
    LEFT JOIN templatelinks ON (tl_namespace=10 AND tl_title=page_title)    
    LEFT JOIN pagelinks ON (pl_namespace=10 AND pl_title=page_title)
WHERE page_namespace=10 AND page_is_redirect=1
GROUP BY page_title
LIMIT 25
SQL

Checking query status...
