List bounties

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT 
q.Id AS "Post Link", q.Tags AS Tags, 
nu.Id AS "User Link", 
n.*
FROM PostNotices AS n
JOIN PostNoticeTypes AS nt ON n.PostNoticeTypeId = nt.Id
LEFT JOIN Users AS nu ON n.OwnerUserId = nu.Id 
LEFT JOIN Posts AS q ON n.PostId = q.Id
WHERE 2 = ClassId
ORDER BY n.CreationDate DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results