daily pastebin goal
46%
SHARE
TWEET

O2 adresy - blokovane

Urbanecm Jul 8th, 2017 469 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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;
  2. +----------+----------------+
  3. | count(*) | rev_user_text  |
  4. +----------+----------------+
  5. |        1 | 37.188.131.130 |
  6. |       12 | 37.188.135.245 |
  7. |        8 | 37.188.148.27  |
  8. |       20 | 37.188.152.207 |
  9. |        3 | 37.188.153.26  |
  10. |        4 | 37.188.177.179 |
  11. |        1 | 37.188.187.211 |
  12. |        2 | 37.188.228.237 |
  13. |       12 | 37.188.230.223 |
  14. |        1 | 37.188.238.108 |
  15. +----------+----------------+
  16. 10 rows in set (0.92 sec)
  17.  
  18. MariaDB [cswiki_p]>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top