Changeset 6653 for branches/2.1/include/functions_tag.inc.php

Timestamp:

Jul 3, 2010, 2:16:12 PM (14 years ago)

Author:

nikrou

Message:

Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queries
Merge from trunk

File:

• branches/2.1/include/functions_tag.inc.php (modified) (2 diffs)

branches/2.1/include/functions_tag.inc.php

@@ -37 +37 @@
   // 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
@@ -224 +224 @@
   }
   $query = '
-SELECT t.*, count(*) counter
+SELECT t.*, count(*) AS counter
   FROM '.IMAGE_TAG_TABLE.'
     INNER JOIN '.TAGS_TABLE.' t ON tag_id = id