1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

Select TOP(100) ROW_NUMBER() OVER (ORDER BY Reputation Desc) as Number, Id [User Link], DisplayName, Reputation, Location
From Users
Where LOWER(Location) LIKE LOWER('%##CountryName##%')
ORDER BY
    Reputation DESC;

fork query

edited jul 23 19

created oct 10 13 aIKid