daily pastebin goal
69%
SHARE
TWEET

Untitled

a guest Dec 13th, 2013 5 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT SUBSTR(rev_timestamp, 1, 8) dia, SUM(u.c > 1000) mais_de1000, SUM(rev_user != 0) registrados, SUM(rev_user = 0) IPs FROM revision INNER JOIN page ON rev_page = page_id LEFT JOIN (SELECT rev_user ru, COUNT(*) c FROM revision JOIN page ON rev_page = page_id WHERE page_namespace IN (0,102) AND rev_user != 0 GROUP BY ru HAVING c > 1000) u ON ru = rev_user WHERE page_namespace IN (0, 102) AND (rev_timestamp LIKE '2013%' OR rev_timestamp LIKE '2012%') AND rev_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') GROUP BY SUBSTR(rev_timestamp, 1, 4),  WEEK(rev_timestamp);
  2. +----------+-------------+-------------+-------+
  3. | dia      | mais_de1000 | registrados | IPs   |
  4. +----------+-------------+-------------+-------+
  5. | 20120103 |       19038 |       25596 | 13907 |
  6. | 20120111 |       19966 |       27586 | 15133 |
  7. | 20120119 |       18539 |       25768 | 14929 |
  8. | 20120125 |       21729 |       28744 | 15468 |
  9. | 20120203 |       23313 |       30608 | 15181 |
  10. | 20120211 |       22603 |       29112 | 14582 |
  11. | 20120217 |       20580 |       27861 | 15108 |
  12. | 20120222 |       21217 |       28958 | 15581 |
  13. | 20120301 |       18044 |       24450 | 14853 |
  14. | 20120309 |       17170 |       23383 | 14685 |
  15. | 20120313 |       20997 |       26274 | 15505 |
  16. | 20120322 |       18254 |       23820 | 14832 |
  17. | 20120331 |       17113 |       22960 | 15427 |
  18. | 20120407 |       18774 |       25707 | 15132 |
  19. | 20120414 |       17906 |       24985 | 16195 |
  20. | 20120416 |       20139 |       26260 | 15511 |
  21. | 20120426 |       19599 |       25655 | 14648 |
  22. | 20120504 |       22491 |       28622 | 14377 |
  23. | 20120506 |       20481 |       26690 | 14765 |
  24. | 20120518 |       23377 |       29461 | 14974 |
  25. | 20120525 |       20329 |       26576 | 14630 |
  26. | 20120527 |       19072 |       25027 | 15222 |
  27. | 20120608 |       18830 |       24679 | 13563 |
  28. | 20120611 |       19274 |       26287 | 14738 |
  29. | 20120617 |       21204 |       27510 | 14731 |
  30. | 20120626 |       19914 |       26511 | 13820 |
  31. | 20120701 |       21953 |       28447 | 14442 |
  32. | 20120713 |       21761 |       28589 | 13533 |
  33. | 20120715 |       21266 |       28717 | 12746 |
  34. | 20120725 |       20755 |       27703 | 13876 |
  35. | 20120729 |       22841 |       29320 | 14229 |
  36. | 20120808 |       20316 |       26088 | 13041 |
  37. | 20120812 |       20396 |       26663 | 13628 |
  38. | 20120819 |       22574 |       28722 | 14006 |
  39. | 20120829 |       20986 |       27045 | 13474 |
  40. | 20120902 |       19681 |       25775 | 12977 |
  41. | 20120913 |       20680 |       26623 | 12969 |
  42. | 20120922 |       16971 |       22722 | 13846 |
  43. | 20120928 |       16072 |       21545 | 13512 |
  44. | 20121002 |       17407 |       22509 | 13449 |
  45. | 20121012 |       16443 |       21659 | 13339 |
  46. | 20121016 |       17617 |       23200 | 13860 |
  47. | 20121024 |       16180 |       21361 | 13986 |
  48. | 20121028 |       16161 |       21381 | 14242 |
  49. | 20121108 |       15490 |       20921 | 14133 |
  50. | 20121117 |       17338 |       23214 | 14229 |
  51. | 20121120 |       17544 |       23506 | 14898 |
  52. | 20121126 |       18306 |       24558 | 14409 |
  53. | 20121203 |       18412 |       24459 | 13094 |
  54. | 20121210 |       18616 |       25494 | 13561 |
  55. | 20121219 |       19657 |       26288 | 12180 |
  56. | 20121229 |       21301 |       27039 | 10314 |
  57. | 20121231 |        7006 |        8818 |  2695 |
  58. | 20130102 |       15965 |       21695 |  9674 |
  59. | 20130108 |       23941 |       31381 | 13912 |
  60. | 20130114 |       25187 |       32340 | 12830 |
  61. | 20130124 |       26066 |       33104 | 13438 |
  62. | 20130129 |       22207 |       29767 | 12491 |
  63. | 20130207 |       20275 |       27202 | 13082 |
  64. | 20130211 |       23204 |       30403 | 14068 |
  65. | 20130222 |       19031 |       24805 | 12915 |
  66. | 20130224 |       21121 |       26811 | 13649 |
  67. | 20130308 |       20485 |       26417 | 14122 |
  68. | 20130312 |       19401 |       25360 | 14086 |
  69. | 20130323 |       20731 |       26685 | 14621 |
  70. | 20130328 |       21175 |       27190 | 13963 |
  71. | 20130405 |       22473 |       28470 | 14293 |
  72. | 20130411 |       19776 |       26105 | 18053 |
  73. | 20130419 |       20066 |       26714 | 19756 |
  74. | 20130427 |       19495 |       26246 | 19802 |
  75. | 20130503 |       20441 |       27454 | 19482 |
  76. | 20130507 |       20462 |       27365 | 20599 |
  77. | 20130518 |       23253 |       29907 | 24287 |
  78. | 20130523 |       24916 |       31609 | 25333 |
  79. | 20130601 |       22801 |       29763 | 23511 |
  80. | 20130604 |       23803 |       30945 | 24633 |
  81. | 20130615 |       19644 |       26117 | 23847 |
  82. | 20130618 |       18419 |       24146 | 21986 |
  83. | 20130627 |       22266 |       28848 | 20531 |
  84. | 20130703 |       20812 |       25687 | 18892 |
  85. | 20130707 |       20953 |       27177 | 19638 |
  86. | 20130720 |       19872 |       26311 | 18946 |
  87. | 20130723 |       18798 |       25686 | 18779 |
  88. | 20130803 |       16517 |       22588 | 15766 |
  89. | 20130805 |       17804 |       23704 | 13647 |
  90. | 20130816 |       17289 |       22116 | 13501 |
  91. | 20130824 |       16184 |       21457 | 14478 |
  92. | 20130825 |       15569 |       21249 | 14319 |
  93. | 20130902 |       17325 |       22657 | 13889 |
  94. | 20130908 |       16309 |       21260 | 13843 |
  95. | 20130920 |       16737 |       21494 | 14008 |
  96. | 20130926 |       16063 |       21751 | 14785 |
  97. | 20130930 |       15271 |       20188 | 13449 |
  98. | 20131011 |       14485 |       19635 | 12509 |
  99. | 20131015 |       15378 |       20946 | 11700 |
  100. | 20131021 |       15623 |       20419 | 12176 |
  101. | 20131028 |       13721 |       18126 | 11601 |
  102. | 20131105 |       14493 |       19953 | 12264 |
  103. | 20131111 |       15345 |       21013 | 11517 |
  104. | 20131123 |       13786 |       19346 | 12001 |
  105. | 20131130 |       15850 |       22336 | 11602 |
  106. | 20131204 |       16303 |       22203 | 10039 |
  107. | 20131210 |       14041 |       19724 |  8462 |
  108. +----------+-------------+-------------+-------+
  109. 103 ROWS IN SET (58.74 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