Στις 26-09-2011, ημέρα Δευ, και ώρα 02:20 +0200, ο/η melvin_mm έγραψε: > John <phoenixoverride <at> gmail.com> writes: > > > > mysql> select count(*) from archive; > > +----------+ > > | count(*) | > > +----------+ > > | 33263574 | > > +----------+ > > 1 row in set (8 min 47.50 sec) > > > > On Sun, Sep 25, 2011 at 5:13 PM, melvin_mm <melvin_mm <at> gmx.de> wrote: > > > > > Bryan Tong Minh <bryan.tongminh <at> gmail.com> writes: > > > > Deleted revisions? > > > > > > If deleted revisions sum up to ~70.000.000 - could I add this > > > information to > > > http://en.wikipedia.org/wiki/Wikipedia:Database_download > > > ? > > > > > > What would you advice to do if I wanted to verify the counter result? > > 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 _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
