IP edits in 1mo - reverted, total

SQL

SET @from = "20200920";
SET @to   = DATE_FORMAT(@from + INTERVAL 1 MONTH, "%Y%m%d");
SELECT @from, @to;

SELECT count(DISTINCT rev_id)  /*, ct_tag_id in (58,59) as reverted*/ FROM revision, change_tag, actor, page WHERE 
    rev_id = ct_rev_id 
AND actor_id = rev_actor 
AND page_id = rev_page
AND actor_user is NULL 
AND ct_tag_id in (58,59) /*revert and manual revert*/
AND rev_timestamp BETWEEN @from AND @to
ORDER BY rev_id DESC LIMIT 150 ;

SELECT count(rev_id) FROM revision, actor, page WHERE 
     actor_id = rev_actor 
AND page_id = rev_page
AND actor_user is NULL 
AND rev_timestamp BETWEEN @from AND @to
ORDER BY rev_id DESC LIMIT 150 ;
SQL

Checking query status...
