Last modified: 2014-01-03 16:04:59 UTC
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
------------------------------------------------------------------------------- From: Stoomagoo <stuart.easterling@gmail.com> Date: Mon, 29 Aug 2011 06:49:20 ------------------------------------------------------------------------------- I should add that I know that I can obtain the total # of admins elsewhere; I just want to ensure that I obtain the total at the time of the first query (admins with an associated ipblocks).
------------------------------------------------------------------------------- From: Stoomagoo <stuart.easterling@gmail.com> Date: Mon, 29 Aug 2011 06:58:24 ------------------------------------------------------------------------------- Sorry, one more comment. ![][1] The first query is not looking for a count of admins who have made a block, but rather a count of those who have been blocked at some point. So it would be (I believe) where ipblocks.ipb_user = the user ID of the admin. [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Thu, 01 Sep 2011 14:25:39 ------------------------------------------------------------------------------- SQL: SELECT COUNT(*) FROM user_groups WHERE ug_group = 'sysop'; SELECT COUNT(*) FROM user_groups INNER JOIN ipblocks ON ipb_user = ug_user WHERE ug_group = 'sysop'; No result, cause on neither en nor eswiki one admin had an ipblock associated with him. May you want to search the log table, which also contains inactive blocks?
------------------------------------------------------------------------------- From: Stoomagoo <stuart.easterling@gmail.com> Date: Wed, 07 Sep 2011 06:17:42 ------------------------------------------------------------------------------- Many thanks! Forgive the delay in my reply. I see, OK, it wouldn't be in ip_blocks, but in the logs. I was about to get this basic info elsewhere, however. (Sorry to have wasted your time. ![][1] However, there's another query that I don't think I can get manually - I assume I should just submit another request? Thank you again, Stuart [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Wed, 07 Sep 2011 19:24:54 ------------------------------------------------------------------------------- Feel free to open a new request, if it's on a different subject, if not just reopen this one ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
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: hoo@online.de CC list: hoo@online.de