Bug#894659: UDD/sponsorstats: shows less than half of uploads

[Adam Borowski <kilobyte@angband.pl>]

Package: qa.debian.org
Severity: normal

Hi!
The page at https://udd.debian.org/sponsorstats.cgi shows only some uploads. 
Turns out an upload is shown only only if that version is still present on
at least one architecture in unstable.  Currently, kfreebsd pins a good
fraction of packages, but generally an upload will be kept for one-two days
normally, longer if it FTBFSes, or for years if the package is neglected or
regressed only on a non-release arch.

I'm not sure what the code _wants_ to get.  The prose suggests it tries to
get the entire history (which would also fit my use case: listing uploads
I did for a person who requested advocating), but, as the query says:
｢s.release = 'sid'｣, you might want just the newest version.

Ie, the query could be edited to either:
• take all s.distribution = 'debian'
• u.distribution = 'unstable'
• take only max s.source

I'd pick the first, as stable updates or working on a package in
experimental also deserve a credit for the sponsoree, but the choice is
yours.  In any case, the current mix (randomly count _some_ packages
multiple times) doesn't appear to make any sense.


Meow!