-/* donne la liste des gens pour qui on a fait du marketing mais qui se sont inscrits depuis (nettoyage de envoidirect) */
-info("select e.matricule,e.nom,e.prenom,e.promo from envoidirect as e inner join auth_user_md5 as a on (e.matricule = a.matricule and a.perms = 'user') order by promo,nom;");
+/* donne la liste des emails douteux que les administrateurs n'ont pas encore traité */
+check("SELECT a1.alias, a2.alias, e1.email, e2.flags
+ FROM emails AS e1
+ INNER JOIN emails AS e2 ON(e1.email = e2.email AND e1.uid!=e2.uid AND
+ (e1.uid<e2.uid OR NOT FIND_IN_SET(e2.flags,'active'))
+ )
+ INNER JOIN emails_watch AS w ON(w.email = e1.email AND w.state = 'pending')
+ INNER JOIN aliases AS a1 ON(a1.id=e1.uid AND a1.type='a_vie')
+ INNER JOIN aliases AS a2 ON(a2.id=e2.uid AND a2.type='a_vie')
+ INNER JOIN auth_user_md5 AS u1 ON(a1.id=u1.user_id)
+ INNER JOIN auth_user_md5 AS u2 ON(a2.id=u2.user_id)
+ WHERE FIND_IN_SET(e1.flags,'active') AND u1.nom!=u2.nom_usage AND u2.nom!=u1.nom_usage
+ ORDER BY a1.alias",
+ "donne la liste des emails douteux actuellement non traites par les administrateurs");