Untitled query #64024

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
  	limit 100
	-- 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 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
SQL

Checking query status...
