List of ukwiki users by unique articles they edited

Fork of List of ukwiki users by number of unique articles edited by Base

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

SQL

set group_concat_max_len = 1024*1024;
use ukwiki_p;
select a.actor_name, count(distinct r.rev_page) as articles_count, group_concat(distinct r.rev_page) as articles_edited
from revision_userindex r
join page p on r.rev_page = p.page_id and p.page_is_redirect = 0 and p.page_namespace = 0
left join page_props pp on p.page_id = pp.pp_page and pp.pp_propname = 'disambiguation'
join actor a on r.rev_actor = a.actor_id
where pp.pp_propname is null
group by r.rev_actor
having articles_count > 20
order by articles_edited desc
;

SQL

Checking query status...