Copy/paste of irc talk (I hope Simetrical and _mary_kate_ wouldn't mind :-)
<stemd> question (or feature suggustion/request):
<stemd> there are lot of pages which contain lot of bot action, and few (read one or two) human edits
<stemd> as recent changes has filter hidebots=1
<Simetrical> No bot flag in the revision table.
- Simetrical looks for bug
<_mary_kate_> join on user_groups
<Simetrical> _mary_kate_, different semantics. That would be retroactive.
<_mary_kate_> it achieves what the user wants
<stemd> Simetrical: (last time I studied db tables of wikipedia was some 2 years ago :-)
- Simetrical doesn't see the bug
<Simetrical> _mary_kate_, inconsistently with RC.
<_mary_kate_> inconsistency in mediawiki oh my whatever next
<stemd> select * from revisions where USER != bot :D
<stemd> I'll post bug, thanks