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`,*/ rd_namespace, rd_title
FROM page LEFT JOIN redirect ON (page_id=rd_from) LEFT JOIN templatelinks ON (tl_namespace=10 AND tl_title=page_title)
WHERE page_namespace=10 AND page_is_redirect=1 AND rd_namespace!=10
GROUP BY tl_title;
/*
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...
