Q&A for SharePoint enthusiasts
SELECT p.Id+1, p.DeletionDate, n.NextId - p.Id - 1 AS 'Missing post ID', CONCAT('site://posts/', p.Id + 1, '/revisions') AS 'First missing post' FROM Posts AS p CROSS APPLY ( SELECT MIN(Id) AS NextId FROM Posts WHERE Id > p.Id ) n WHERE n.NextId - p.Id != 1 and p.DeletionDate >= ##date1:string## and p.DeletionDate <= ##date2:string## ORDER BY p.Id