Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Zache
.
Toggle Highlighting
SQL
use fiwiki_p; SELECT actor_id FROM actor_revision LEFT JOIN (SELECT ufg_user FROM user_former_groups WHERE ufg_group="bot") ON actor_user=ufg_user LEFT JOIN (SELECT ug_user FROM user_groups WHERE ug_group="bot") ON actor_user=ug_user WHERE actor_name REGEXP "[bB][oO0][tT]" OR actor_name REGEXP "[aA][wW][bB]" OR ug_group = "bot" OR ufg_group = "bot" GROUP BY ug_user;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...