Acymailing : Getting bad emails

Isolate rebounds to a folder in Outlook
Copy folder contents to Windows Explorer folder
Zip folder, copy to espace cergy-internet.net on mut1, unzip
place yourself in folder with all emails
Run grep commande : grep -Eiorh '([[:alnum:]_.-]+@[[:alnum:]_.-]+?\.[[:alpha:].]{2,6})' “$@” * | sort | uniq > emails.txt
Copy back to local ordi
Open in pspad and remove doubtful e-mails
In acymailing, create new list, import emails to list
Change status in target listid to -1 for all subid in new list
Sub-query can't we same tabel so use backup table
* Unordered List Item
* target listid = 38
* rebounds listid = 57
* SELECT subid FROM jos_acymailing_listsub WHERE listid =57
* SELECT * FROM `jos_acymailing_subscriber` WHERE subid in (SELECT subid FROM jos_acymailing_listsub WHERE listid =57)
* UPDATE `jos_acymailing_listsub` SET status = -1 WHERE listid = 38 AND subid in (SELECT subid FROM jos_acymailing_listsub WHERE listid = 57)