SELECT tl_namespace, tl_title, COUNT(*) AS `count`, GROUP_CONCAT(DISTINCT tl_from_namespace) AS ns

FROM templatelinks

WHERE

    tl_namespace NOT IN (8, 100) AND

    tl_from_namespace NOT IN (2, 3) AND

    NOT (tl_namespace=828 AND tl_title REGEXP '/doc$') AND

    NOT (tl_from_namespace=4 AND tl_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 WHERE page_namespace=tl_namespace AND page_title=tl_title)

GROUP BY tl_title

ORDER BY `count` DESC