Orphan questions that were migrated from another site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions that are migrated between different sites

Academia Meta

Q&A about the site for academics and those enrolled in higher education

-- Orphan questions that were migrated from another site
-- Questions that are migrated between different sites

SELECT
  p.Id As [Post Link],
  p.CreationDate As [Date],
  p.OwnerDisplayName As [Displayed owner name],
  ph.Comment As [Comment]
FROM Posts p
INNER JOIN PostHistory ph ON ph.PostId = p.Id
WHERE ph.PostHistoryTypeId = 17
  AND p.OwnerUserId = NULL

Enter Parameters

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