Q&A about the site for administrators, end users, developers and designers for Craft CMS
-- Show active users from the Country.
-- loc: User's location: "What is the user's location"
Id as [User Link], DisplayName, AboutMe, WebsiteUrl, *
FROM Users u
WHERE UPPER(u.Location) LIKE UPPER(##loc:string?Lithuania##)
ORDER BY Reputation DESC,