Anonymous Edits

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
  s.Id,
  s.PostId AS [Post Link],
  v.UserId AS [Voter Id],
  case when s.ApprovalDate is not null then 'Approved' else 'Rejected' end as Approved,
  case when s.ApprovalDate is not null then s.ApprovalDate else s.RejectionDate end as ApprovalOrRejectionDate,
  case when v.UserId = -1 then 'Improved' else '' end as Improved -- voted on by Community?
from
  SuggestedEdits s, SuggestedEditVotes v
where
  s.Id = v.SuggestedEditId
  and s.OwnerUserId is null -- anonymous
  and (s.ApprovalDate is not null or s.RejectionDate is not null) -- not pending
  and s.CreationDate BETWEEN ##startDate:string## AND ##endDate:string##

Enter Parameters

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