Perhaps it's the "revisions" that are created when someone protects or moves a page?
2011/9/26 melvin_mm melvin_mm@gmx.de
Ariel T. Glenn<ariel<at> wikimedia.org> writes:
Στις 26-09-2011, ημέρα Δευ, και ώρα 02:20 +0200, ο/η melvin_mm έγραψε:
Ok, thanks! So in pages-meta-history, those ~33.000.000 archived / deleted revisions are not included. Probably this number consists of content from all Namespaces. What about the 37.000.000 revisions that are left now?
I guess that the wikistatistics.net page must get its values from Special:Statistics, since I see today that total number of edits as of Mon 26 Sept 2011 05:47:31 am UTC is 487,971,977, which is not far off from wikistatistics' value of 487 914 061. However, this number is not guaranteed to be accurate. The real number is
mysql> select max(rev_id) from revision; +-------------+ | max(rev_id) | +-------------+ | 452476647 | +-------------+ 1 row in set (0.00 sec)
Ariel
Thanks! Summing up: 412.482.641 counted "<revision" tags in 20110901
33.263.574 deleted revisions not included in pages-meta-history
5.391.296 revisions from September 1st to September 26th (according to wikistatistics.net, with 482.522.765 on September 1st) we get to 451.137.511 .
About 1.339.136 left from the current rev_id from the database. Where could the missing ones be? Incorrect wikistatistics.net results?
Best, Katja Müller
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l