Top AfD participants who aren't NPPs or Admins (1 month)

Fork of Top AfD participants who aren't NPPs or Admins (1 month) by MPGuy2824

This query is marked as a draft This query has been published by MPGuy2824.

SQL

SELECT concat("User_talk:", replace(user_name, ' ', '_') as Editor
    FROM page
	JOIN revision ON rev_page = page_id
    JOIN actor ON actor_id = rev_actor
	JOIN user ON actor_user = user_id
	WHERE page_namespace = 4
    AND page_title LIKE "Articles_for_deletion/%"
    AND page_title NOT LIKE "Articles_for_deletion/Log/%"
    AND rev_timestamp > date_add(now(), interval -30 day)
    and user_editcount > 1000
	AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group in ('sysop', 'patroller', 'bot'))
    group by rev_actor
    having count(*) > 35
    order by count(*) desc;

SQL

Checking query status...