Políticos de Argentina editados en eswiki en RC

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

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

SQL

use eswiki_p;
SELECT distinct clp.cl_from, page_title, rc_timestamp, rc_this_oldid, a.actor_name
from categorylinks 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 clp.cl_to in ('Políticos_de_Argentina', 'Políticas_de_Argentina')
   and 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...