Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [cswiki_p]> select count(*), rev_user_text from revision where rev_user=0 and rev_user_text like "37.188.%" and rev_timestamp like "201705%" and rev_user_text not in (select log_title from logging where log_action="block" and log_type="block") group by rev_user_text;
- +----------+----------------+
- | count(*) | rev_user_text |
- +----------+----------------+
- | 2 | 37.188.128.120 |
- | 1 | 37.188.128.31 |
- | 2 | 37.188.129.146 |
- | 1 | 37.188.131.135 |
- | 1 | 37.188.131.249 |
- | 1 | 37.188.132.231 |
- | 2 | 37.188.132.50 |
- | 1 | 37.188.134.249 |
- | 1 | 37.188.134.6 |
- | 1 | 37.188.134.7 |
- | 1 | 37.188.135.116 |
- | 1 | 37.188.135.202 |
- | 1 | 37.188.135.49 |
- | 2 | 37.188.136.210 |
- | 1 | 37.188.139.101 |
- | 4 | 37.188.140.166 |
- | 2 | 37.188.140.194 |
- | 1 | 37.188.140.27 |
- | 1 | 37.188.141.162 |
- | 1 | 37.188.142.0 |
- | 1 | 37.188.142.149 |
- | 1 | 37.188.142.28 |
- | 1 | 37.188.143.148 |
- | 1 | 37.188.143.213 |
- | 2 | 37.188.143.94 |
- | 1 | 37.188.144.189 |
- | 1 | 37.188.145.255 |
- | 1 | 37.188.147.107 |
- | 1 | 37.188.147.160 |
- | 9 | 37.188.149.1 |
- | 1 | 37.188.149.174 |
- | 1 | 37.188.149.57 |
- | 1 | 37.188.150.158 |
- | 3 | 37.188.151.192 |
- | 2 | 37.188.151.247 |
- | 1 | 37.188.154.102 |
- | 1 | 37.188.158.129 |
- | 1 | 37.188.159.121 |
- | 1 | 37.188.176.234 |
- | 3 | 37.188.177.224 |
- | 1 | 37.188.178.183 |
- | 1 | 37.188.179.253 |
- | 3 | 37.188.180.243 |
- | 2 | 37.188.181.252 |
- | 1 | 37.188.182.159 |
- | 1 | 37.188.183.237 |
- | 1 | 37.188.184.23 |
- | 1 | 37.188.185.222 |
- | 1 | 37.188.186.98 |
- | 1 | 37.188.187.223 |
- | 4 | 37.188.188.1 |
- | 1 | 37.188.188.185 |
- | 1 | 37.188.189.114 |
- | 1 | 37.188.189.151 |
- | 1 | 37.188.190.187 |
- | 1 | 37.188.190.217 |
- | 1 | 37.188.190.70 |
- | 1 | 37.188.224.203 |
- | 1 | 37.188.224.63 |
- | 1 | 37.188.225.213 |
- | 1 | 37.188.225.250 |
- | 1 | 37.188.226.233 |
- | 1 | 37.188.226.249 |
- | 1 | 37.188.228.218 |
- | 1 | 37.188.229.177 |
- | 2 | 37.188.231.87 |
- | 3 | 37.188.233.192 |
- | 1 | 37.188.235.214 |
- | 2 | 37.188.235.215 |
- | 2 | 37.188.235.41 |
- | 1 | 37.188.236.10 |
- | 2 | 37.188.239.135 |
- +----------+----------------+
- 72 rows in set (1.08 sec)
- MariaDB [cswiki_p]>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement