Untitled query #60259

SQL

USE enwiki_p;
with recent_user_edits as (
	select user.user_id, user.user_name, count(rc_id) as edit_count
	from recentchanges
		join actor on recentchanges.rc_actor = actor.actor_id
		join user on actor.actor_user = user.user_id
	where rc_timestamp > date_sub(now(), interval 30 DAY)
	group by 1,2
-- 	having count(rc_id) > 1
) 
select 
	recent_user_edits.user_id, 
	recent_user_edits.user_name, 
    recent_user_edits.edit_count,
	group_concat(distinct categorylinks.cl_to separator '; ') as user_categories
from recent_user_edits
left join page on page.page_title = replace(recent_user_edits.user_name, ' ', '_') and page.page_namespace = 2
left join categorylinks on categorylinks.cl_from = page.page_id
group by 1,2,3
SQL

Checking query status...
