1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

DECLARE @UserId int = ##UserId##

select *
from (select displayname, reputation, count(distinct badges.name) as badges
from badges
inner join users on users.id = badges.userid
inner join (select top 40 id, tagname
            from tags
            order by count desc) tags on tags.tagname = badges.name
            group by displayname, reputation) t
where badges >= 10
order by badges desc

view current version

edited jan 22 13

created jan 22 13 Olaf Dietsche