Untitled query #87637

SQL

select ar_title,count(*) from archive where ar_namespace=3 and ar_timestamp like "202%" 
and ar_actor not in (select actor_id from actor where actor_name in (replace(SUBSTRING_INDEX(ar_title,"/",1),"_"," "),
                                                                     "Lowercase sigmabot III","ClueBot III",
                                                                     "MediaWiki message delivery"))
group by ar_title having count(*) > 40
and (select count(*) from logging_logindex join comment_logging on comment_id=log_comment_id
     where log_title=ar_title and log_namespace=3 and log_type="delete" and comment_text like "%G5%") < 2
SQL

Checking query status...
