nlwiki Transcluded a user page

SQL

USE nlwiki_p;

SELECT tl_title, EXISTS (SELECT * FROM page WHERE page_namespace=tl_namespace AND page_title=tl_title) AS `exists`, COUNT(*) AS `count`
FROM templatelinks
WHERE tl_namespace=2 AND tl_title NOT REGEXP '/' AND NOT EXISTS (SELECT * FROM page_restrictions WHERE pr_page=tl_from AND pr_cascade=1)
GROUP BY tl_namespace, tl_title
ORDER BY `count` DESC;

SELECT page_namespace, page_title
FROM templatelinks, page
WHERE
	tl_namespace=2 AND
    tl_title NOT REGEXP '/' AND
    tl_from=page_id AND
    NOT EXISTS (SELECT * FROM page_restrictions WHERE pr_page=tl_from AND pr_cascade=1)
ORDER BY page_namespace, page_title
SQL

Checking query status...
