Grafo páginas linkeadas a Estallido Social y editadas por Serobot

SQL

with sero as
(
 SELECT
  r.rev_page,page.page_title
  FROM
      revision_userindex r
    LEFT JOIN page
      ON r.rev_page = page.page_id
  WHERE
      r.rev_actor=(SELECT actor_id FROM actor_revision WHERE actor_name='SeroBOT')
    AND r.rev_timestamp BETWEEN 20191018000000 AND 20191115000000 AND (page.page_title IN 
          (
            SELECT
                page.page_title 
            FROM
              pagelinks pl
              LEFT JOIN page
                ON pl.pl_from = page.page_id

            WHERE pl_title = 'Estallido_social'    
    )
           OR page.page_title IN (
             SELECT pl_title as page_title
                FROM pagelinks 
             WHERE 
                 pl_from = 9137022
           )


     )
  GROUP BY r.rev_page,page.page_title
)
SELECT
	page.page_title as page_from,  pl_title as page_to
FROM
  pagelinks pl
  LEFT JOIN page
    ON pl.pl_from = page.page_id
	
WHERE (pl_from in (SELECT rev_page FROM sero) OR pl_title in (SELECT page_title FROM sero)) AND pl_from_namespace = 0 AND pl_namespace = 0
SQL

Checking query status...
