Index: branches/RC/core/units/categories/categories_tag_processor.php
===================================================================
diff -u -N -r10274 -r10459
--- branches/RC/core/units/categories/categories_tag_processor.php	(.../categories_tag_processor.php)	(revision 10274)
+++ branches/RC/core/units/categories/categories_tag_processor.php	(.../categories_tag_processor.php)	(revision 10459)
@@ -77,13 +77,13 @@
 
 	function ItemCount($params)
 	{
-		$cat_object =& $this->getObject($params);
+		$object =& $this->getObject($params);
 		$ci_table = $this->Application->getUnitOption('l-ci', 'TableName');
 
 		$sql = 'SELECT COUNT(*)
-				FROM '.$cat_object->TableName.' c
-				LEFT JOIN '.$ci_table.' ci ON c.CategoryId=ci.CategoryId
-				WHERE c.ParentPath LIKE "'.$cat_object->GetDBField('ParentPath').'%" AND NOT (ci.CategoryId IS NULL)';
+				FROM ' . $object->TableName . ' c
+				LEFT JOIN ' . $ci_table . ' ci ON c.CategoryId = ci.CategoryId
+				WHERE (c.TreeLeft BETWEEN ' . $object->GetDBField('TreeLeft') . ' AND ' . $object->GetDBField('TreeRight') . ') AND NOT (ci.CategoryId IS NULL)';
 		return $this->Conn->GetOne($sql);
 	}