SELECT user_name as Editor, concat("Wikipedia:", page_title) as 'Example FLC', count(*) as "FLCs edited"

from 

( SELECT user_name , page_title

    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 page_title NOT in ("Featured_list_candidates/Closure_log", "Featured_list_candidates/backlog/items")

    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, page_title

) as x

group by user_name

having count(*) > 1

order by "FLCs edited" desc;