Deleted posts per day


Please login or register to vote for this query.

(click on this box to dismiss)

Graph of the most infamous days on the site.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select Day, count(pwd.Id) as [Deleted posts]
from PostsWithDeleted pwd
left join Posts p on p.Id = pwd.Id
right join (select distinct
        datefromparts(year(CreationDate), month(CreationDate), day(CreationDate))
        as Day from Posts) as Dates
    on year(pwd.CreationDate) = year(Day)
    and month(pwd.CreationDate) = month(Day)
    and day(pwd.CreationDate) = day(Day)
where p.Id is null
group by Day
order by Day desc

Enter Parameters

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