This issue was converted from https://jira.toolserver.org/browse/DBQ-153.
Summary: two queries on user/ipblocks/group for English and Spanish Wikipedia
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>
From: Stoomagoo <stuart.easterling@gmail.com>
Date: Mon, 29 Aug 2011 05:12:30
Greetings, this is my first time submitting a query request via Toolserver.
I am interested in doing two database queries, for both English-language and Spanish-language Wikipedia (thus a total of four).
First, I would like to obtain a count of user records who have an associated ipblock who are currently in the admin group.
Secondly, I would like a count of total users currently in the admin group.
I can send sample SQL queries, but first wanted to confirm (given my first-time status) that in the right place, submitted the request correctly, etc.
Many thanks and best regards,
Stuart
Version: unspecified
Severity: major