Migrations from Arqade to SU

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT MigratedPosts.Id AS [Post Link], 
MigrationHistory.CreationDate AS DateMigrated,
CloseHistory.CreationDate AS DateClosed,
MigrationHistory.Comment AS OriginalUrl,
CASE WHEN CloseHistory.PostHistoryTypeID = 10 THEN 'Rejected' ELSE '' END AS [Migration Status]
FROM Posts AS MigratedPosts
JOIN Posts AS ClosedPosts ON ClosedPosts.Id = MigratedPosts.Id
JOIN PostHistory AS MigrationHistory ON MigrationHistory.PostId = MigratedPosts.Id
LEFT JOIN PostHistory AS CloseHistory ON CloseHistory.PostId = ClosedPosts.Id AND CloseHistory.PostHistoryTypeID = 10
WHERE MigrationHistory.PostHistoryTypeId = 36 -- Migrated Here
  AND MigratedPosts.PostTypeID = 1 -- Question
AND MigrationHistory.Comment LIKE 'from http://gaming.stackexchange.com%' -- From Arqade
ORDER BY MigrationHistory.CreationDate

Enter Parameters

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