Looks at unanswered questions in your top 20 tags and sorts them by a combined weight which takes into account: score, askers reputation and how well you do on that particular tag
Q&A for experienced flyers, pilots, and builders of drones and model aircraft
-- Find interesting unanswered questions -- Looks at unanswered questions in your top 20 tags and sorts them by -- a combined weight which takes into account: score, askers reputation and how -- well you do on that particular tag -- DECLARE @UserId int = ##UserId## create table #tags (TagId int, [Count] int) insert #tags SELECT TOP 3 TagId, 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 TagId ORDER BY UpVotes DESC