Hi Jean, For India, it is showing zero now also. And this is also showing zero images
https://en.wikipedia.org/wiki/Wikipedia:WikiProject_India/ Wiki_Loves_Monuments/Unused_ASI_Monuments_images Thanks, naveenpf On Thu, Sep 29, 2016 at 4:36 PM, Jean-Frédéric <jeanfrederic.w...@gmail.com> wrote: > Is there any tool to know image count based on Monument ID ? >> > > So, now that the job has run, there is an up-to-date `image` table on the > monuments database, indexing 2 575 525 images. > > A database query for what your need is straightforward − see that example > for Georgia [1] − but that does not quite scale nor is easily accessible. > > Should be fairly easy to build a tool on top of it though. > > >> Plus, a tool to know user who has covered maximum no of monuments ? >> > > I don’t think this exists at the moment (yet! :) > > > there is my tool, but it knows only Ukraine's monument lists. >> I'm going to adapt it to erfgoed/heritage database first week of October. >> > > Thanks Ilya ! Looking forward to it :) > > > [1] Top 10 illustrated monuments in Georgia: > MariaDB [s51138__heritage_p]> SELECT id, COUNT(img_name) as pics FROM > image WHERE country='ge' GROUP BY id ORDER BY pics DESC LIMIT 10; > +------+------+ > | id | pics | > +------+------+ > | 4667 | 188 | > | 4657 | 143 | > | 2343 | 124 | > | 3678 | 122 | > | 6490 | 119 | > | 3244 | 100 | > | 1953 | 100 | > | 4842 | 94 | > | 4668 | 93 | > | 875 | 76 | > +------+------+ > 10 rows in set (0.06 sec) > > -- > Jean-Frédéric > > _______________________________________________ > Wiki Loves Monuments mailing list > WikiLovesMonuments@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.org >
_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org