daily pastebin goal
19%
SHARE
TWEET

O2 adresy kveten - neblokovane

Urbanecm Jul 8th, 2017 457 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 not 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. |        2 | 37.188.128.120 |
  6. |        1 | 37.188.128.31  |
  7. |        2 | 37.188.129.146 |
  8. |        1 | 37.188.131.135 |
  9. |        1 | 37.188.131.249 |
  10. |        1 | 37.188.132.231 |
  11. |        2 | 37.188.132.50  |
  12. |        1 | 37.188.134.249 |
  13. |        1 | 37.188.134.6   |
  14. |        1 | 37.188.134.7   |
  15. |        1 | 37.188.135.116 |
  16. |        1 | 37.188.135.202 |
  17. |        1 | 37.188.135.49  |
  18. |        2 | 37.188.136.210 |
  19. |        1 | 37.188.139.101 |
  20. |        4 | 37.188.140.166 |
  21. |        2 | 37.188.140.194 |
  22. |        1 | 37.188.140.27  |
  23. |        1 | 37.188.141.162 |
  24. |        1 | 37.188.142.0   |
  25. |        1 | 37.188.142.149 |
  26. |        1 | 37.188.142.28  |
  27. |        1 | 37.188.143.148 |
  28. |        1 | 37.188.143.213 |
  29. |        2 | 37.188.143.94  |
  30. |        1 | 37.188.144.189 |
  31. |        1 | 37.188.145.255 |
  32. |        1 | 37.188.147.107 |
  33. |        1 | 37.188.147.160 |
  34. |        9 | 37.188.149.1   |
  35. |        1 | 37.188.149.174 |
  36. |        1 | 37.188.149.57  |
  37. |        1 | 37.188.150.158 |
  38. |        3 | 37.188.151.192 |
  39. |        2 | 37.188.151.247 |
  40. |        1 | 37.188.154.102 |
  41. |        1 | 37.188.158.129 |
  42. |        1 | 37.188.159.121 |
  43. |        1 | 37.188.176.234 |
  44. |        3 | 37.188.177.224 |
  45. |        1 | 37.188.178.183 |
  46. |        1 | 37.188.179.253 |
  47. |        3 | 37.188.180.243 |
  48. |        2 | 37.188.181.252 |
  49. |        1 | 37.188.182.159 |
  50. |        1 | 37.188.183.237 |
  51. |        1 | 37.188.184.23  |
  52. |        1 | 37.188.185.222 |
  53. |        1 | 37.188.186.98  |
  54. |        1 | 37.188.187.223 |
  55. |        4 | 37.188.188.1   |
  56. |        1 | 37.188.188.185 |
  57. |        1 | 37.188.189.114 |
  58. |        1 | 37.188.189.151 |
  59. |        1 | 37.188.190.187 |
  60. |        1 | 37.188.190.217 |
  61. |        1 | 37.188.190.70  |
  62. |        1 | 37.188.224.203 |
  63. |        1 | 37.188.224.63  |
  64. |        1 | 37.188.225.213 |
  65. |        1 | 37.188.225.250 |
  66. |        1 | 37.188.226.233 |
  67. |        1 | 37.188.226.249 |
  68. |        1 | 37.188.228.218 |
  69. |        1 | 37.188.229.177 |
  70. |        2 | 37.188.231.87  |
  71. |        3 | 37.188.233.192 |
  72. |        1 | 37.188.235.214 |
  73. |        2 | 37.188.235.215 |
  74. |        2 | 37.188.235.41  |
  75. |        1 | 37.188.236.10  |
  76. |        2 | 37.188.239.135 |
  77. +----------+----------------+
  78. 72 rows in set (1.08 sec)
  79.  
  80. 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