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_Lov...
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 | +-------------+-------+