daily pastebin goal
19%
SHARE
TWEET

O2 adresy kveten - blokovane

Urbanecm Jul 8th, 2017 459 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 "201705%" 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. |       11 | 37.188.131.171 |
  6. |        2 | 37.188.131.236 |
  7. |        2 | 37.188.132.106 |
  8. |        7 | 37.188.132.9   |
  9. |        3 | 37.188.133.213 |
  10. |        3 | 37.188.136.129 |
  11. |        3 | 37.188.144.211 |
  12. |        1 | 37.188.144.58  |
  13. |        1 | 37.188.144.89  |
  14. |        4 | 37.188.145.224 |
  15. |        2 | 37.188.145.47  |
  16. |        1 | 37.188.146.89  |
  17. |        2 | 37.188.147.207 |
  18. |        1 | 37.188.148.218 |
  19. |        1 | 37.188.148.27  |
  20. |       13 | 37.188.150.219 |
  21. |        1 | 37.188.151.102 |
  22. |        4 | 37.188.151.147 |
  23. |        2 | 37.188.154.243 |
  24. |        1 | 37.188.159.65  |
  25. |        1 | 37.188.176.245 |
  26. |        1 | 37.188.177.124 |
  27. |        1 | 37.188.177.144 |
  28. |        1 | 37.188.177.147 |
  29. |        1 | 37.188.181.1   |
  30. |        1 | 37.188.184.159 |
  31. |       14 | 37.188.186.211 |
  32. |        3 | 37.188.188.131 |
  33. |        1 | 37.188.188.145 |
  34. |        6 | 37.188.188.243 |
  35. |        2 | 37.188.189.190 |
  36. |        5 | 37.188.191.191 |
  37. |        2 | 37.188.191.230 |
  38. |        1 | 37.188.224.146 |
  39. |        3 | 37.188.226.208 |
  40. |        2 | 37.188.232.214 |
  41. |        1 | 37.188.232.219 |
  42. |        1 | 37.188.234.102 |
  43. |        1 | 37.188.234.123 |
  44. |        1 | 37.188.235.39  |
  45. |        6 | 37.188.238.138 |
  46. |        3 | 37.188.238.40  |
  47. +----------+----------------+
  48. 42 rows in set (0.98 sec)
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