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);