Projet

Général

Profil

Demande #5278

Mis à jour par François Poulain il y a environ 3 ans

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.

<pre>
MariaDB [sympa]> select count(user_subscriber),sum(bounce_score_subscriber),list_subscriber count(user_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 (0.018 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)
</pre>

Retour