Newest tag wiki suggestions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Most recent tag wiki/excerpt suggestions with number of upvotes, user suggestions, etc PTId: Post Type Id 4: Excerpt 5: Wiki

Stack Overflow

Q&A for professional and enthusiast programmers

select top 250
s.Id as [Suggested Edit Link],
t.TagName,
p.PostTypeId as [PTId],
s.CreationDate,
(case when s.ApprovalDate is not null then s.ApprovalDate else s.RejectionDate end) as [A/R Date],
u.Id as [User Link],
u.Reputation,
s.Comment
from SuggestedEdits s
inner join Posts p on s.PostId=p.Id
inner join Users u on u.Id = s.OwnerUserId
inner join Tags t on (t.ExcerptPostId = p.Id OR t.WikiPostId = p.Id)
where (p.PostTypeId=4 OR p.PostTypeId=5)
order by s.CreationDate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results