เวลาที่ยาวที่สุดระหว่างการแก้ไขติดต่อกันเป็นวัน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Longest time between consecutive edits by days.It is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
WITH Raw AS (SELECT MIN(Id) AS Id, MIN(PostId) AS PostId, RevisionGUID, MIN(CreationDate) AS CreationDate FROM PostHistory WHERE PostHistoryTypeId <= 6 GROUP BY RevisionGUID), Raw2 AS (SELECT *, RANK() OVER (PARTITION BY PostId ORDER BY Id) AS No FROM Raw) SELECT Prv.PostId AS "post_link", Prv.CreationDate AS Edit1, Nxt.CreationDate AS Edit2, 1.0 * CAST((JULIANDAY(Nxt.CreationDate) - JULIANDAY(Prv.CreationDate)) AS INT) / 86400 AS DayDiff FROM Raw2 AS Prv, Raw2 AS Nxt WHERE Prv.PostId = Nxt.PostId AND Prv.No + 1 = Nxt.No AND Prv.CreationDate < Nxt.CreationDate ORDER BY DayDiff DESC, Prv.Id LIMIT 100