Top Iranian users in specific tag

6

Please login or register to vote for this query.

(click on this box to dismiss)

Top Iranian users in specific tag

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- C# top100 users
-- Top 100 by votes users in tag c#

DECLARE @TagName nvarchar(25) = '.net'

SELECT TOP 100
    u.Id,
    (select DisplayName from Users udn with (nolock) where udn.Id = u.Id)
    ,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 = @TagName
GROUP BY u.Id
ORDER BY UpVotes DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results