Fork of Untitled query #47313 by Antigng
This query is marked as a draft This query has been published by Xiplus.

SQL

AخA
 
SELECT page_namespace, page_title, COUNT(*) AS cnt
      FROM page
      JOIN templatelinks ON page_title = tl_title
        AND page_namespace = tl_namespace
      LEFT JOIN page_restrictions ON pr_page = page_id
        AND pr_type = 'edit'
      WHERE tl_namespace IN (10, 828)
        AND pr_level = 'sysop'
        AND page_is_redirect = 0
      GROUP BY page_namespace, page_title
      HAVING COUNT(*) < 100000
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...