deleted posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

select count(*) from postswithdeleted
where PostTypeId = 1
and deletiondate is not null
and creationdate > '2016-01-01'
and creationdate < '2017-01-01'


;


select count(*) from Posts where PostTypeId = 1
and CreationDate between '2016-01-01' and '2016-12-31'
;

select count(*) from Posts where PostTypeId = 1
and CreationDate between '2017-01-01' and '2017-12-31'
and AnswerCount = 0
;

Enter Parameters

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