projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
backport : bug geoloc pour afficher toutes les adresses
[platal.git]
/
modules
/
email.php
diff --git
a/modules/email.php
b/modules/email.php
index
199e6c4
..
96ab340
100644
(file)
--- a/
modules/email.php
+++ b/
modules/email.php
@@
-452,8
+452,8
@@
L'
$sql = "SELECT w.detection, w.state, w.last, w.description,
a1.alias AS edit, a2.alias AS forlife
FROM emails_watch AS w
$sql = "SELECT w.detection, w.state, w.last, w.description,
a1.alias AS edit, a2.alias AS forlife
FROM emails_watch AS w
- LEFT JOIN
emails AS e USING(email)
-
INNER JOIN aliases AS a1 ON (a1.id = w.uid AND a1.type = 'a_vie'
)
+ LEFT JOIN
aliases AS a1 ON (a1.id = w.uid AND a1.type = 'a_vie')
+
LEFT JOIN emails AS e ON (w.email = e.email
)
LEFT JOIN aliases AS a2 ON (a2.id = e.uid AND a2.type = 'a_vie')
WHERE w.email = {?}
ORDER BY a2.alias";
LEFT JOIN aliases AS a2 ON (a2.id = e.uid AND a2.type = 'a_vie')
WHERE w.email = {?}
ORDER BY a2.alias";