Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
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 FROM Users u JOIN ( SELECT DISTINCT UserId FROM Badges WHERE LOWER(Name) IN ('ruby', 'unix commands', 'kafka', 'python', 'sql', 'web-applications') AND Class IN (1) AND TagBased = 1 ) tag_badges ON tag_badges.UserId = u.Id WHERE LOWER(Location) LIKE '%montreal%' OR LOWER(Location) LIKE '%toronto%' OR LOWER(Location) LIKE '%ottawa%'