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;