Users with Privileges: ELU vs. ELL

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

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')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results