mysql> /* SLOW_OK */ -> select rc_user_text -> from recentchanges -> where rc_comment rlike "Robot: (Removing|Adding|Modifying)" -> group by rc_user; +----------------------+ | rc_user_text | +----------------------+ | Robbot | | Chobot | | RussBot | | MalafayaBot | | Escarbot | | JAnDbot | | Soulbot | | MalarzBOT | | Huzzlet the bot | | Idioma-bot | | VolkovBot | | TXiKiBoT | | Synthebot | | Gerakibot | | DragonBot | | Jotterbot | | HarrivBOT | | Kwjbot | | SilvonenBot | | Addbot | | LaaknorBot | | CarsracBot | | Zorrobot | | HerculeBot | | Ptbotgourou | | Naudefjbot | | KamikazeBot | | Rubinbot | | JackieBot | | Obersachsebot | | Xqbot | | DSisyphBot | | GrouchoBot | | RibotBOT | | SassoBot | | GhalyBot | | MerlLinkBot | | MGA73bot | | HRoestBot | | Ver-bot | | MastiBot | | RobotQuistnix | | Alch Bot | | TjBot | | Alph Bot | | DEagleBot | | EmausBot | | EleferenBot | | TuHan-Bot | | ZĂ©roBot | | Mentibot | | Bean49Bot | | CocuBot | | Kasirbot | | Rezabot | | BendelacBOT | | Justincheng12345-bot | | DarafshBot | | MahdiBot | | YFdyh-bot | | JYBot | | Dexbot | | SantoshBot | | Makecat-bot | | SteenthIWbot | | Natig98 | | Razibot | | Fajrbot | | ArshavaBot | | SAMI.Bot | +----------------------+ 71 rows in set (1 min 49.43 sec)