Q&A for professional and enthusiast programmers
SELECT Distinct u.Id AS [User Link], CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link], u.DisplayName, u.Location, u.WebsiteUrl, u.AboutMe, u.Views, u.UpVotes, u.DownVotes, u.EmailHash, p.id as [Post Link], p.Tags as [Tagged With], u.Reputation, p.Score FROM Users u, Posts p WHERE (u.Id=p.OwnerUserId) And Upper(p.Tags) LIKE Upper('%##TagName##%') AND Upper(u.Location) LIKE Upper('%##Location##%') Order By u.Reputation DESC;