This query is marked as a draft This query has been published by Hey man im josh.

SQL

AخA
 
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 > 10
    order by AfDedits desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...