From b83df6be6877b167571c68dc71765cd4f979e9e9 Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
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_notification.inc.php | 6 +++---
 include/functions_tag.inc.php          | 4 ++--
 include/functions_user.inc.php         | 4 ++--
 include/ws_functions.inc.php           | 6 +++---
 4 files changed, 10 insertions(+), 10 deletions(-)

diff --git a/include/functions_notification.inc.php b/include/functions_notification.inc.php
index edffe9f99..eecdf1a5e 100644
--- a/include/functions_notification.inc.php
+++ b/include/functions_notification.inc.php
@@ -476,8 +476,8 @@ function get_recent_post_dates($max_dates, $max_elements, $max_cats)
 
   $query = '
 SELECT date_available,
-      COUNT(DISTINCT id) nb_elements,
-      COUNT(DISTINCT category_id) nb_cats
+      COUNT(DISTINCT id) AS nb_elements,
+      COUNT(DISTINCT category_id) AS nb_cats
   FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id
   '.$where_sql.'
   GROUP BY date_available
@@ -515,7 +515,7 @@ SELECT id, path, name, tn_ext, file
     if ($max_cats>0)
     {// get some categories ...
       $query = '
-SELECT c.uppercats, COUNT(DISTINCT i.id) img_count
+SELECT c.uppercats, COUNT(DISTINCT i.id) AS img_count
   FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id=image_id
     INNER JOIN '.CATEGORIES_TABLE.' c ON c.id=category_id
   '.$where_sql.'
diff --git a/include/functions_tag.inc.php b/include/functions_tag.inc.php
index f05746b31..0f5859333 100644
--- a/include/functions_tag.inc.php
+++ b/include/functions_tag.inc.php
@@ -36,7 +36,7 @@ function get_available_tags()
 {
   // we can find top fatter tags among reachable images
   $query = '
-SELECT tag_id, COUNT(DISTINCT(it.image_id)) counter
+SELECT tag_id, COUNT(DISTINCT(it.image_id)) AS counter
   FROM '.IMAGE_CATEGORY_TABLE.' ic
     INNER JOIN '.IMAGE_TAG_TABLE.' it ON ic.image_id=it.image_id'.get_sql_condition_FandF
     (
@@ -223,7 +223,7 @@ function get_common_tags($items, $max_tags, $excluded_tag_ids=null)
     return array();
   }
   $query = '
-SELECT t.*, count(*) counter
+SELECT t.*, count(*) AS counter
   FROM '.IMAGE_TAG_TABLE.'
     INNER JOIN '.TAGS_TABLE.' t ON tag_id = id
   WHERE image_id IN ('.implode(',', $items).')';
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
diff --git a/include/ws_functions.inc.php b/include/ws_functions.inc.php
index 34b1403ec..d0b44b0be 100644
--- a/include/ws_functions.inc.php
+++ b/include/ws_functions.inc.php
@@ -285,7 +285,7 @@ SELECT id, name, permalink, image_order
     $order_by = empty($order_by) ? $conf['order_by'] : 'ORDER BY '.$order_by;
 
     $query = '
-SELECT i.*, GROUP_CONCAT(category_id) cat_ids
+SELECT i.*, GROUP_CONCAT(category_id) AS cat_ids
   FROM '.IMAGES_TABLE.' i
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON i.id=image_id
   WHERE '. implode('
@@ -693,7 +693,7 @@ SELECT COUNT(rate) AS count
   }
 
   $query = '
-SELECT COUNT(id) nb_comments
+SELECT COUNT(id) AS nb_comments
   FROM '.COMMENTS_TABLE.'
   WHERE '.$where_comments;
   list($nb_comments) = array_from_query($query, 'nb_comments');
@@ -1454,7 +1454,7 @@ function ws_tags_getImages($params, &$service)
     else
     {
       $query = '
-SELECT image_id, GROUP_CONCAT(tag_id) tag_ids
+SELECT image_id, GROUP_CONCAT(tag_id) AS tag_ids
   FROM '.IMAGE_TAG_TABLE.'
   WHERE tag_id IN ('.implode(',',$tag_ids).')
   GROUP BY image_id';
-- 
cgit v1.2.3