select count(p.Id) from Posts p inner join Users u on u.I...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

Q&A about the site for people studying math at any level and professionals in related fields

select count(p.Id)
from Posts p
inner join Users u
on u.Id=p.OwnerUserId
left outer join PendingFlags pf
on pf.PostId=p.Id
left outer join SuggestedEdits se
on se.PostId=p.Id
where (u.Reputation<=50 or u.CreationDate>=getdate()-45)
and (p.CreationDate between datefromparts(2020,01,01) and datefromparts(2020,12,31))
and (p.CommentCount=0 and p.Score=0 and p.ClosedDate is null and pf.PostId is null and se.PostId is null)
and (p.AnswerCount=0 or p.AnswerCount is null)

Enter Parameters

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