PostNotices Class 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select n.PostId as [Post Link], * from PostNotices n
join Posts p on p.Id=n.PostId
join PostNoticeTypes t on t.Id=n.PostNoticeTypeId and t.ClassId = 1
where n.DeletionDate is null
and p.DeletionDate is null
order by n.CreationDate desc

Enter Parameters

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