topics all pt 1

SQL

USE enwiki_p;

with pages_user_edited as (
  select rc_title, user.user_id, rc_type, cast(rc_timestamp as datetime) as rev_date from recentchanges
	join actor on recentchanges.rc_actor = actor.actor_id
	join user on actor.actor_user = user.user_id
	where rc_timestamp > "2022-06-08T14:43:06"
	# and rc_timestamp < "2022-06-09T14:43:06"
	and rc_type in (0,1,6)
  limit 10
)
select 
	user_id,
	rc_title as edited_page_title, 
    page.page_id,
	categorylinks.cl_to as category_title,
    rc_type as revision_type,
	rev_date
from pages_user_edited
left join page on page.page_title = rc_title
left join categorylinks on categorylinks.cl_from = page.page_id
SQL

Checking query status...
