Possible broken relative links after migration

0

Please login or register to vote for this query.

(click on this box to dismiss)

EOS.IO

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

SELECT m.PostId AS [Post Link], m.CreationDate AS 'Migration date'
  FROM PostHistory AS m
  INNER JOIN PostHistory AS b
    ON m.PostId = b.PostId
   AND b.PostHistoryTypeId = 2 -- Initial Body
  WHERE m.PostHistoryTypeId = 36 -- Post Migrated Here
    AND (b.Text LIKE '%](/q%'
      OR b.Text LIKE '%](/a%'
      OR b.Text LIKE '%](/u%'
      OR b.Text LIKE '%](/p%')
  ORDER BY m.CreationDate DESC

Enter Parameters

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