stopped - full rev + uc

SQL

use enwiki_p;

with actor_user_name as (
	select 	
  		user.user_id, 
 		user.user_name,
        actor.actor_id,
		recentchanges.rc_cur_id,
  		recentchanges.rc_id,
  		recentchanges.rc_type,
    	recentchanges.rc_timestamp,
    	recentchanges.rc_namespace,
 		recentchanges.rc_bot,
  		rc_title
   	from recentchanges
	join actor on recentchanges.rc_actor = actor.actor_id
	left outer join user on actor.actor_user = user.user_id
	where rc_timestamp > date_sub(now(), interval 90 DAY)
	and rc_type in (0,1,6)
  	and rc_bot = 0
)

select 
	actor_user_name.user_id, 
	actor_user_name.user_name,
    actor_user_name.actor_id,
    actor_user_name.rc_cur_id,
    actor_user_name.rc_id,
    actor_user_name.rc_bot,
    actor_user_name.rc_timestamp,
    actor_user_name.rc_namespace,
    actor_user_name.rc_type,
    rc_title,
    page.page_id as user_page_id,
	categorylinks.cl_to as user_category
from actor_user_name
left outer join page 
	on page.page_title = replace(actor_user_name.user_name, ' ', '_')
    and page.page_namespace = 2
left outer join categorylinks on categorylinks.cl_from = page.page_id
SQL

Checking query status...
