Untitled query #65559

SQL

USE enwiki_p;

with recent_user_edits as (
 select 
	user.user_id, 
 	user.user_name,
	user.user_registration as acct_created, 
  	actor.actor_id,
  	count(rc_id) as recent_rev_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 90 DAY)
 group by 1,2,3,4
  limit 10
)
select 
	recent_user_edits.user_id, 
	recent_user_edits.user_name, 
    recent_user_edits.recent_rev_count,
	cast(recent_user_edits.acct_created as datetime) as acct_created_ts,
    page.page_id as user_page_id,
	cast(revision.rev_timestamp as datetime) as user_page_created_ts,
	categorylinks.cl_to as user_category,
    categorylinks.cl_timestamp
from recent_user_edits
left outer join page 
	on page.page_title = replace(recent_user_edits.user_name, ' ', '_')
    and page.page_namespace = 2
left outer join revision
	on page.page_id = revision.rev_page
    and revision.rev_parent_id = 0
left outer join categorylinks on categorylinks.cl_from = page.page_id
SQL

Checking query status...
