SELECT Answers.ID AS [Post Link] FROM Posts Questions INN...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Answers.ID AS [Post Link]
FROM Posts Questions
INNER JOIN PostTags ON PostTags.PostId = Questions.Id
INNER JOIN Tags ON PostTags.TagId = Tags.Id
INNER JOIN Posts Answers ON Answers.ParentId = Questions.Id
WHERE 
  Questions.PostTypeId = 1 AND
  Questions.CommunityOwnedDate IS NULL AND
  Questions.OwnerUserId = 5528593 AND
  Tags.TagName = 'linq' AND
  Answers.PostTypeId = 2 AND
  Answers.OwnerUserId = 5528593

Enter Parameters

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