From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Sat, 11 Apr 2015 13:57:19 +0000 (+0200)
Subject: Additional syntax cleanup to previous patch.
X-Git-Tag: 2.3-final~51
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=bc3bd9da4239732574b92842d5573e3316c749de

Additional syntax cleanup to previous patch.
---

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";