Rank users by Country

1

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

declare @country varchar(max) = '##Country##';

SELECT ID AS UserID, * FROM Users 
WHERE (Location LIKE @country)
ORDER BY Reputation DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results