Untitled query #65526

SQL

use enwiki_p;

with actor_user_name as (
	select 	
  		user.user_id, 
 		user.user_name,
  		user.user_registration as acct_created,
 		rc_id
   	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 between 20220616112717 and 20220618112717
	and rc_type in (0,1,6)
  	and rc_bot = 0
)

select 
	user_id, 
	user_name,
    rc_id,
    acct_created,
    page.page_id as user_page_id
from actor_user_name
left outer join page 
	on page.page_title = replace(actor_user_name.user_name, ' ', '_')
    and page.page_namespace = 2
SQL

Checking query status...
