Suggested edits on tag-infos between two dates

1

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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)) 
  AND (s.CreationDate >= '##Date1?2022-04-01##') AND (s.CreationDate <= '##Date2?2022-07-01##')
ORDER BY s.Id DESC

Enter Parameters

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