O2 adresy - 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 "201707%" or rev_timestamp like "201706%") 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.243 |
|        1 | 37.188.128.76  |
|        1 | 37.188.130.226 |
|        1 | 37.188.130.24  |
|        2 | 37.188.131.253 |
|        1 | 37.188.132.116 |
|        5 | 37.188.134.95  |
|        3 | 37.188.136.209 |
|        1 | 37.188.136.65  |
|        1 | 37.188.140.239 |
|        3 | 37.188.140.9   |
|        1 | 37.188.141.103 |
|        1 | 37.188.142.83  |
|        2 | 37.188.143.214 |
|        1 | 37.188.145.134 |
|        1 | 37.188.146.118 |
|        2 | 37.188.146.206 |
|       16 | 37.188.148.210 |
|        1 | 37.188.149.61  |
|        8 | 37.188.149.72  |
|        3 | 37.188.151.98  |
|        1 | 37.188.154.200 |
|        6 | 37.188.154.52  |
|        4 | 37.188.155.104 |
|        1 | 37.188.155.136 |
|        2 | 37.188.157.185 |
|        5 | 37.188.159.0   |
|        2 | 37.188.159.24  |
|        1 | 37.188.159.58  |
|        1 | 37.188.176.197 |
|        1 | 37.188.177.251 |
|        2 | 37.188.177.77  |
|        1 | 37.188.179.147 |
|        1 | 37.188.181.74  |
|        1 | 37.188.182.211 |
|        1 | 37.188.183.157 |
|        1 | 37.188.184.6   |
|        1 | 37.188.187.195 |
|        1 | 37.188.187.95  |
|        1 | 37.188.189.134 |
|        2 | 37.188.189.57  |
|        1 | 37.188.190.83  |
|        1 | 37.188.191.2   |
|        1 | 37.188.191.60  |
|        1 | 37.188.195.143 |
|        1 | 37.188.226.33  |
|        1 | 37.188.227.126 |
|        1 | 37.188.227.197 |
|        2 | 37.188.227.35  |
|        1 | 37.188.228.184 |
|        4 | 37.188.228.76  |
|        1 | 37.188.228.84  |
|        1 | 37.188.229.116 |
|        1 | 37.188.230.109 |
|        1 | 37.188.230.164 |
|        2 | 37.188.230.19  |
|        2 | 37.188.231.24  |
|        1 | 37.188.232.234 |
|        1 | 37.188.234.157 |
|        1 | 37.188.236.106 |
|        1 | 37.188.236.205 |
|        1 | 37.188.236.46  |
|        1 | 37.188.238.82  |
|        2 | 37.188.239.85  |
+----------+----------------+
64 rows in set (0.96 sec)

MariaDB [cswiki_p]>