/**

SELECT user_name as Editor, page_title as 'Example FLC', count(*) as FLCedits

    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 user_name!="FACBot"

    AND page_title LIKE "Featured_list_candidates/%"

    AND rev_timestamp > date_add(now(), interval -30 day)

    group by rev_actor

    having FLCedits > 1

    order by FLCedits desc;

*/

SELECT user_name as Editor, page_title as 'FLC'

    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 user_name!="FACBot"

    and rev_parent_id=0 -- first revision of the page

    AND page_title LIKE "Featured_list_candidates/%"

    AND rev_timestamp > date_add(now(), interval -120 day);