Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
select top 10 Users.Id as [User Link], Users.*, TopOwners.Count
select top 10 OwnerUserId, count(*) as Count
where tags like '%<solr>%'
group by OwnerUserId
order by Count desc
) as TopOwners
on Users.id = TopOwners.OwnerUserId
--order by Count
--select * from Tags where TagName = 'solr'