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, rc_title, 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.229.255.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('31.177.128.0') AND INET_ATON('31.223.127.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('46.106.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('95.70.128.0') AND INET_ATON('95.70.255.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('159.146.0.0') AND INET_ATON('159.146.127.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('185.22.100.0') AND INET_ATON('185.22.103.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('188.119.0.0') AND INET_ATON('188.119.63.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('193.192.96.0') AND INET_ATON('193.192.127.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('212.125.0.0') AND INET_ATON('212.125.31.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('212.154.0.0') AND INET_ATON('212.154.127.255') OR INET_ATON(actor_name) BETWEEN INET_ATON('217.31.224.0') AND INET_ATON('217.31.255.255') ) ORDER BY rc_timestamp DESC;
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...