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
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