1

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited oct 16 19

created oct 16 19 peterh - PLEASE DELETE THIS ACCOUNT