select ph.PostId as [Post Link] , ph.CreationDate , ph.Us...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

select ph.PostId as [Post Link]
     , ph.CreationDate
     , ph.UserId as [User Link]
     , ph.UserDisplayName
     , ph.Comment as target
from posthistory ph
inner join posts p on p.id = ph.postid
where posthistorytypeid = 35 -- Migrated away
and p.posttypeid = 1 -- question
order by CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results