aliases.id => aliases.uid

[platal.git] / modules / marketing.php

diff --git a/modules/marketing.php b/modules/marketing.php
index eea4a83..ae7fc5d 100644 (file)
--- a/modules/marketing.php
+++ b/modules/marketing.php
@@ -123,7 +123,7 @@ 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')
+              LEFT JOIN  aliases            AS a ON (r.sender=a.uid AND a.type = 'a_vie')
                   WHERE  uid={?}
                ORDER BY  date", $user->id());
         $page->assign('addr', $res);