SELECT CONCAT('site://posts/', p1.Id + 1, '/revisions') A...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT CONCAT('site://posts/', p1.Id + 1, '/revisions') AS 'missing post link'
FROM PostHistory p1
LEFT JOIN PostHistory p2
ON p1.Id=p2.Id-1
WHERE p2.Id IS NULL
ORDER BY p1.Id DESC

Enter Parameters

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