Políticos de Perú editados en eswiki en RC

Fork of Políticos de Perú editados en eswiki en RC by Superzerocool

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

SQL

SELECT distinct clp.cl_from, page_title, rc_timestamp, rc_this_oldid, a.actor_name
from (SELECT clchild.cl_from cl_from
	FROM categorylinks clparent
		inner join page pparent on clparent.cl_from = pparent.page_id
		inner join categorylinks clchild on clchild.cl_to = pparent.page_title
		WHERE clparent.cl_to = 'Políticos_de_Perú_por_partido'
			and clparent.cl_type = 'subcat'
		    and clchild.cl_type = 'page') AS clp
inner join page on clp.cl_from = page_id
inner join categorylinks clv on clv.cl_from = page_id
inner join recentchanges rc on rc.rc_cur_id = page_id
inner join actor a on rc.rc_actor = a.actor_id
WHERE clv.cl_to = 'Personas_vivas'
   and page_namespace = 0
   and rc_type = 0
   and rc_bot = 0
order by rc.rc_id desc

SQL

Checking query status...