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>
I'd like a list of stewards who have edited [[m:Global sysops/Vote]] as of today.
Version: unspecified
Severity: major
From: MZMcBride <mzmcbride@gmail.com>
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