use eswiki_p;

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_Chile_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