[Wiki Loves Monuments] What is the number of photographs used in Wikipedia

[Jean-Frédéric]

2013/2/5 Lodewijk <lodewijk at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/wikilovesmonuments/attachments/20130220/3f6083fa/attachment.html>