Grab All Answers with Tags Matching Suspect Answer Tags

1

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 a.Id
FROM Posts q
	INNER JOIN Posts a ON a.ParentId = q.Id
	INNER JOIN PostTags pt ON pt.PostId = q.Id
WHERE pt.TagId IN (
	SELECT DISTINCT TagId
	FROM Posts q
		INNER JOIN Posts a ON a.ParentId = q.Id
		INNER JOIN PostTags pt ON pt.PostId = q.Id		 
	WHERE a.OwnerUserId = ##UserId:int##
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results