Index: branches/5.2.x/core/units/helpers/list_helper.php
===================================================================
diff -u -N -r14748 -r14782
--- branches/5.2.x/core/units/helpers/list_helper.php	(.../list_helper.php)	(revision 14748)
+++ branches/5.2.x/core/units/helpers/list_helper.php	(.../list_helper.php)	(revision 14782)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: list_helper.php 14748 2011-11-09 09:35:48Z alex $
+* @version	$Id: list_helper.php 14782 2011-11-22 16:42:10Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2011 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -204,7 +204,8 @@
 			$where_clause = '(%1$s.' . $object->IDField . ' != ' . $object->GetID() . ') AND ((' . implode(') OR (', $where_clause) . '))';
 			$list->addFilter('navigation_filter', $where_clause);
 
-			$sql = $list->extractCalculatedFields($list->GetSelectSQL());
+			// do extractCalculatedFields (transforms having into where), since we don't select fields from JOINed tables
+			$sql = str_replace('%1$s', $list->TableName, $list->extractCalculatedFields($list->GetSelectSQL()));
 
 			$list->removeFilter('navigation_filter');
 			$list->setOrderFields($order_fields_backup);