shows all deleted answers for the specified user
Q&A for professional and enthusiast programmers
select p.id as [Post Link], p.LastActivityDate from posts as p INNER JOIN Users u ON p.OwnerUserId = u.Id INNER JOIN PostHistory h ON p.Id = h.PostId where p.PostTypeId = 2 and p.OwnerUserId = ##USERID## and h.PostHistoryTypeId = '12' order by p.LastActivityDate desc