Which users have close vote privileges both here and on ELL?

Question

Not too long ago, I unlocked the cast close and reopen votes privilege... on ELL. Here on ELU I've had that privilege for a pretty long time, since I just recently unlocked the very last privilege (site statistics at 25,000 rep).

In any case, getting to 3,000 reputation is a pretty significant milestone. It's an important way that users can influence the site, and the influence is greater than the sum of its parts when you have it on both ELU and ELL because of how linked the two sites are. More significantly, people who have close votes on ELL should have a decent knowledge of the scope of the site, which is important when deciding if a question is off-topic: is it on-topic on ELL (making migration an option) or is it off-topic on both sites?

Thus, my question is: which users have close/reopen privileges on both ELU and ELL?

Answer 1

Through the magic of T-SQL I've found the answer. You can run my query here, with the data being updated weekly. There are currently 57 users with close/reopen privileges on both sites (not including CMs, except Catija because she has the rep).

Actually, with this query I did one better than what I asked: it works for any privilege. Simply enter a number in the "RepuationThreshold" corresponding to the privilege level you want to see users for. For example, 500 shows users with the minimum review privileges, 3000 is close/reopen privileges, 10000 is users who can see deleted posts & vote to delete questions.

Another significant thing I learned from this query is that there are 5 people who have attained 25,000 on both sites.

Here's teh codez:

create table #Yall (
 globalid int,
 ELUid int,
 site varchar (3)
);

use [StackExchange.English]; -- Just to be sure

insert into #yall select accountid, id, 'ELU' from users where reputation >=##RepuationThreshold##;

use [StackExchange.ELL];

insert into #yall select accountid, 0, 'ELL' from users where reputation >=##RepuationThreshold##;

use [StackExchange.English];

select ELUid as [User Link] from #yall where site='ELU' and globalid in (select globalid from #yall where site='ELL')