1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

create table #validaccounts(accountid int primary key)

declare @sql nvarchar(max)
select @sql = concat(N'insert into #validaccounts 
select distinct accountid 
from (',
STRING_AGG(concat(N'
select users.accountid 
from [', convert(nvarchar(max),name), N'].dbo.users 
inner join [', convert(nvarchar(max),name), N'].dbo.badges b on b.userid = users.id 
inner join users h on h.accountid = users.accountid
where users.reputation > 1
group by users.accountid
having count(*) > 1
' ) ,' union all ')
,' ) data')
from sys.databases
where database_id > 5
and (name not like '%.Meta'  and name not like '%_Temp' or name = 'StackExchange.Meta')

exec(@sql)

select id as [User Link]
, aboutme
from users
left outer join #validaccounts va on va.accountid = users.accountid
where reputation = 1
and va.accountid is null
and views = 0
and len(aboutme) > 1
order by creationdate desc

print '##cachebreaker##'

fork query

edited apr 3 22

created feb 6 22 rene