0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select top 100 p.Id as [Post Link], count(e.Id) as [Undelete Events] from Posts p
inner join PostHistory e 
    on e.PostId=p.Id
    where e.PostHistoryTypeId = 13 and p.PostTypeId=1 
group by p.Id
order by [Undelete Events] desc

fork query

edited jan 7 14

created jan 7 14 jon.doe12549