select distinct u.id as [User ID], u.displayname as [User...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

select distinct 
 u.id as [User ID], 
 u.displayname as [User Name],
 u.reputation as [Reputation]
from users u join badges b
on u.id = b.userid
where upper(u.location) like upper('%' + ##YourLocation:string## + '%')
order by u.id

Enter Parameters

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