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
Peter Bowman
.
Toggle Highlighting
SQL
set @start = 20160101000000; set @end = 20160801000000; select rev_id, actor_name, rev_deleted, comment_text from revision inner join actor on actor_id = rev_actor inner join comment on comment_id = rev_comment_id where rev_timestamp > @start and rev_timestamp < @end and comment_text != "" and actor_name in ("107.181.190.102","148.81.172.122","158.75.1.33","173.208.87.138","177.22.143.0","178.235.75.74","185.28.251.98","185.93.181.118","185.93.181.87","188.146.0.200","194.149.88.126","194.44.179.119","194.44.179.121","195.150.188.12","195.150.188.14","195.154.116.56","195.154.71.139","195.249.127.231","195.47.201.80","213.17.205.132","213.17.205.133","217.153.136.0","217.5.196.98","37.48.80.163","5.172.247.213","5.172.247.228","5.172.247.254","5.187.21.58","54.201.125.134","62.168.13.98","69.163.34.169","77.246.174.117","78.157.162.24","80.222.151.206","80.87.33.20","80.87.33.21","81.210.78.10","81.30.243.195","88.156.134.145","88.156.137.80","88.156.226.245","88.156.227.106","88.156.227.140","88.156.227.239","89.65.3.175","89.66.66.43","89.69.34.10","93.105.179.62","93.78.241.140","93.78.241.6","94.254.162.199","95.141.20.200","95.141.27.41","95.141.31.24","95.213.182.5") ;
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...