« first day (1473 days earlier)      last day (48 days later) » 

5:24 AM
@DMGregory Maybe adding AND ans.OwnerUserId=##userid## could be enough? data.stackexchange.com/gamedev/query/1625698/…
This is what I get for your userid: data.stackexchange.com/gamedev/query/1625698/…
 
 
7 hours later…
12:02 PM
@Martin Unfortunately that doesn't quite do it. That gives "questions on which I've posted a 0-score answer", not "questions whose max answer score is zero and one of them is mine"
ie. there are false positives in the returned set, like this question, which is not bumpable because someone else has a positively-scored answer: gamedev.stackexchange.com/questions/187127/…
So somehow I need an intersection of "questions whose max answer score is 0" and "questions I've answered with 0 score"
 
12:52 PM
@DMGregory My bad. I have tried to use the original query you linked as a CTE and I got this: data.stackexchange.com/gamedev/query/1625929/…
Now there are 92 results.
I would guess that adding one more join - if you need more data about questions - would still work. (After all, Game Development isn't such a big site, so we're not working with an extremely large database.)
 
That looks right at a cursory scan. I'll check it out in more detail - thank you for your help!
 
Probably there is a more efficient way - but this was the way I could use the original query you linked.
I guess it wouldn't be too difficult to modify it to some other condition on MAX(ans.Score). (For example, posts where maximum of answer scores is at most one.)
BTW shouldn't the original query have a.Score <= 0 rather than a.Score = 0? What exactly are conditions for bumping a post by the community user?
> Questions with at least 30 days of no activity, at least one answer scoring zero, and no answers scoring above that. Questions that are locked or closed will not be bumped. The Community User will only bump a maximum of one question per hour.
 
Negative-score answers don't bump - the community has judged them bad. But if the score is zero, maybe the community hasn't made a judgement yet, so the bot helpfully cycles the question to the top for more eyeballs.
 
From the FAQ post: Who is the Community user?
So we indeed need maximum to be equal to zero.
 
Yep. And I think the question itself needs a non-negative score too.
 
12:58 PM
Here are the questions which have most bumps by the community user: data.stackexchange.com/gamedev/query/1449649/…
36
A: Community ♦ seems to be bumping new questions more frequently than usual

Shog9No change to the configuration value so far as I can see - it's max 1 per hour (which is what you're observing). Note that the posts eligible for bumping are those scoring >= 0 that have gone at least 30 days with no activity, have at least one non-deleted answer scoring 0 and none scoring more...

> Note that the posts eligible for bumping are those scoring >= 0 that have gone at least 30 days with no activity, have at least one non-deleted answer scoring 0 and none scoring more than that, and no accepted answer (also, they can't be deleted or closed).
 
Thanks for that!
 

« first day (1473 days earlier)      last day (48 days later) »