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

    FROM page p

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

    (SELECT user_name

      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 rev_parent_id=0 -- first revision of the page

      AND page.page_title=p.page_title

    )

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

    group by rev_actor

    having FLCedits > 1

    order by FLCedits desc;