Data Explorer (SEDE)

« first day (714 days earlier) ← previous day next day → last day (1404 days later) »

1:56 PM

Q: SEDE query to find out how many posts have been protected with spam on them

We are in the middle of an important discussion on our site about how we use the protection tool and we need some data for that discussion. Specifically, how many posts have ever been protected on the site after having had one or more answers deleted for being spam? It would also be helpful if th...

rene

2:10 PM

@Feeds answered

@Rubiksmoose maybe take it here before we raise a move comments to chat ... ;)

Rubiksmoose

Good idea.

Sorry there are a few questions that should be protected you are correct. But it should be single digits right now. The thing we are trying to look at is all the questions that have gotten unprotected recently

(someone went through and unprotected 99% of them in one day)

So for the current investigation it is rather important to not have the requirement for the question to be currently protected.

rene

ah, yes, the not Exsist clause is removing results that got an unprotect event

Maybe only remove the ones that got unprotected long ago?

Rubiksmoose

OK I think just removing that clause works to get us kinda there. That should get us all questions that were protected at some point and has a deleted answer yes?

rene

yes

Rubiksmoose

Excellent, that is very helpful. Thanks, as always, for the help.

rene

2:19 PM

@Rubiksmoose that is the second resultset here: data.stackexchange.com/rpg/query/1261622

The set seems rather large to hand check. You could maybe check if the deleted answer has a score <0 as that might indicate it picked up a spam flag.

Rubiksmoose

@rene OK just so I understand, is there a reason why result 1 is now returning more results than the original query?

We currently have 6 protected questions if that helps.

rene