Replicas browser and optimizer
This query is marked as a draft
This query has been published
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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in