On Wed, Oct 26, 2011 at 11:42:07PM +0200, Platonides wrote:
I made you a list of all authors of files in
Images_from_Wiki_Loves_Monuments_2011_in_the_Netherlands category.
Get it from /home/platonides/public_html/wlm/uploaders-nl-non-unique.txt
Just count the times a name appears. You probably want an incantation
like this:
sort uploaders-nl-non-unique.txt | uniq -c | sort -nr
Hi Platonius,
I realised I used the wrong query this morning. I just corrected myself
to the dutch jurymembers :-(
The query I grabbed counted just the number of pictures, while I needed
the number of monuments (unique id's).
Thanks for your help, but this give me the number of images again. In the
mean while I learned Nuno has already written what I need. However, will
still study your hints and those of Nuno to see how it can be fixed. It
seems you need to build logic outside the sql for a solution.
Regards,
Andre