X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fmarketing.php;h=5068fd40c6aa14c904efcccd3f1ecc866c07087c;hb=fa9994fa46e744766e87e445413610cf3f184374;hp=eea4a83fb873eebfb1b6d7cfaa4bb0a67854a98e;hpb=3c9043937a80d8e0fc64bf918b0d37fc0cc64c0c;p=platal.git

diff --git a/modules/marketing.php b/modules/marketing.php
index eea4a83..5068fd4 100644
--- a/modules/marketing.php
+++ b/modules/marketing.php
@@ -123,8 +123,8 @@ class MarketingModule extends PLModule
         $res = XDB::iterator(
                 "SELECT  r.*, a.alias
                    FROM  register_marketing AS r
-              LEFT JOIN  aliases            AS a ON (r.sender=a.id AND a.type = 'a_vie')
-                  WHERE  uid={?}
+              LEFT JOIN  aliases            AS a ON (r.sender = a.uid AND a.type = 'a_vie')
+                  WHERE  r.uid = {?}
                ORDER BY  date", $user->id());
         $page->assign('addr', $res);