Sorting and filtering posts with notices

Question

Posts that have post notices can be seen on https://<site>.stackexchange.com/annotated-posts?tab=noticed. This includes posts that have notice types "Citation Needed", "Insufficient Explanation", etc., and also includes bounty notices.

"Citation Needed" post notices (example below) are often used by sites that insist on answers being backed up with authoritative references.

Some of the information contained in this post requires additional references. Please edit to add citations to reliable sources that support the assertions made here. Unsourced material may be disputed or deleted.

I want to filter the posts that have notices by specific notice types, e.g "Citation Needed". I also want to sort them by newest/oldest since sometimes such unsourced posts require action.

Answer 1

This SEDE query will do that for you; feel free to fork it to suit your needs.

For reference, here is the complete query:

SELECT n.PostId AS [Post Link],
  n.CreationDate AS 'Notice added',
  p.CreationDate AS 'Post created'
  FROM PostNotices AS n
  INNER JOIN Posts AS p ON n.PostId = p.Id
  WHERE n.PostNoticeTypeId = ##PostNoticeTypeId:int?1## -- 1 = Citation Needed
    AND n.DeletionDate IS NULL
  ORDER BY p.CreationDate ASC

SEDE is updated once a week on Sunday morning, so some notices might have been removed already.