Untitled query #64852

SQL

set @total_edit_rank = 0;
set @prev_edit_count = 0;

SELECT
  t.rank
  , REPLACE(t.page_title, '_', ' ') page_title
  , t.total_edits
FROM
  (
    SELECT
      t.*
      , @total_edit_rank := @total_edit_rank + IF(@prev_edit_count=t.total_edits, 0, 1) AS rank
      , @prev_edit_count := t.total_edits
    FROM
      (
        SELECT
          page_title
          , COUNT(*) AS total_edits
        FROM
          revision
          INNER JOIN page
            ON (revision.rev_page = page.page_id)
        WHERE
          revision.rev_timestamp LIKE '2016%'
          and page.page_namespace = 0
        GROUP BY
          page.page_title
      ) t
    ORDER BY
      t.total_edits DESC
      , t.page_title ASC
  ) t
WHERE
  (t.rank <= 100)
;
SQL

Checking query status...
