@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"
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.)
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.
No 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).