From ee8af1cb2eeff43b9f1760c9ffe2ab3c787b2a4e Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 28 Mar 2011 16:27:57 +0200 Subject: [PATCH] Yet another query. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- modules/email.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/email.php b/modules/email.php index 1496b04..df211d6 100644 --- a/modules/email.php +++ b/modules/email.php @@ -740,7 +740,7 @@ class EmailModule extends PLModule FROM email_watch AS w INNER JOIN email_redirect_account AS r ON (w.email = r.redirect) INNER JOIN email_source_account AS s ON (s.uid = r.uid AND s.type = \'forlife\') - INNER JOIN accounts AS a ON (w.uid = a.uid) + INNER JOIN accounts AS a ON (r.uid = a.uid) WHERE w.email = {?} ORDER BY s.email', $email); -- 2.1.4