1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT Id [User Link], Reputation, DisplayName, Location
FROM Users
WHERE 
Id IN (
        SELECT PostHistory.UserId FROM PostHistory 
        INNER JOIN Posts ON PostHistory.PostId = Posts.Id
        WHERE Posts.Tags LIKE '%##Tag##%'
      )
AND Location LIKE '%##Location##%'
ORDER BY Reputation DESC

fork query

created apr 5 16 Jake Kreider