From bc3bd9da4239732574b92842d5573e3316c749de Mon Sep 17 00:00:00 2001
From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Sat, 11 Apr 2015 15:57:19 +0200
Subject: [PATCH] Additional syntax cleanup to previous patch.

---
 includes/db_pager.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/includes/db_pager.inc b/includes/db_pager.inc
index 1940236d..c2ae04b6 100644
--- a/includes/db_pager.inc
+++ b/includes/db_pager.inc
@@ -290,7 +290,7 @@ class db_pager {
 		if ($count) {
 			$group = $group == '' ? "*" : "DISTINCT $group";
 
-			return "SELECT COUNT(0) FROM (SELECT $group FROM $from $where) row_count";
+			return "SELECT COUNT(*) FROM (SELECT $group FROM $from $where) tmp_count";
 		}
 
 		$sql = "$select FROM $from $where";
-- 
2.30.2