Closed [r] questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT 
  p.Id AS [Post Link], 
  p.Title, 
  p.Body,
  p.ClosedDate
FROM 
  Posts p
JOIN 
  PostTags pt ON p.Id = pt.PostId
JOIN 
  Tags t ON t.Id = pt.TagId
WHERE 
  p.PostTypeId = 1 -- 1 for questions
  --- AND p.ClosedDate IS NOT NULL -- closed questions
  AND t.TagName = 'r' -- tagged with 'r'
  AND (p.Body LIKE '%create_icd_flags%' )
ORDER BY 
  p.ClosedDate DESC -- Order by most recently closed questions

Enter Parameters

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