Untitled query #16483

SQL

use ptwiki_p;

set @total_edit_rank = 0;
set @unique_users_rank = 0;

SELECT
  t.*
  , @unique_users_rank := @unique_users_rank + 1 AS unique_users_rank
FROM
  (
    SELECT
      t.*
      , @total_edit_rank := @total_edit_rank + 1 AS total_edit_rank
    FROM
      (
        SELECT
          page.page_title
          , COUNT(*) AS total_edits
          , COUNT(DISTINCT rev_user_text) AS unique_users
        FROM
          revision
          INNER JOIN page
            ON (revision.rev_page = page.page_id)
        WHERE
          rev_timestamp LIKE '2016%'
          and page.page_namespace = 0
        GROUP BY
          rev_page
      ) t
    ORDER BY
      t.total_edits DESC
  ) t
WHERE
  (total_edit_rank <= 100) or (unique_users_rank <= 100)
ORDER BY
  t.unique_users DESC;
SQL

Checking query status...
