Question migrated from site X

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature

Q&A for scholars and enthusiasts of literature

SELECT ph.PostId AS [Post Link], ph.CreationDate AS 'Migrated on'
  FROM PostHistory AS ph
  INNER JOIN Posts AS p ON ph.PostId = p.Id
  WHERE ph.PostHistoryTypeId = 36 -- Post Migrated Here
    AND ph.Comment LIKE 'from https://' + ##domain:string## + '/%'
    AND p.PostTypeId = 1 -- Question
  ORDER BY ph.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results