SELECT p.Id AS [Post Link] FROM Posts p INNER JOIN PostH...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

-- Enter Query Title
-- Enter Query Description

SELECT 
    p.Id AS [Post Link]
FROM
    Posts p
INNER JOIN 
    PostHistory h ON h.PostId = p.Id
INNER JOIN 
    PostHistoryTypes t ON t.Id = h.PostHistoryTypeId 
WHERE 
    p.ParentID IS NULL AND t.Name LIKE 'Post Migrated'

Enter Parameters

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