Q&A for professional and enthusiast programmers
SELECT url = 'site://q/' + CAST(Id AS varchar), DeletionDate, ClosedDate, Tags AS [Tags] FROM PostsWithDeleted WHERE DeletionDate is not null AND PostTypeId = 1 AND CHARINDEX(##TagName:string##, Tags) > 0 ORDER BY DeletionDate DESC