Q&A about the site for Drupal developers and administrators
SELECT 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, u.Reputation FROM Users u JOIN ( SELECT DISTINCT UserId FROM Badges WHERE Upper(Name) = Upper('##SkillName##') AND Class IN (1, 2, 3) AND TagBased = 1 ) tag_badges ON tag_badges.UserId = u.Id Where Upper(Location) LIKE Upper('%##Location##%')