Botartiklar som inte längre är botflaggade

SQL

SELECT distinct page_title
FROM  revision r, page p, categorylinks cl
WHERE   rev_page = page_id
AND   rev_actor = 257
AND   rev_parent_id = 0
AND   rev_timestamp >='20150801000000'
AND   page_namespace = 0
AND   page_is_redirect = 0
AND   cl_from = page_id
AND   NOT EXISTS 
(select cl_from from categorylinks
 where cl_from = p.page_id and cl_to in
(select page_title from page where page_id in
(select cl_from from categorylinks
 where cl_to ="Robotskapade_geografiartiklar"))
AND NOT EXISTS
(select cl_from from categorylinks
 where cl_from = p.page_id and cl_to in 
 ("Robotskapade_förgreningssidor", "Förgreningssidor"))
)
 LIMIT 100

SQL

Checking query status...