Q&A about the site for operations research and analytics professionals, educators, and students
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 = 36 -- Migrated away and p.posttypeid = 1 -- question order by CreationDate