Users frequently contributing to GA discussions on fawiki

Fork of Users frequently contributing to GA discussions on fawiki by Huji

This query is marked as a draft This query has been published by Huji.

SQL

use fawiki_p;
select rev_user_text, page_title, totalfreq, count(*) freq
from revision_userindex
join page
  on page_id = rev_page
  and page_title like 'گزیدن_مقاله‌های_خوب/%'
join
(
  select rev_user_text top_user, count(*) totalfreq
  from revision_userindex
  join page
    on rev_page = page_id
    and page_title like 'گزیدن_مقاله‌های_خوب/%'
  where rev_timestamp > '20180101000000'
  group by rev_user_text
  order by totalfreq desc
  limit 20
) toptwenty
  on rev_user_text = top_user
group by rev_user_text, page_title, totalfreq
order by totalfreq desc, freq desc

SQL

Checking query status...