O2 adresy kveten - neblokovane

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]>