Untitled query #16483

SQL

use ptwiki_p;

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

SELECT
  t.*
FROM
  (
    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
              REPLACE(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
    ORDER BY
      t.unique_users DESC
  ) t
WHERE
  (t.total_edit_rank <= 100) or (t.unique_users_rank <= 100)
;
SQL

Checking query status...
