https://bugzilla.wikimedia.org/show_bug.cgi?id=59248

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: MZMcBride <mzmcbr...@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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to