Last modified: 2014-01-03 13:05:25 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-85. Summary: List members of a user group who have edited a page Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Mike.lifeguard <mike.lifeguard+ts@gmail.com> Date: Mon, 11 Jan 2010 18:06:49 ------------------------------------------------------------------------------- I'd like a list of stewards who have edited [[m:Global sysops/Vote]] as of today.
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Mon, 11 Jan 2010 19:18:53 ------------------------------------------------------------------------------- mysql> SELECT -> rev_user_text, -> COUNT(*) -> FROM revision -> JOIN page -> ON rev_page = page_id -> JOIN user_groups -> ON rev_user = ug_user -> WHERE page_namespace = 0 -> AND page_title = 'Global_sysops/Vote' -> AND ug_group = 'steward' -> GROUP BY rev_user_text; +----------------+----------+ | rev_user_text | COUNT(*) | +----------------+----------+ | Darkoneko | 2 | | DerHexer | 2 | | Dungodung | 1 | | Erwin | 1 | | Jusjih | 1 | | Laaknor | 1 | | Lar | 1 | | Leinad | 5 | | M7 | 1 | | Mav | 3 | | Mike.lifeguard | 15 | | Millosh | 1 | | Nick1915 | 2 | | Oscar | 1 | | Thogo | 2 | +----------------+----------+ 15 rows in set (1.02 sec) I think this is what you want. Re-open if not.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: b@mzmcbride.com, mike.lifeguard+bugs@gmail.com