Untitled query #14683

SQL

SELECT lt_namespace, lt_title, COUNT(*) AS `count`, GROUP_CONCAT(DISTINCT tl_from_namespace) AS ns
FROM templatelinks INNER JOIN linktarget ON tl_target_id=lt_id RIGHT JOIN page pf ON tl_from=page_id
WHERE
	lt_namespace NOT IN (8, 100) AND
    tl_from_namespace NOT IN (2, 3) AND
    NOT (lt_namespace=828 AND lt_title REGEXP '/doc$') AND
    NOT (tl_from_namespace=4 AND pf.page_title REGEXP '/[Aa]rchief') AND
    NOT EXISTS (SELECT * FROM page_restrictions WHERE tl_from=pr_page AND pr_cascade=1) AND
    NOT EXISTS (SELECT * FROM page pt WHERE pt.page_namespace=lt_namespace AND pt.page_title=lt_title)
GROUP BY lt_title
ORDER BY `count` DESC
SQL

Checking query status...
