Q&A for active researchers, academics and students of physics
-- What have I voted by tag?
-- DECLARE @UserId int = ##UserId##
SELECT --TOP 20
Posts.Body, Posts.Id, Posts.Score, Posts.OwnerDisplayName, Posts.Tags, TagName
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
TagName = 'backbone.js'