Untitled query #60258

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
	limit 30
)
select 
	recent_user_edits.user_id, 
	recent_user_edits.user_name, 
    recent_user_edits.edit_count, 
    page.page_title,
    group_concat(distinct categorylinks.cl_to separator '; ') as user_categories
from recent_user_edits
left outer join page ON page.page_title = replace(recent_user_edits.user_name, ' ', '_')
left outer JOIN categorylinks ON categorylinks.cl_from = page.page_id
  WHERE page.page_namespace = 2
group by 1,2,3, 4
SQL

Checking query status...
