Untitled query #65172

This query is marked as a draft This query has been published by Nmine13.

SQL

USE enwiki_p;

with pages_user_edited as (
  select rc_title, user.user_id 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 1 DAY)
	and rc_type in (0,1)
  	limit 10
)
select 
	rc_title, 
	user_id, 
    page.page_id,
	categorylinks.cl_to
from pages_user_edited
left join page on page.page_title = rc_title
left join categorylinks on categorylinks.cl_from = page.page_id

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...