From 9615c895d22ab93daa9b270ae502ae8eacbf2d93 Mon Sep 17 00:00:00 2001 From: x2003bruneau Date: Wed, 9 Aug 2006 22:40:55 +0000 Subject: [PATCH] Fix git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@794 839d8a87-29fc-0310-9880-83ba4fa771e5 --- modules/email.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/modules/email.php b/modules/email.php index 199e6c4..96ab340 100644 --- 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 - 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"; -- 2.1.4