select posttypeid , count(*) from postswithdeleted where ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

select posttypeid
     , count(*)
from postswithdeleted 
where deletiondate is not null
group by posttypeid

select 'site://posts/' + cast(id as nvarchar) +'/revisions'
     , *
from postswithdeleted 
where posttypeid = 5
and deletiondate is not null

Enter Parameters

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