Untitled query #52401

SQL

use tewiki_p;
SELECT actor_name, COUNT(actor_name) as edits
FROM revision,actor,page
WHERE actor_id=rev_actor
	and page_id=rev_page
	and page_namespace=0
    and substr(rev_timestamp,1,4)="2020"
	and actor_name in (
      	select log_title from logging 
    	where `log_type` = 'newusers' /* exclude proxy registrations */
		AND `log_action` = 'create' /* only include self-created users, exclude attached and proxy-registered users */
    	and substr(log_timestamp,1,4)="2020")
GROUP BY actor_name
having count(actor_name)>=1000
ORDER BY COUNT(actor_name) DESC
SQL

Checking query status...
