Migrations from specified site to this one

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

select
  ph.postid as [Post Link],
  ph.*
from
  Posts p
  inner join PostHistory ph on ph.PostId = p.Id
where
  ph.PostHistoryTypeId = 36 -- Post Migrated Here
  and ph.Comment like '%://##FromSiteURLStart##%' -- e.g. ell, english, stackoverflow
  and p.posttypeid = 1 -- Question
order by ph.creationdate desc

Enter Parameters

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