List bounties

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature

Q&A for scholars and enthusiasts of literature

SELECT 
'site://q/' + CAST(q.Id AS NVARCHAR) + '/' + ISNULL(CAST(m.Id AS NVARCHAR), '0') + '|' + q.Title AS "Post Link", 
q.Tags AS Tags, q.CreationDate AS QDate,
'site://users/' + CAST(qu.Id AS NVARCHAR) + '|' + qu.DisplayName AS QUser, 
n.CreationDate AS BDate,
'site://users/' + CAST(nu.Id AS NVARCHAR) + '|' + nu.DisplayName AS BUser, 
n.PostNoticeTypeId AS BType,
n.Body AS BText,
n.Id AS BId
FROM PostNotices AS n
JOIN PostNoticeTypes AS nt ON n.PostNoticeTypeId = nt.Id
LEFT JOIN Posts AS q ON n.PostId = q.Id
LEFT JOIN Users AS qu ON q.OwnerUserId = qu.Id 
LEFT JOIN Users AS nu ON n.OwnerUserId = nu.Id
LEFT JOIN Users AS m ON m.AccountId = 1192385
WHERE 2 = ClassId
ORDER BY n.CreationDate DESC;

Enter Parameters

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