0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 10 18

created oct 10 18 Laurel