0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT TOP 700 q.Id,q.AcceptedAnswerId,q.AnswerCount,q.CreationDate,q.PostTypeId,q.Score,q.Tags,q.ViewCount,a.Id,a.CommentCount,a.ParentId,a.CreationDate FROM Posts as q
JOIN Posts as a ON q.id = a.ParentId AND
a.CommentCount > 2 and a.CommentCount < 8 and a.PostTypeId = 2
WHERE q.AcceptedAnswerId <> Null  AND q.PostTypeId = 1 and q.AnswerCount >= 3

view current version

edited sep 2

created sep 2 anonymous