Untitled query #65116

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 = 38427
	and rc_timestamp > date_sub(now(), interval 1 DAY)
	and rc_type in (0,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 page_id separator ', '), group_concat(distinct cl_to separator '; ') as categories
from cats_for_pages
group by 1
SQL

Checking query status...
