Untitled query #58114

This query is marked as a draft This query has been published by Peter Bowman.
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")
    actor_name in ("107.181.190.102","109.173.215.0","109.231.54.21","109.231.56.34","109.241.245.159","109.243.134.224","109.243.98.85","131.111.229.130","148.81.172.122","150.254.222.169","157.25.193.204","158.75.1.33","159.205.13.63","173.208.87.138","173.208.87.146","176.127.113.121","176.221.124.180","176.98.112.35","177.22.143.0","178.159.140.208","178.19.98.55","178.212.155.6","178.219.123.108","178.235.75.74","178.36.18.56","178.36.240.63","178.43.125.13","178.43.7.101","178.94.76.88","178.94.92.163","185.13.186.249","185.24.27.34","185.28.251.98","185.6.53.11","185.93.181.118","185.93.181.87","188.146.0.200","188.146.8.88","188.254.164.32","193.192.170.22","194.149.88.126","194.44.179.112","194.44.179.119","194.44.179.120","194.44.179.121","195.150.188.12","195.150.188.14","195.154.116.56","195.154.116.60","195.154.71.139","195.187.108.4","195.245.213.8","195.249.127.231","195.47.201.80","2003:74:CC1D:B900:9D6F:9165:441F:179A","212.106.167.182","212.17.250.4","212.33.77.101","212.96.227.58","213.158.208.89","213.165.69.252","213.17.189.106","213.17.205.132","213.17.205.133","213.186.75.83","217.153.136.0","217.160.167.81","217.255.68.112","217.5.196.98","217.99.177.252","2A00:F41:9:42F9:D9AD:B225:8F25:92CC","2A01:110F:C71:9700:6039:2E39:346:EBA9","2A02:4A8:AC24:110:0:0:10:2","2A03:F480:1:20:0:0:0:2D","31.11.198.95","31.174.164.27","31.174.252.182","31.179.117.212","31.182.77.206","31.182.87.107","31.183.14.53","31.183.187.21","31.2.51.91","31.41.232.152","31.42.14.56","31.61.137.208","37.128.96.130","37.152.18.11","37.152.18.234","37.152.18.238","37.152.19.65","37.248.254.186","37.248.254.238","37.248.254.3","37.47.3.122","37.48.80.163","46.174.26.83","46.186.23.197","46.254.75.1","46.77.124.17","5.172.232.50","5.172.235.33","5.172.236.78","5.172.238.249","5.172.239.130","5.172.247.195","5.172.247.208","5.172.247.213","5.172.247.218","5.172.247.220","5.172.247.222","5.172.247.223","5.172.247.224","5.172.247.228","5.172.247.230","5.172.247.239","5.172.247.240","5.172.247.248","5.172.247.250","5.172.247.252","5.172.247.254","5.172.252.232","5.187.21.58","52.9.73.129","54.201.125.134","62.141.236.225","62.168.13.98","62.93.51.3","69.163.34.169","77.246.174.117","77.45.72.171","77.65.81.40","78.10.208.162","78.11.50.234","78.154.85.128","78.157.162.24","78.9.71.18","79.173.10.102","79.185.142.127","79.185.245.64","79.191.114.128","79.255.104.24","80.178.203.191","80.222.151.206","80.50.149.134","80.87.33.20","80.87.33.21","81.190.169.157","81.210.106.198","81.210.78.10","81.219.66.202","81.30.243.195","82.117.240.127","82.160.207.6","82.220.37.210","82.220.39.56","82.220.39.57","82.246.159.158","82.42.65.58","83.1.81.174","83.11.154.184","83.11.156.105","83.11.185.20","83.142.182.79","83.143.240.13","83.143.240.14","83.143.240.4","83.21.235.178","83.22.108.49","83.22.253.238","83.22.31.110","83.22.6.216","83.22.69.167","83.24.149.2","83.26.228.36","83.27.11.179","83.27.188.65","83.27.210.214","83.28.110.29","83.28.72.211","83.30.164.183","83.31.163.165","83.31.38.88","83.5.161.114","83.6.191.3","83.6.207.121","84.10.111.186","84.40.143.52","85.9.20.152","86.111.207.157","86.136.148.45","87.155.91.66","87.205.29.24","87.207.85.243","88.149.251.121","88.156.130.126","88.156.130.144","88.156.130.90","88.156.131.120","88.156.131.50","88.156.134.108","88.156.134.145","88.156.134.87","88.156.134.90","88.156.137.80","88.156.140.93","88.156.226.117","88.156.226.233","88.156.226.236","88.156.226.242","88.156.226.245","88.156.226.52","88.156.227.106","88.156.227.140","88.156.227.142","88.156.227.239","88.199.82.61","88.220.144.139","88.240.159.87","89.161.52.90","89.174.231.206","89.229.244.5","89.239.119.131","89.65.3.175","89.66.206.117","89.66.66.43","89.69.163.245","89.69.34.10","89.71.133.151","89.72.244.110","89.72.245.35","89.72.88.51","89.79.208.222","90.182.5.123","91.188.117.98","91.216.213.132","91.220.54.13","91.226.50.43","91.236.133.203","91.245.83.231","92.112.208.114","92.232.55.106","93.105.176.255","93.105.179.23","93.105.179.62","93.105.182.211","93.105.236.223","93.105.42.9","93.174.28.30","93.78.241.140","93.78.241.6","94.21.192.226","94.254.147.17","94.254.160.201","94.254.160.246","94.254.160.70","94.254.162.199","94.254.163.181","94.254.224.100","94.254.242.250","95.108.29.104","95.141.20.200","95.141.27.41","95.141.31.23","95.141.31.24","95.160.216.108","95.20.41.246","95.213.182.5","95.239.235.210","95.49.17.135","95.49.26.97","95.49.5.142","99.90.196.227")
;
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.
SQL

Checking query status...
