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 "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]>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement