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)

Spanish Language

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

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 meta site
loading Hold tight while we fetch your results