use zhwiki_p;

SELECT page_title AS title, page_id AS id, COUNT(*) AS count

      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 = 10

        AND pr_level = 'sysop'

      GROUP BY page_title

      HAVING COUNT(*) < 100000;