Q&A about the site for enthusiasts and scholars of mythology and folklore
SELECT DISTINCT TOP(##num?500##) p.Id AS [Post Link], url = 'site://q/' + CAST(p.Id AS varchar), p.CreationDate, p.DeletionDate, DATEDIFF(minute, p.CreationDate, p.DeletionDate) AS Minutes, p.Score, CASE p.PostTypeId WHEN 1 THEN 'Question' WHEN 2 THEN 'Answer' END, p.Tags, p.ViewCount FROM PostsWithDeleted p INNER JOIN Votes v ON v.PostId=p.Id WHERE v.VoteTypeId=##votetype?12## AND (p.DeletionDate IS NOT NULL) ORDER BY p.Id DESC