Untitled query #62262

SQL

USE enwiki_p;

with pages_user_edited as (
  select rc_title, user.user_id from recentchanges
	join actor on recentchanges.rc_actor = actor.actor_id
	join user on actor.actor_user = user.user_id
	where user.user_id = 31530
	and rc_timestamp > date_sub(now(), interval 30 DAY)
  and rc_type in (1)
	group by 1,2
), cats_for_pages as (
select 
	rc_title, 
	user_id, 
    page.page_id,
	categorylinks.cl_to
from pages_user_edited
left join page on page.page_title = replace(pages_user_edited.rc_title, ' ', '_')
left join categorylinks on categorylinks.cl_from = page.page_id 
)
select user_id, group_concat(distinct cl_to separator '; ') as categories
from cats_for_pages
group by 1
SQL

Checking query status...
