CSD - G8 candidates

SQL

SELECT user_name as Editor, page_title as 'Example AFD page', count(*) as AfDedits
    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 "Featured list candidates/%"
    AND rev_timestamp > date_add(now(), interval -2 day)
    and user_editcount > 1000
	AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group in ('bot'))
    group by rev_actor
    having AfDedits > 1
    order by AfDedits desc;
SQL

Checking query status...
