Package: qa.debian.org
Severity: normal
Hi,
I tried to analyse closed bugs using done_email via carnivore_emails but
realised
that this table is lacking lots of entries where I could easily add several from
my own memory:
SELECT done_email, COUNT(*) FROM (
SELECT done_email FROM archived_bugs WHERE id IN (SELECT id FROM (SELECT ab.id,
ce.id AS ce_id
FROM archived_bugs ab
LEFT JOIN carnivore_emails ce ON ce.email = ab.done_email
) noid WHERE ce_id IS NULL ) AND done_email NOT IN
('ftpmas...@ftp-master.debian.org','nore...@salsa.debian.org','unknown')
) miss GROUP BY done_email
ORDER BY count DESC
;
done_email | count
--------------------------------------------------------+-------
goth...@sapo.pt | 5221
ba...@quantz.debian.org | 2665
d...@cs.tu-berlin.de | 2555
kit...@northeye.org | 2371
m...@linux.it | 2056
herb...@gondor.apana.org.au | 1900
da...@merkel.debian.org | 1788
daniel.baum...@progress-technologies.net | 1393
m...@stro.at | 1327
b...@fs.tum.de | 1278
debian-...@adam-barratt.org.uk | 1155
cche...@cheney.cx | 1031
sramac...@respighi.debian.org | 992
...
zweistei...@gmx.de | 1
(9075 rows)
I wonder how the carnivore_* tables are filled and whether you want me
to draft some INSERT statements filling up the most relevant emails
where I would volunteer to sort the according IDs.
Kind regards
Andreas.
