Closed [r] questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

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 '%British Columbia%' )
ORDER BY 
  p.ClosedDate DESC -- Order by most recently closed questions

Enter Parameters

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