From b83df6be6877b167571c68dc71765cd4f979e9e9 Mon Sep 17 00:00:00 2001 From: nikrou Date: Sat, 3 Jul 2010 12:16:12 +0000 Subject: Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queries Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6653 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_user.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'include/functions_user.inc.php') diff --git a/include/functions_user.inc.php b/include/functions_user.inc.php index aa35539d6..6eb733bce 100644 --- a/include/functions_user.inc.php +++ b/include/functions_user.inc.php @@ -678,10 +678,10 @@ function compute_categories_data(&$cats) */ function get_computed_categories($userdata, $filter_days=null) { - $query = 'SELECT c.id cat_id, global_rank'; + $query = 'SELECT c.id AS cat_id, global_rank'; // Count by date_available to avoid count null $query .= ', - MAX(date_available) date_last, COUNT(date_available) nb_images + MAX(date_available) AS date_last, COUNT(date_available) AS nb_images FROM '.CATEGORIES_TABLE.' as c LEFT JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.category_id = c.id LEFT JOIN '.IMAGES_TABLE.' AS i -- cgit v1.2.3