0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Users by Location Having a Minimum Reputation
-- Search for users by the Location string and limit the results by a minimum reputation.
-- LocationLike: Enter '%ashville%' (including single quotes) to find users in 'Nashville, TN'

select top 1000
  id as [User Link],
  round((100.0 * (Reputation/10)) / (Upvotes+1), 2) as [Ratio %],
  Reputation as Rep, 
  UpVotes as [+ Votes],
  DownVotes as [- Votes],
  Location,
  WebsiteUrl as [Website URL],  
  AboutMe,
  LastAccessDate as [Last Access Date],
  Age
from Users
where Reputation > ##MinRep##
  and
  (Location like ##LocationLike##)
order by [Age] desc

fork query

edited feb 27 13

created feb 18 13 Robert Claypool