Page MenuHomePhabricator

DBQ-153 two queries on user/ipblocks/group for English and Spanish Wikipedia
Closed, ResolvedPublic

Description

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

Details

Reference
bz59415

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:29 AM
bzimport set Reference to bz59415.

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