What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 133 Stack Exchange communities.

Is there any way to use the Stack Exchange Data Explorer to see the questions that are migrated between different sites?

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Yes, for each site, you can find questions that have both been imported to and exported from it.

Start with this query, which shows all migration activity:

SELECT *
   FROM Posts p
   INNER JOIN PostHistory ph ON ph.PostId = p.Id
   WHERE ph.PostHistoryTypeId = 17
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .