Top FLC commenters (1y)

Fork of Top AfD participants who aren't NPPs or Admins (1 month) by MPGuy2824

This query is marked as a draft This query has been published by MPGuy2824.

SQL

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 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 rev_parent=0 -- first revision of the page
    AND page_title LIKE "Featured_list_candidates/%"
    AND rev_timestamp > date_add(now(), interval -120 day);

SQL

Checking query status...