0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

SELECT SUM(p.Score), u.DisplayName
FROM Users u
INNER JOIN Posts p ON u.Id = p.OwnerUserId
INNER JOIN Posts par ON p.ParentId = par.Id
INNER JOIN PostTags pt ON pt.PostId = par.Id
INNER JOIN Tags t ON pt.TagId = t.Id
WHERE 
LOWER(u.Location) LIKE '%##Location##%'
AND t.TagName = '##Tag##'
GROUP BY u.DisplayName
ORDER BY SUM(p.Score) DESC


--SELECT --TOP 20 
--    TagName,
--    COUNT(*) AS UpVotes 
--FROM Tags
--    INNER JOIN PostTags ON PostTags.TagId = Tags.id
--    INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
--    INNER JOIN Votes ON Votes.PostId = Posts.Id and VoteTypeId = 2
--WHERE 
--    Posts.OwnerUserId = @UserId
--GROUP BY TagName 
--ORDER BY UpVotes DESC

fork query

edited feb 9 14 Anders A

created may 24 10 sam.saffron