On 11 February 2012 10:22, Robert Collins <robe...@robertcollins.net> wrote: > On Sat, Feb 11, 2012 at 11:49 AM, Guilherme Salgado > <guilherme.salg...@linaro.org> wrote: >> [1] "3355493" "4255840" "4265464" "4304737" "4814731" "4901002" >> "4904013" "4906280" "4907163" > > Are those user ids ? ... looks like account ids. > > only 5 have karma, 3 of which are over 1000 [e.g. nontrivial]. > > So we may well want to either contact them, or announce this loudly. > > select person.id, name, displayname, sum(karmavalue) from person, > karmacache where account in > (3355493,4255840,4265464,4304737,4814731,4901002,4904013,4906280,4907163) > and karmacache.person=person.id group by person.id, name, displayname;
id | name | displayname | sum ---------+-----------------+--------------------------+------ 3337201 | anas.ram | Anas Ramadan | 1020 3340758 | angelicaisabelb | Angelica Barrios OpenERP | 1935 3714420 | golisp | golisp | 57 3043774 | sol-moe | Tor Syversen | 46 3612225 | dan-kim | dan kim | 1705 (5 rows) -- Martin _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : launchpad-dev@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
