近期编辑电子游戏条目次数最多者 (zhwiki)

SQL

WITH pages_edited AS (
  SELECT
    rev_page,
    rev_actor
  FROM
    revision
  WHERE
    rev_timestamp >= 20220701000000
    AND rev_timestamp < 20221001000000
),

pages_vg_talk AS (
  SELECT
    page.page_namespace, page.page_title
  FROM
    page
    JOIN categorylinks ON cl_to = '电子游戏条目'
    AND cl_type = 'page'
    AND cl_from = page.page_id
),

pages_vg AS(
  SELECT
    page_main.page_id
  FROM
    page as page_main
    JOIN pages_vg_talk ON page_main.page_title = pages_vg_talk.page_title
      AND page_main.page_namespace + 1 = pages_vg_talk.page_namespace
)

SELECT
  pages_edited.rev_actor,
  COUNT(*)
FROM
  pages_edited,
  pages_vg
WHERE
  pages_edited.rev_page = pages_vg.page_id
GROUP BY
  pages_edited.rev_actor

SQL

Checking query status...