Actions
Demande #5278
ferméNettoyer les abonnements openmailbox
Début:
13/03/2021
Echéance:
% réalisé:
0%
Temps estimé:
Difficulté:
2 Facile
Description
Le domaine openmailbox est à l'abandon depuis plus de deux ans. Cf https://linuxfr.org/users/aurelieng/journaux/openmailbox
Je sais pas pk sympa ne les désabonne pas très vite mais ça fait 2 ans que ce domaine nous pourri les queues mail.
Je propose de supprimer les abonnements.
MariaDB [sympa]> select count(user_subscriber),sum(bounce_score_subscriber),list_subscriber from subscriber_table where user_subscriber like "%@openmailbox.org" group by list_subscriber; +------------------------+------------------------------+-----------------------+ | count(user_subscriber) | sum(bounce_score_subscriber) | list_subscriber | +------------------------+------------------------------+-----------------------+ | 1 | 0 | 20ans | | 17 | 30 | april-actu | | 1 | NULL | campagne-adhesion | | 3 | NULL | candidatsfr-actu | | 1 | 0 | candidatsfr-locaux | | 1 | 0 | communique | | 1 | 0 | comptabilite | | 1 | 11 | copyleft_attitude | | 1 | NULL | diversite | | 3 | 89 | educ | | 1 | NULL | gnu30parisorg | | 1 | 0 | informatique-deloyale | | 1 | 0 | lef | | 1 | 17 | libreassociation | | 1 | NULL | news | | 1 | 10 | trad-gnu | | 1 | 0 | traductions | +------------------------+------------------------------+-----------------------+ 17 rows in set (0.026 sec) select user_subscriber,bounce_score_subscriber,list_subscriber from subscriber_table where user_subscriber like "%@openmailbox.org"; +-------------------------------------+-------------------------+-----------------------+ | user_subscriber | bounce_score_subscriber | list_subscriber | +-------------------------------------+-------------------------+-----------------------+ ... 37 rows in set (0.023 sec)
Actions