SeroBots relacionados con Estallido_social

SQL

SELECT
	r.rev_id,r.rev_page,r.rev_timestamp,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_tiles 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
         )
          
                                                                   
   )
SQL

Checking query status...
