launchpad-dev team mailing list archive

[Martin Pool <mbp@xxxxxxxxxxxxx>]

On 11 February 2012 10:22, Robert Collins <robertc@xxxxxxxxxxxxxxxxx> wrote:
> On Sat, Feb 11, 2012 at 11:49 AM, Guilherme Salgado
> <guilherme.salgado@xxxxxxxxxx> 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