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
XXBlackburnXx
.
Toggle Highlighting
SQL
SELECT rc_timestamp, actor_name, rc_namespace, comment_text FROM recentchanges JOIN actor ON actor_id = rc_actor LEFT JOIN `comment` ON rc_comment_id = comment_id WHERE actor_user IS NULL AND ( INET_ATON(actor_name) BETWEEN INET_ATON('5.226.192.0') AND INET_ATON('5.226.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('5.229.0.0') AND INET_ATON('5.229.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('31.177.128.0') AND INET_ATON('31.177.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('46.106.0.0') AND INET_ATON('46.106.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('46.154.0.0') AND INET_ATON('46.155.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('46.221.0.0') AND INET_ATON('46.221.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('81.6.64.0') AND INET_ATON('81.6.127.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('149.0.0.0') AND INET_ATON('149.0.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('149.140.0.0') AND INET_ATON('149.140.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('176.54.0.0') AND INET_ATON('176.55.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('176.216.0.0') AND INET_ATON('176.219.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('185.11.12.0') AND INET_ATON('185.11.15.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('188.38.0.0') AND INET_ATON('188.38.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('212.65.128.0') AND INET_ATON('212.65.159.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('217.31.224.0') AND INET_ATON('217.31.239.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('217.31.240.0') AND INET_ATON('217.31.255.255') );
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...