Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Find Stack Overflow Users In Your City (with user-links)
- -- A simply query to find users in your city or country. Added user links.
- select distinct u.Id [User Link], u.Reputation, u.DisplayName, u.Location, u.WebsiteUrl, u.AboutMe, u.EmailHash, u.Age
- from Users u
- inner join Posts p on u.Id = p.OwnerUserId
- where (u.Location like '%##Location##%') and (p.Tags like '%objective-c%' or p.Tags like '%ios%' or p.Tags like '%iphone%' or p.Tags like '%android%' or p.Tags like '%android%')
- order by u.Reputation desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement