From 417195c1c1870d16312443ce032dedb05d9a72de Mon Sep 17 00:00:00 2001
From: ikawhero <ikawhero>
Date: Fri, 10 Mar 2006 08:36:04 +0000
Subject: [PATCH] SQL fix

---
 blog/lib.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/blog/lib.php b/blog/lib.php
index e545b0b665..73fce314dc 100755
--- a/blog/lib.php
+++ b/blog/lib.php
@@ -838,9 +838,9 @@ function blog_print_entry_content ($template, $entryid, $filtertype='', $filters
 
 /// Links to tags
 
-    if ($blogtags = get_records_sql('SELECT tags.* FROM '.$CFG->prefix.'tags, '.$CFG->prefix.'blog_tag_instance
-                                 WHERE tags.id = blog_tag_instance.tagid
-                                 AND blog_tag_instance.entryid = '.$entryid)) {
+    if ($blogtags = get_records_sql('SELECT t.* FROM '.$CFG->prefix.'tags t, '.$CFG->prefix.'blog_tag_instance ti
+                                 WHERE t.id = ti.tagid
+                                 AND ti.entryid = '.$entryid)) {
         echo '<p />';
         print_string('tags', 'blog');
         foreach ($blogtags as $blogtag) {
-- 
2.39.5