Στις 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