Index: branches/5.1.x/core/kernel/db/dblist.php
===================================================================
diff -u -N -r14060 -r14119
--- branches/5.1.x/core/kernel/db/dblist.php	(.../dblist.php)	(revision 14060)
+++ branches/5.1.x/core/kernel/db/dblist.php	(.../dblist.php)	(revision 14119)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: dblist.php 14060 2010-11-23 18:22:53Z alex $
+* @version	$Id: dblist.php 14119 2011-01-05 12:05:38Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -352,9 +352,9 @@
 
 	function getCountSQL($sql)
 	{
-		if ( preg_match("/DISTINCT(.*?)FROM(?!_)/is",$sql,$regs ) )
+		if ( preg_match("/^\s*SELECT\s+DISTINCT(.*?)FROM(?!_)/is",$sql,$regs ) )
 		{
-			return preg_replace("/^\s*SELECT DISTINCT(.*?)FROM(?!_)/is", "SELECT COUNT(DISTINCT ".$regs[1].") AS count FROM", $sql);
+			return preg_replace("/^\s*SELECT\s+DISTINCT(.*?)FROM(?!_)/is", "SELECT COUNT(DISTINCT ".$regs[1].") AS count FROM", $sql);
 		}
 		else
 		{