Most edited user talk pages 2020

SQL

use fiwiki_p;

select 
	concat("Keskustelu käyttäjästä:", page_title) as page_title, 
    count(distinct(rev_id)) as revs, 
    count(distinct(actor_name)) as editors, 
    count(distinct(floor(rev_timestamp/1000000))) as days, 
    count(distinct(IF (comment_text LIKE "%usi osio%",rev_id,NULL))) as uusi_osio 
from 
	page, 
    revision_userindex 
    	LEFT JOIN change_tag ON ct_rev_id=rev_id 
        LEFT JOIN  change_tag_def ON ct_tag_id=ctd_id, 
    actor_revision 
    	LEFT JOIN ipblocks AS ipb2 ON actor_user=ipb_user, 
    user 
    	LEFT JOIN ipblocks AS ipb1 ON user_id=ipb_user, 
    comment_revision 
where 
	rev_comment_id=comment_id 
    and page_title=user_name 
    and page_namespace=3 
    and page_id=rev_page 
    and actor_id=rev_actor 
    and rev_id> 18630374 
    and rev_timestamp> 20200000000000 
    and user_id!=actor_user 
    and actor_name not regexp "4shadowwBOT|MediaWiki message delivery|UKBot" 
    and (ctd_name IS NULL OR ctd_name NOT IN ("mw-reverted", "mw-undo", "mw-rollback", "mw-manual-revert")) 
    and ipb1.ipb_user IS NULL 
    and ipb2.ipb_user IS NULL 
group by page_title 
order by revs desc 
limit 25;
SQL

Checking query status...
