2013/2/5 Lodewijk <lodewijk(a)effeietsanders.org>
just for comparison: what is the percentage for the
whole of wikimedia
commons?
Unless I missed something (my SQL-fu is *very* rustry), around 8,7 million
files (=53.6% of Commons) are used at least once in the main space of a
Wikimedia project (excluding meta).
mysql> SELECT /* SLOW_OK */ COUNT(DISTINCT gil_to)
-> FROM `globalimagelinks`
-> WHERE gil_page_namespace_id = 0 AND (gil_wiki!='metawiki');
+------------------------+
| COUNT(DISTINCT gil_to) |
+------------------------+
| 8710633 |
+------------------------+
1 row in set (1 hour 10 min 51.32 sec)
I am not sure if this looks legit or if I definitely missed something.
--
Jean-Frédéric