Q&A for apps, scripts, and development with the Stack Exchange API
SELECT u.Id AS [User Link], u.DisplayName, u.Location, u.WebsiteUrl, u.AboutMe, u.Views, u.UpVotes, u.DownVotes, u.Age FROM Users u JOIN ( SELECT DISTINCT UserId FROM Badges WHERE LOWER(Name) IN ('java', 'j2ee') AND Class IN (1, 2, 3) AND TagBased = 1 ) tag_badges ON tag_badges.UserId = u.Id WHERE LOWER(Location) LIKE '%san francisco%' OR LOWER(Location) LIKE '%mountain view%' OR LOWER(Location) LIKE '%sunnyvale%' OR LOWER(Location) LIKE '%san jose%'