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