0

Please login or register to vote for this query.

(click on this box to dismiss)

Sums total reputation on a site for each tag

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- Reputation by Tag
-- Sums total reputation on a site for each tag

SELECT COUNT(*) AS TotalVotes,
       v.VoteTypeId
FROM Posts AS q
INNER JOIN Posts AS a ON a.ParentId = q.Id
INNER JOIN PostTags AS pt ON pt.PostId = q.Id
-- JOIN Tags AS t ON t.Id = pt.TagId
INNER JOIN Votes AS v ON v.PostId = a.Id
WHERE q.Id = 1
GROUP BY v.VoteTypeId

fork query

created dec 16 10 jason.berkan