Perhaps it's the "revisions" that are created when someone protects or moves a page?
2011/9/26 melvin_mm <[email protected]> > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
