Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
-- algorithm top100 users -- Top 100 by votes users in tag c# --Select Top 100 --* --from select Top 100 ROW_NUMBER() OVER(ORDER BY UpVotes DESC) AS [#],userId as [User Link] , UpVotes,siteUrl from (SELECT u.Id userId, (select DisplayName from Users udn with (nolock) where udn.Id = u.Id) UserName , (select WebsiteUrl from Users udn with (nolock) where udn.Id = u.Id) siteUrl, COUNT(*) AS UpVotes FROM Tags t with (nolock) INNER JOIN PostTags pt with (nolock)ON pt.TagId = t.id INNER JOIN Posts p with (nolock) ON p.ParentId = pt.PostId INNER JOIN Votes v with (nolock) ON v.PostId = p.Id and v.VoteTypeId = 2 inner join Users u with (nolock) on u.Id = p.OwnerUserId WHERE p.CommunityOwnedDate IS NULL and t.TagName = 'algorithm' GROUP BY u.Id ) as sss ORDER BY UpVotes DESC