Untitled query #7308

SQL

USE urwiki_p;
SELECT CONCAT('# [https://ur.wikipedia.org/w/index.php?title=Special%3Alink&hidelinks=1&target=Template:',tl_title,'&namespace=0 ',tl_title,']') AS tl_title, COUNT(*) AS count_tl_title
FROM page, templatelinks
WHERE tl_from_namespace = 0
AND tl_namespace = 10
AND page_id = tl_from
AND tl_title NOT LIKE 'Toc'
AND tl_title NOT LIKE 'Tc'
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE p1.page_namespace = tl_namespace
AND p1.page_title = tl_title)
GROUP BY tl_title
ORDER BY count_tl_title DESC, tl_title ASC;
SQL

Checking query status...
