Untitled query #25539

SQL

use fawiki_p;
select
  rev_user_text,
  max(case
      when ug_user is not null
      or ufg_user is not null
      or rev_user_text = 'Reza1615'
      or rev_user_text = 'جواد'
      then 1 else 0 end
     ) as current_or_past_sysop,
  count(rev_id) total_edits_in_mediawiki_namespace
from revision
join page
on rev_page = page_id
and page_namespace = 8
left join user_groups
  on rev_user = ug_user
  and ug_group = 'sysop'
left join user_former_groups
  on rev_user = ufg_user
  and ufg_group = 'sysop'
where rev_timestamp > '20120101000000'
group by rev_user_text
order by 3 desc;
SQL

Checking query status...
