0

Please login or register to vote for this query.

(click on this box to dismiss)

Find top N users that answered to questions by tag and location. Example: Find top 10 users with tag "python" located in "Boston"

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

DECLARE @NumberOfRows int = ##NumberOfRows##

SELECT TOP ##NumberOfRows##
  Users.Id AS [User Link]
  , Users.Location AS Location
  , Users.Reputation AS Reputation
  , Users.AboutMe AS About
  , Posts.Id AS [Post Link]
  , Posts.Score AS Answer_Score
  
FROM
  Tags
  JOIN PostTags ON PostTags.TagId = Tags.Id
  JOIN Posts ON Posts.ParentId = PostTags.PostId
  JOIN Users ON Users.Id = Posts.OwnerUserId
  
WHERE
  Tags.TagName COLLATE SQL_Latin1_General_CP1_CI_AS LIKE ##EnterKeyword:string##
  AND Users.Location COLLATE SQL_Latin1_General_CP1_CI_AS LIKE ##UserLocation:string##
  AND Posts.PostTypeId = 2
  
ORDER BY
  Posts.Score DESC
  
-- NumberOfRows: Number of Records
-- UserLocation: Location (city or country)
-- EnterKeyword: Enter tag or keyword

fork query

edited feb 7

created feb 2 tomordonez