2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP(##num?250##)
  s.Id AS [Suggested Edit Link],  
  concat(
          'site://tags/',
          t.tagname,
          '/info|',
          t.tagname,
          ' ',
          case when p.posttypeid = 4 then 'excerpt' else 'wiki' end
          ) [Tag Link],
   s.OwnerUserId AS [User Link], s.CreationDate, s.ApprovalDate, s.RejectionDate
FROM SuggestedEdits s LEFT OUTER JOIN Posts p ON s.PostId=p.Id
  left outer join tags t on (t.wikipostid = p.id or t.excerptpostid = p.id)
WHERE p.PostTypeId IN (4,5)  
ORDER BY s.Id DESC

fork query

edited jun 3 22

created apr 24 20 Martin20528