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.

Q&A for professional and enthusiast programmers

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

fork query

edited may 25 16

created may 24 16 amaranth