Users by Location Having a Minimum Reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- 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 [- Votes],
  Location,
  AboutMe,
  LastAccessDate
from Users
where Reputation > ##MinRep##
  and
  (Location like ##LocationLike##)
order by [Reputation] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results