Deleted questions between two dates with the given two tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT Id,
  url = 'site://q/' + CAST(Id AS varchar),
  CreationDate, DeletionDate, Score, Tags
FROM PostsWithDeleted
WHERE (PostTypeId = 1) AND 
(Tags LIKE '%##Tagname1?post-ban##%') AND (Tags LIKE '%##Tagname2?per-site-meta##%')  AND
(Deletiondate >= '##Date1?2018-01-01##') AND
(Deletiondate <= '##Date2?2022-01-01##') 
ORDER BY DeletionDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results