1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for system and network administrators

select 
  Posts.id as [Post Link],
  SuggestedEdits.ApprovalDate as ApprovedDate,
  SuggestedEdits.RejectionDate as RejectionDate,
  SuggestedEdits.CreationDate as EditDate,
  Posts.CreationDate as PostDate,
  DateDiff(day, Posts.CreationDate, SuggestedEdits.CreationDate) as datedifference
from 
  SuggestedEdits
  inner join Posts on Posts.Id = SuggestedEdits.PostId
where 
  SuggestedEdits.OwnerUserId = ##UserId:int##
  and DateDiff(day, Posts.CreationDate, SuggestedEdits.CreationDate) > ##OlderThanDays:int?183##
order by datedifference

view current version

edited dec 9

created dec 1 PeterJames