Deleted posts per day

1

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

Options:
Switch sites:
loading Hold tight while we fetch your results