Engineer conditions


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for active researchers, academics and students of physics

select count(p.Id)
from Posts as p join Posts as q on
(select top 1 Id from posts where parentId = q.Id) = p.Id -- only answers
and p.CreationDate < DATEADD(month, -3, GETDATE()) -- at least 3 months old
and p.LastEditDate < DATEADD(month, -3, GETDATE()) -- at least 3 months untouched
and LEN(p.Body) > 750 -- more than 450 chars used (TODO: striptags)
and q.ClosedDate IS NULL and p.CommunityOwnedDate IS NULL -- not closed, not community wiki
and q.AnswerCount <= 10 -- not more than 30 answers (pagination)
and p.Score >= 3

Enter Parameters

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