O2 adresy - blokovane

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 in (select log_title from logging where log_action="block" and log_type="block") group by rev_user_text;
+----------+----------------+
| count(*) | rev_user_text  |
+----------+----------------+
|        1 | 37.188.131.130 |
|       12 | 37.188.135.245 |
|        8 | 37.188.148.27  |
|       20 | 37.188.152.207 |
|        3 | 37.188.153.26  |
|        4 | 37.188.177.179 |
|        1 | 37.188.187.211 |
|        2 | 37.188.228.237 |
|       12 | 37.188.230.223 |
|        1 | 37.188.238.108 |
+----------+----------------+
10 rows in set (0.92 sec)

MariaDB [cswiki_p]>