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, Posts.id as [Post Link], Posts.Tags as [Tagged With], u.Reputation, Posts.Score, Posts.AnswerCount FROM Users u Join Posts on (u.Id=Posts.OwnerUserId) And Upper(Posts.Tags) LIKE Upper('%##TagName##%') AND Upper(u.Location) LIKE Upper('%##Location##%') AND Upper(u.AboutMe) LIKE Upper('%##RoleName##%') Order By Posts.Score DESC;