Q&A for Joomla! administrators, users, developers and designers
select TOP 50 * from Users where LOWER(Location) LIKE LOWER('%##location##%') order by reputation DESC