# Revisions from the revision table # select left(rev_timestamp, 6) as month, sum(rev_parent_id is not null) as parent, sum(rev_parent_id is null) as null_parent from revision group by left(rev_timestamp, 6); month parent null_parent 200101 290 0 200102 710 0 200103 1377 0 200104 956 0 200105 1980 0 200106 1144 0 200107 2079 0 200108 3610 0 200109 6536 0 200110 10794 0 200111 16319 0 200112 24359 0 200201 17323 0 200202 54459 0 200203 24360 0 200204 20833 0 200205 19589 0 200206 29695 0 200207 33755 0 200208 60618 0 200209 84259 0 200210 109699 0 200211 63053 0 200212 99518 0 200301 91860 0 200302 80528 0 200303 87394 0 200304 90416 0 200305 112903 0 200306 117947 0 200307 138356 0 200308 156565 0 200309 141200 0 200310 152986 0 200311 200201 0 200312 222870 0 200401 220096 0 200402 311759 0 200403 443554 0 200404 407359 0 200405 422680 0 200406 563403 0 200407 603247 0 200408 643990 0 200409 679980 0 200410 745842 0 200411 951860 0 200412 937469 0 200501 804220 0 200502 793649 0 200503 1030958 0 200504 1302256 0 200505 1374003 0 200506 1520570 0 200507 1845927 0 200508 1997599 0 200509 1899940 0 200510 2259880 0 200511 2383143 0 200512 3247999 0 200601 3694883 0 200602 3580880 0 200603 4135757 0 200604 4015481 0 200605 4611150 0 200606 4593695 0 200607 4802300 0 200608 5414783 0 200609 4964558 0 200610 5433227 0 200611 5569367 0 200612 5610539 0 200701 6246742 0 200702 6164138 0 200703 6784566 0 200704 6786580 0 200705 6654662 0 200706 5919730 0 200707 5901036 0 200708 5797876 0 200709 5814992 0 200710 6225260 0 200711 5836827 0 200712 5715947 0 200801 6309842 0 200802 6107843 0 200803 6758217 0 200804 6290581 0 200805 6302530 0 200806 5909891 0 200807 5859887 0 200808 5878274 0 200809 6156437 0 200810 6268886 0 200811 5724423 0 200812 5620606 0 200901 6053717 0 200902 5754538 0 200903 6411099 0 200904 5731066 0 200905 6013202 0 200906 5554090 0 200907 5334119 0 200908 5403881 0 200909 5524238 0 200910 5581902 0 200911 5340875 0 200912 5884723 0 201001 5562725 0 201002 5285098 0 201003 5755241 0 201004 5699667 0 201005 5594565 0 201006 5398298 0 201007 5046828 0 201008 5312733 0 201009 5486447 0 201010 5707449 0 201011 5405560 0 201012 5083451 0 201101 5649340 0 201102 4864619 0 201103 4921778 0 201104 4741274 0 201105 4759692 0 201106 4880732 0 201107 4936665 0 201108 4945220 0 201109 5020750 0 201110 4730769 0 201111 4657159 0 201112 4990770 0 201201 5092519 0 201202 4875774 0 201203 5008924 0 201204 4811361 0 201205 5045098 0 201206 4465488 0 201207 4752621 0 201208 4734881 0 201209 4922928 0 201210 5094260 0 201211 4667634 0 201212 4609192 0 201301 4953187 0 201302 5136408 0 201303 6342349 0 201304 4613789 0 201305 4470318 0 201306 4285120 0 201307 4063348 0 201308 4107251 0 201309 3946996 0 201310 4180885 0 201311 4026977 0 201312 4349257 0 201401 4492618 0 201402 3982932 0 201403 4318005 0 201404 4116908 0 201405 4180585 0 201406 3848756 0 201407 4037269 0 201408 4051648 0 201409 3882179 0 201410 3964416 0 201411 3907543 0 201412 4133107 0 201501 4395446 0 201502 4017684 0 201503 4890957 0 201504 5507370 0 201505 4578239 0 201506 4268719 0 201507 4396293 0 201508 4629641 0 201509 4495747 0 201510 4691696 0 201511 4559917 0 201512 4302634 0 201601 4830935 0 201602 4804377 0 201603 5128030 0 201604 4901336 0 201605 4923566 0 201606 4501828 0 201607 4555143 0 201608 4561979 0 201609 4732497 0 201610 5088072 0 201611 529047 0 # Revisions from the archive table # select left(ar_timestamp, 6) as month, sum(ar_parent_id is not null) as parent, sum(ar_parent_id is null) as null_parent from enwiki.archive group by left(ar_timestamp, 6); month parent null_parent 200101 1 33 200102 10 87 200103 11 106 200104 2 32 200105 6 106 200106 10 79 200107 19 100 200108 17 180 200109 35 417 200110 41 616 200111 77 954 200112 155 1412 200201 73 315 200202 230 1957 200203 163 801 200204 85 603 200205 86 641 200206 84 667 200207 78 1131 200208 102 3399 200209 191 3033 200210 182 3048 200211 170 2739 200212 148 2721 200301 257 4177 200302 207 4773 200303 635 5313 200304 303 5315 200305 406 7105 200306 473 7803 200307 600 10292 200308 659 8170 200309 595 8077 200310 565 7741 200311 841 10414 200312 785 11729 200401 973 12754 200402 1282 24416 200403 2073 31851 200404 2553 28666 200405 2221 32107 200406 3606 67193 200407 3208 55010 200408 4162 62212 200409 4814 78945 200410 4984 81704 200411 5380 99724 200412 6342 131834 200501 5993 107236 200502 5783 101143 200503 7213 125234 200504 8965 146560 200505 10024 171978 200506 11229 189702 200507 13093 218022 200508 15745 255766 200509 13917 231661 200510 16122 302129 200511 20217 318215 200512 24011 406559 200601 27699 443033 200602 26985 462652 200603 32704 540060 200604 31744 526957 200605 34291 611166 200606 38240 601675 200607 40628 635614 200608 48994 706531 200609 41467 635854 200610 47116 674235 200611 47853 704332 200612 49502 697902 200701 52964 775826 200702 53443 760967 200703 56791 811204 200704 75939 1033523 200705 78723 924549 200706 59700 748238 200707 61977 711900 200708 58489 657514 200709 54598 611791 200710 58105 667286 200711 57892 624881 200712 59005 545328 200801 60780 574516 200802 55895 550407 200803 62559 564134 200804 68473 534581 200805 62298 539571 200806 63858 471136 200807 64669 415453 200808 61062 383205 200809 60650 379573 200810 67973 416964 200811 65391 357236 200812 63373 368690 200901 72081 370686 200902 77353 396765 200903 88575 423466 200904 68893 339270 200905 75235 332612 200906 72820 322030 200907 73146 330589 200908 71266 306273 200909 93194 351973 200910 73694 300116 200911 66727 277773 200912 71056 284218 201001 68725 302766 201002 67244 298791 201003 107880 326109 201004 75588 278561 201005 80311 266723 201006 79540 273934 201007 76382 247552 201008 83941 243881 201009 89948 227461 201010 88699 228622 201011 81141 221754 201012 81948 223113 201101 94189 241669 201102 86062 197713 201103 93205 202773 201104 92494 192519 201105 104466 195554 201106 98860 203487 201107 109753 200791 201108 136267 194873 201109 215687 251886 201110 128870 172766 201111 136512 164001 201112 242365 195001 201201 160713 156448 201202 232941 106859 201203 309845 0 201204 264379 0 201205 259117 0 201206 237744 0 201207 288698 0 201208 251621 0 201209 241862 0 201210 296669 0 201211 232980 0 201212 238644 0 201301 249987 0 201302 225995 0 201303 262100 0 201304 245291 0 201305 237154 0 201306 239042 0 201307 238711 0 201308 229396 0 201309 222197 0 201310 212230 0 201311 218885 0 201312 228428 0 201401 236144 0 201402 206745 0 201403 229809 0 201404 203521 0 201405 224732 0 201406 202456 0 201407 207778 0 201408 195934 0 201409 183763 0 201410 195169 0 201411 190964 0 201412 197719 0 201501 205336 0 201502 205543 0 201503 210920 0 201504 197921 0 201505 194026 0 201506 189261 0 201507 192063 0 201508 200083 0 201509 199015 0 201510 193314 0 201511 179937 0 201512 167617 0 201601 174029 0 201602 169088 0 201603 175225 0 201604 156081 0 201605 167086 0 201606 144498 0 201607 135081 0 201608 137951 0 201609 122194 0 201610 113852 0 201611 6168 0