Q&A for developers and end users of the Sitecore CMS and multichannel marketing software
SELECT Votes.*, 'site://q/' + CAST(COALESCE(PostsWithDeleted.ParentId, Votes.PostId) AS VARCHAR(MAX)) + '|Link' AS Link, 'site://posts/' + CAST(Votes.PostId AS VARCHAR(MAX)) + '/revisions|Revisions' AS Revisions FROM Votes, PostsWithDeleted WHERE Votes.PostId = PostsWithDeleted.Id AND Votes.VoteTypeId = 4 ORDER BY Votes.Id DESC;