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
('[email protected]','[email protected]','unknown')
) miss GROUP BY done_email
ORDER BY count DESC
;
done_email | count
--------------------------------------------------------+-------
[email protected] | 5221
[email protected] | 2665
[email protected] | 2555
[email protected] | 2371
[email protected] | 2056
[email protected] | 1900
[email protected] | 1788
[email protected] | 1393
[email protected] | 1327
[email protected] | 1278
[email protected] | 1155
[email protected] | 1031
[email protected] | 992
...
[email protected] | 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.
