2013/2/5 Lodewijk <lodew...@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
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
