Index: branches/5.2.x/core/units/helpers/mailing_list_helper.php
===================================================================
diff -u -N -r14941 -r15012
--- branches/5.2.x/core/units/helpers/mailing_list_helper.php	(.../mailing_list_helper.php)	(revision 14941)
+++ branches/5.2.x/core/units/helpers/mailing_list_helper.php	(.../mailing_list_helper.php)	(revision 15012)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: mailing_list_helper.php 14941 2011-12-29 12:47:14Z alex $
+* @version	$Id: mailing_list_helper.php 15012 2012-01-06 20:38:49Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -172,14 +172,14 @@
 			switch ($recipient_type) {
 				case 'u':
 					$sql = 'SELECT Email
-							FROM ' . TABLE_PREFIX . 'PortalUser
+							FROM ' . TABLE_PREFIX . 'Users
 							WHERE (PortalUserId IN (' . implode(',', $recipient_ids) . ')) AND (Email <> "")';
 					break;
 
 				case 'g':
 					$sql = 'SELECT u.Email
-							FROM ' . TABLE_PREFIX . 'UserGroup ug
-							LEFT JOIN ' . TABLE_PREFIX . 'PortalUser u ON u.PortalUserId = ug.PortalUserId
+							FROM ' . TABLE_PREFIX . 'UserGroupRelations ug
+							LEFT JOIN ' . TABLE_PREFIX . 'Users u ON u.PortalUserId = ug.PortalUserId
 							WHERE (ug.GroupId IN (' . implode(',', $recipient_ids) . ')) AND (u.Email <> "")';
 					break;