Top users answering questions for specific tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select top 10 Users.*, TopOwners.Count
from 
(
  select top 10 OwnerUserId, count(*) as Count
  from Posts
  where tags like '%<solr>%'
  group by OwnerUserId
  order by Count desc
) as TopOwners
INNER JOIN
Users
on Users.id = TopOwners.OwnerUserId
--order by Count


--select * from Tags where TagName = 'solr'
--id: 1866

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results