0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in the history and origins of science and mathematics

DECLARE @tagName nvarchar(35) = '##tagName##'
SELECT top 50 
  TagName, 
  Location, 
  SUM(case votes.votetypeid
    WHEN 2 THEN 1 -- upvote 
    WHEN 3 THEN -1 -- downvote
    END) as Rep,
   Users.DisplayName as UserName, 
  number = ROW_NUMBER() OVER (ORDER BY TagName) 
FROM Tags 
  INNER JOIN PostTags ON PostTags.TagId = Tags.id 
  INNER JOIN Posts ON Posts.ParentId=PostTags.PostId
  INNER JOIN Users ON Posts.OwnerUserId = Users.Id 
  INNER JOIN Votes ON Votes.PostId = Posts.Id 
WHERE Tags.TagName =@tagName 
AND LOWER(Location) LIKE LOWER('manchester') 
  AND Posts.CommunityOwnedDate IS NULL 
GROUP BY TagName, DisplayName, Location 
ORDER BY Rep DESC

fork query

edited jun 7 21

created jun 7 21 anonymous