Get Posts with at least three answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chinese Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

SELECT ROW_NUMBER() OVER(ORDER BY Id DESC), * 
FROM Posts a
WHERE a.PostTypeId = 2 and
a.OwnerUserId not in (
SELECT OwnerUserId From Posts p WHERE p.PostTypeId = 1 AND p.Id = a.ParentId) AND
a.ParentId not in (SELECT Id FROM Posts p WHERE PostTypeId = 1 AND p.answercount < 3);

Enter Parameters

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