Find users by location and tag


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"

History of Science and Math

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

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
  JOIN PostTags ON PostTags.TagId = Tags.Id
  JOIN Posts ON Posts.ParentId = PostTags.PostId
  JOIN Users ON Users.Id = Posts.OwnerUserId
  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
  Posts.Score DESC
-- NumberOfRows: Number of Records
-- UserLocation: Location (city or country)
-- EnterKeyword: Enter tag or keyword

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results