Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
select Reputation , DisplayName,Location,Name,WebsiteUrl from Badges join Users on Users.Id = Badges.Id WHERE Name like 'Enl%' and Location like 'South Africa%' Group by DisplayName, Location,Reputation,Name,WebsiteUrl order by Reputation desc ;