Comment 8 for bug 736012

Revision history for this message
Curtis Hovey (sinzui) wrote :

There are now only three lists is large queues. Most of the messages are spam from 2010 when Lp wrongly accepted message claiming to be from the list itself. I think we should just

select team.name, count(*) from person team join mailinglist ml on team.id = ml.team join messageapproval ma on ml.id = ma.mailing_list where ma.status = 0 group by team.name having count(*) > 20;
      name | count
-----------------+-------
 dhis2-kenya | 31
 ubuntu-cyclists | 105
 ayatana | 70