编辑人数最多的电子游戏条目 (zhwiki)

SQL

WITH pages_with_editing AS (SELECT rev_page
                            FROM revision
                            WHERE rev_timestamp >= 20221001000000
                              AND rev_timestamp < 20230101000000),
     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
                       WHERE page.page_namespace = 1),
     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 CONCAT(
               '* [[',
               pages_with_editing.rev_page,
               '}}',
               ' <small>[',
               COUNT(*),
               ']</small>'
           ) AS result
FROM pages_with_editing
         JOIN pages_vg ON pages_with_editing.rev_page = pages_vg.page_id
GROUP BY pages_with_editing.rev_page
ORDER BY pages_with_editing.rev_page DESC,
         COUNT(*) ASC;
SQL

Checking query status...
