Q&A for project managers
SELECT TOP 50 Usr.Id [User Link], Reputation, DisplayName, LastAccessDate, WebsiteUrl, Location, AboutMe, Views, UpVotes, DownVotes, ProfileImageUrl, EmailHash, Age, AccountId, Comments.Text, PostHistory.Text FROM Users Usr FULL OUTER JOIN PostHistory ON PostHistory.UserId = Usr.Id FULL OUTER JOIN Comments ON Comments.UserId = Usr.Id WHERE ( Usr.Location LIKE '%an %' OR Usr.Location LIKE ', CA' ) AND ( Usr.AboutMe LIKE '%@%' OR Usr.AboutMe LIKE '%gmail%' OR Usr.AboutMe LIKE '%linkedin%' OR Usr.AboutMe LIKE '%indeed%' ) AND ( ( Comments.Text LIKE '%adoop%' OR Comments.Text LIKE '%ongo%' OR Comments.Text LIKE '%assandra%' ) OR ( PostHistory.Text LIKE '%adoop%' OR PostHistory.Text LIKE '%ongo%' OR PostHistory.Text LIKE '%assandra%' ) )