7:51 AM
@SonictheAnonymousWizHog This query was what I was able to create: data.stackexchange.com/math/revision/1077404/1331059/…
Even if we ignore the fact that there might be some deleted posts which might change the counts and that the query considers posts with multiple additions and removals only once, there is also the problem that the query is rather slow.
(SELECT COUNT(*) FROM datesaddedremoved_cte d2 WHERE d2.FirstAddedDate<=d1.LastRemovedDate) AS CountAddedBefore,
8:14 AM
6 hours later…
2:19 PM
When I wanted a large tag on Mathematics that was removed I should have tried (algebra) and not (abstract-algebra). (The latter still exists.)
It seems that there were some 1500 posts with the algebra tag (which are not deleted by now): data.stackexchange.com/math/revision/1077119/1330654/…
Perhaps it would be good to know whether some of the queries above helped for the tags that Sonic the Anonymous WizHog was interested in.
I have tried to do the same thing as in your query with two tables: data.stackexchange.com/math/revision/1077518/1331189/…
The results of the query are consistent with my recollection that the tag was first removed in February 2012.
2:50 PM
7 hours later…
9:42 PM
@rene I get a timeout when I try to run it for the specific tag I'm trying to have blacklisted: the [google] tag on Super User.
« first day (354 days earlier) ← previous day next day → last day (1764 days later) »