select count(*) from Posts p inner join Users u on p.Owne...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

select count(*)
from Posts p
inner join Users u
on p.OwnerUserId=u.Id
inner join Comments c
on c.PostId=p.Id
full outer join PendingFlags pf
on pf.PostId=p.Id
where (p.CreationDate between datefromparts(2020,01,01) and datefromparts(2020,12,31))
and pf.PostId is not null

Enter Parameters

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