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 in (select log_title from logging where log_action="block" and log_type="block") group by rev_user_text;
- +----------+----------------+
- | count(*) | rev_user_text |
- +----------+----------------+
- | 11 | 37.188.131.171 |
- | 2 | 37.188.131.236 |
- | 2 | 37.188.132.106 |
- | 7 | 37.188.132.9 |
- | 3 | 37.188.133.213 |
- | 3 | 37.188.136.129 |
- | 3 | 37.188.144.211 |
- | 1 | 37.188.144.58 |
- | 1 | 37.188.144.89 |
- | 4 | 37.188.145.224 |
- | 2 | 37.188.145.47 |
- | 1 | 37.188.146.89 |
- | 2 | 37.188.147.207 |
- | 1 | 37.188.148.218 |
- | 1 | 37.188.148.27 |
- | 13 | 37.188.150.219 |
- | 1 | 37.188.151.102 |
- | 4 | 37.188.151.147 |
- | 2 | 37.188.154.243 |
- | 1 | 37.188.159.65 |
- | 1 | 37.188.176.245 |
- | 1 | 37.188.177.124 |
- | 1 | 37.188.177.144 |
- | 1 | 37.188.177.147 |
- | 1 | 37.188.181.1 |
- | 1 | 37.188.184.159 |
- | 14 | 37.188.186.211 |
- | 3 | 37.188.188.131 |
- | 1 | 37.188.188.145 |
- | 6 | 37.188.188.243 |
- | 2 | 37.188.189.190 |
- | 5 | 37.188.191.191 |
- | 2 | 37.188.191.230 |
- | 1 | 37.188.224.146 |
- | 3 | 37.188.226.208 |
- | 2 | 37.188.232.214 |
- | 1 | 37.188.232.219 |
- | 1 | 37.188.234.102 |
- | 1 | 37.188.234.123 |
- | 1 | 37.188.235.39 |
- | 6 | 37.188.238.138 |
- | 3 | 37.188.238.40 |
- +----------+----------------+
- 42 rows in set (0.98 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement