Q&A for designers and implementers of computer programming languages
SELECT TOP(##num?500##) a.Id, url = 'site://a/' + CAST(a.Id AS varchar), revisions = 'site://posts/' + CAST(a.Id AS varchar)+'/revisions' FROM PostsWithDeleted a INNER JOIN Votes v ON v.PostId=a.Id WHERE (a.PostTypeId=2) --answer AND (v.VoteTypeId=9) --BountyEnd AND (a.DeletionDate IS NOT NULL) ORDER BY a.Id DESC