recent changes page categories 1 wk

SQL

USE enwiki_p;

with users_edits as (
  select rc_title, user.user_id, rc_type, rc_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 7 DAY)
)
select
  	rc_title, 
	user_id,
  	rc_type,
  	rc_id,
    page.page_id,
	categorylinks.cl_to
 from users_edits
 left join page on page.page_title = replace(users_edits.rc_title, ' ', '_')
 left join categorylinks on categorylinks.cl_from = page.page_id

SQL

Checking query status...