SELECT u.Id AS [User Link], u.DisplayName, u.Location, u....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT u.Id AS [User Link],
u.DisplayName,
u.Location,
u.WebsiteUrl,
u.AboutMe,
u.EmailHash,
u.Views,
u.UpVotes,
u.DownVotes
FROM Users u

JOIN (
SELECT DISTINCT UserId
FROM Badges
WHERE LOWER(Name) IN ('java','solr') AND
TagBased = 1
) tag_badges
ON tag_badges.UserId = u.Id
WHERE LOWER(Location) LIKE '%usa%'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results