Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
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