SELECT TOP 10 p.id FROM posts p INNER JOIN posts q ON p.P...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT TOP 10 p.id 
FROM posts p
INNER JOIN posts q
ON p.ParentId = q.id
INNER JOIN posts otherAnswer
ON  q.id = otherAnswer.ParentID
and p.id <> otherAnswer.ID
INNER JOIN comments c
on otherAnswer.id = c.postid
WHERE 
p.PostTypeID = 2

Enter Parameters

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