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);
Index: branches/5.2.x/core/kernel/db/db_tag_processor.php
===================================================================
diff -u -N -r14769 -r14782
--- branches/5.2.x/core/kernel/db/db_tag_processor.php	(.../db_tag_processor.php)	(revision 14769)
+++ branches/5.2.x/core/kernel/db/db_tag_processor.php	(.../db_tag_processor.php)	(revision 14782)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: db_tag_processor.php 14769 2011-11-21 16:53:53Z alex $
+* @version	$Id: db_tag_processor.php 14782 2011-11-22 16:42:10Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -606,7 +606,9 @@
 		$list_helper =& $this->Application->recallObject('ListHelper');
 		/* @var $list_helper ListHelper */
 
-		return $list_helper->getNavigationResource($object, $params['list'], false);
+		$select_clause = $this->Application->getUnitOption($object->Prefix, 'NavigationSelectClause', null);
+
+		return $list_helper->getNavigationResource($object, $params['list'], false, $select_clause);
 	}
 
 	/**
@@ -625,7 +627,9 @@
 		$list_helper =& $this->Application->recallObject('ListHelper');
 		/* @var $list_helper ListHelper */
 
-		return $list_helper->getNavigationResource($object, $params['list'], true);
+		$select_clause = $this->Application->getUnitOption($object->Prefix, 'NavigationSelectClause', null);
+
+		return $list_helper->getNavigationResource($object, $params['list'], true, $select_clause);
 	}
 
 	/**
Index: branches/5.2.x/core/kernel/db/cat_event_handler.php
===================================================================
diff -u -N -r14780 -r14782
--- branches/5.2.x/core/kernel/db/cat_event_handler.php	(.../cat_event_handler.php)	(revision 14780)
+++ branches/5.2.x/core/kernel/db/cat_event_handler.php	(.../cat_event_handler.php)	(revision 14782)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: cat_event_handler.php 14780 2011-11-22 14:30:53Z alex $
+* @version	$Id: cat_event_handler.php 14782 2011-11-22 16:42:10Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -2629,7 +2629,9 @@
 		/* @var $object kDBItem */
 
 		if ( !$object->isLoaded() ) {
-			$this->_errorNotFound($event);
+			if ( $event->Special != 'previous' && $event->Special != 'next' ) {
+				$this->_errorNotFound($event);
+			}
 
 			return true;
 		}
Index: branches/5.2.x/core/kernel/db/db_event_handler.php
===================================================================
diff -u -N -r14762 -r14782
--- branches/5.2.x/core/kernel/db/db_event_handler.php	(.../db_event_handler.php)	(revision 14762)
+++ branches/5.2.x/core/kernel/db/db_event_handler.php	(.../db_event_handler.php)	(revision 14782)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: db_event_handler.php 14762 2011-11-11 17:25:13Z alex $
+* @version	$Id: db_event_handler.php 14782 2011-11-22 16:42:10Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -211,7 +211,9 @@
 				$list_helper =& $this->Application->recallObject('ListHelper');
 				/* @var $list_helper ListHelper */
 
-				return $list_helper->getNavigationResource($object, $event->getEventParam('list'), $event->Special == 'next');
+				$select_clause = $this->Application->getUnitOption($object->Prefix, 'NavigationSelectClause', null);
+
+				return $list_helper->getNavigationResource($object, $event->getEventParam('list'), $event->Special == 'next', $select_clause);
 			}
 
 			if (preg_match('/^auto-(.*)/', $event->Special, $regs) && $this->Application->prefixRegistred($regs[1])) {