From 1aca5a0644b8104a2f9cf94735115e0398109cb5 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Marichez?= <falco@gentoo.org>
Date: Mon, 7 Apr 2008 13:04:31 +0200
Subject: [PATCH] remove useless sql JOIN
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Raphaël Marichez <falco@gentoo.org>
---
 modules/email.php | 1 -
 1 file changed, 1 deletion(-)

diff --git a/modules/email.php b/modules/email.php
index 63cd1ab..c6200bb 100644
--- a/modules/email.php
+++ b/modules/email.php
@@ -459,7 +459,6 @@ class EmailModule extends PLModule
             $sel = XDB::query(
                     "SELECT  e.uid, a.alias
                        FROM  emails        AS e
-                 INNER JOIN  auth_user_md5 AS u ON e.uid = u.user_id
                  INNER JOIN  aliases       AS a ON (e.uid = a.id AND type!='homonyme'
                                                     AND FIND_IN_SET('bestalias',a.flags))
                       WHERE  e.email={?}", $email);
-- 
2.1.4