daily pastebin goal
19%
SHARE
TWEET

O2 adresy - neblokovane

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 "201707%" or rev_timestamp like "201706%") 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.243 |
  6. |        1 | 37.188.128.76  |
  7. |        1 | 37.188.130.226 |
  8. |        1 | 37.188.130.24  |
  9. |        2 | 37.188.131.253 |
  10. |        1 | 37.188.132.116 |
  11. |        5 | 37.188.134.95  |
  12. |        3 | 37.188.136.209 |
  13. |        1 | 37.188.136.65  |
  14. |        1 | 37.188.140.239 |
  15. |        3 | 37.188.140.9   |
  16. |        1 | 37.188.141.103 |
  17. |        1 | 37.188.142.83  |
  18. |        2 | 37.188.143.214 |
  19. |        1 | 37.188.145.134 |
  20. |        1 | 37.188.146.118 |
  21. |        2 | 37.188.146.206 |
  22. |       16 | 37.188.148.210 |
  23. |        1 | 37.188.149.61  |
  24. |        8 | 37.188.149.72  |
  25. |        3 | 37.188.151.98  |
  26. |        1 | 37.188.154.200 |
  27. |        6 | 37.188.154.52  |
  28. |        4 | 37.188.155.104 |
  29. |        1 | 37.188.155.136 |
  30. |        2 | 37.188.157.185 |
  31. |        5 | 37.188.159.0   |
  32. |        2 | 37.188.159.24  |
  33. |        1 | 37.188.159.58  |
  34. |        1 | 37.188.176.197 |
  35. |        1 | 37.188.177.251 |
  36. |        2 | 37.188.177.77  |
  37. |        1 | 37.188.179.147 |
  38. |        1 | 37.188.181.74  |
  39. |        1 | 37.188.182.211 |
  40. |        1 | 37.188.183.157 |
  41. |        1 | 37.188.184.6   |
  42. |        1 | 37.188.187.195 |
  43. |        1 | 37.188.187.95  |
  44. |        1 | 37.188.189.134 |
  45. |        2 | 37.188.189.57  |
  46. |        1 | 37.188.190.83  |
  47. |        1 | 37.188.191.2   |
  48. |        1 | 37.188.191.60  |
  49. |        1 | 37.188.195.143 |
  50. |        1 | 37.188.226.33  |
  51. |        1 | 37.188.227.126 |
  52. |        1 | 37.188.227.197 |
  53. |        2 | 37.188.227.35  |
  54. |        1 | 37.188.228.184 |
  55. |        4 | 37.188.228.76  |
  56. |        1 | 37.188.228.84  |
  57. |        1 | 37.188.229.116 |
  58. |        1 | 37.188.230.109 |
  59. |        1 | 37.188.230.164 |
  60. |        2 | 37.188.230.19  |
  61. |        2 | 37.188.231.24  |
  62. |        1 | 37.188.232.234 |
  63. |        1 | 37.188.234.157 |
  64. |        1 | 37.188.236.106 |
  65. |        1 | 37.188.236.205 |
  66. |        1 | 37.188.236.46  |
  67. |        1 | 37.188.238.82  |
  68. |        2 | 37.188.239.85  |
  69. +----------+----------------+
  70. 64 rows in set (0.96 sec)
  71.  
  72. 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