Fiwikin useimmin arvioidut käyttäjät

SQL

use fiwiki_p;

-- Generic timestamp limit
-- This is for filtering the stuff what we want
SET @timestamp = 20200004153051;

-- Do not inspect older revisions than @revlimit
-- This is for speeding up the query
-- 18630374 = 1.1.2020
-- DO NOT CHANGE
SET @revlimit = 18630374;

select 
	actor_name, 
    count(distinct(rev_id)) as number_of_edits, 
    max(rev_timestamp) as last_edit 
from (
  select 
  	fr1.fr_rev_id as cur_rev_id, 
  	max(fr2.fr_rev_id) as old_rev_id, 
  	fr1.fr_page_id 
  from 
  	flaggedrevs as fr1, 
  	flaggedrevs as fr2 
  where 
  	fr1.fr_rev_timestamp > @timestamp 
  	and fr1.fr_rev_id > @revlimit 
  	and fr1.fr_tags not like "%auto%" 
  	and fr1.fr_page_id=fr2.fr_page_id 
  	and fr2.fr_rev_id < fr1.fr_rev_id 
  	and fr2.fr_rev_id > @revlimit 
  	group by fr1.fr_page_id 
) as t, 
revision_userindex, 
page, 
actor_revision LEFT JOIN (
      	select ug_user 
      	FROM user_groups 
      	WHERE 
      		ug_group IN ('autoreview', 'editor', 'sysop', 'reviewer', 'bot') 
      		GROUP BY ug_user
    	) as ug ON actor_user=ug_user 
where 
	rev_page=page_id 
	and page_namespace=0 
	and rev_id>old_rev_id 
	and rev_id<=cur_rev_id 
	and fr_page_id=rev_page 
	and actor_id=rev_actor 
	and ug_user IS NULL 
group by rev_actor 
order by number_of_edits desc;
SQL

Checking query status...
