Changeset 12118 for trunk/include/functions_tag.inc.php

Timestamp:

Sep 8, 2011, 8:22:27 PM (13 years ago)

Author:

rvelices

Message:

• reoptimize queries for MySql
• week starts on monday/sunday applies also to weekly calendar

File:

• trunk/include/functions_tag.inc.php (modified) (1 diff)

trunk/include/functions_tag.inc.php

@@ -229 +229 @@
   }
   $query .='
-  GROUP BY tag_id, t.id, t.name, t.url_name';
+  GROUP BY t.id
+  ORDER BY ';
   if ($max_tags>0)
   {
-    $query .= '
-  ORDER BY counter DESC
+    $query .= 'counter DESC
   LIMIT '.$max_tags;
+  }
+  else
+  {
+    $query .= 'NULL';
   }