El 04/11/13 11:36, Àlex Hinojo escribió:
Hi all,
I would like to know how many pics from this award category are coming
from each participant country
https://commons.wikimedia.org/wiki/Category:WWI_related_images_from_Wiki_Loves_Monuments_2013
could someone help me on this? Is there any tool to calculate it?
select wlm_country, count(*) as count from categorylinks join
u_platonides_wlm_p.wlm2013 ON (cl_from=wlm_page) where cl_type='file'
and cl_to='WWI_related_images_from_Wiki_Loves_Monuments_2013' GROUP BY
wlm_Country ;
+-------------+-------+
| wlm_country | count |
+-------------+-------+
| am | 37 |
| at | 35 |
| az | 3 |
| be | 22 |
| ca | 3 |
| cz | 9 |
| de | 159 |
| es | 11 |
| fr | 216 |
| gb | 61 |
| hu | 1 |
| il | 2 |
| in | 39 |
| it | 4 |
| jo | 16 |
| nl | 37 |
| pl | 722 |
| ro | 222 |
| rs | 19 |
| ru | 214 |
| sk | 18 |
| ua | 54 |
| us | 1 |
| uy | 1 |
| za | 385 |
+-------------+-------+
_______________________________________________
Wiki Loves Monuments mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
