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],
where Reputation > ##MinRep##
(Location like ##LocationLike##)
order by [Reputation] desc