Q&A for professional robotic engineers, hobbyists, researchers and students
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