Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT p.Id, v.Id, p.CreationDate, p.DeletionDate, url = 'site://q/' + CAST(p.Id AS varchar), 'site://revisions/'+cast(p.Id as nvarchar)+'/1' AS [Revisions Link] FROM PostsWithDeleted p INNER JOIN Votes v ON v.PostId = p.Id WHERE v.VoteTypeId IN (##types?4,12##) ---AND p.DeletionDate IS NOT NULL ORDER BY p.Id DESC