Q&A for scientists using computers to solve scientific problems
SELECT DISTINCT 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) AND (p.tags LIKE '%<##tagName?tag-removed##>%') ORDER BY p.Id DESC