1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

DECLARE @user_id INT = 1366033;
DECLARE @tag_id  INT = (SELECT ID FROM Tags WHERE TagName = 'twitter-bootstrap');
DECLARE @answer  INT = (SELECT ID FROM PostTypes WHERE Name = 'Answer');

SELECT TOP 25
  RANK() OVER (ORDER BY SUM(a.Score) DESC) AS Rank,
  u.ID AS [User Link],
  SUM(a.Score) AS Score,
  CASE WHEN u.ID = @user_id THEN '<--' ELSE '' END
FROM users u
JOIN Posts a ON u.ID = a.OwnerUserId AND a.PostTypeID = @answer
JOIN Posts p ON a.ParentID = p.ID
JOIN PostTags t ON p.ID = t.PostId AND t.TagID = @tag_id
GROUP BY u.ID
ORDER BY SUM(a.Score) DESC

fork query

created apr 23 14 KyleMit