Changeset 1544 for trunk/gregarius/cls/alltags.php
- Timestamp:
- 08/24/06 01:14:02 (2 years ago)
- Files:
-
- 1 modified
-
trunk/gregarius/cls/alltags.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/gregarius/cls/alltags.php
r1181 r1544 77 77 if($this -> type == 'channel'){ 78 78 $sql .= " left join " . getTable('channels') . " c on (fid=c.id)," 79 . getTable('tag')." t "." wheretid=t.id "80 . " andttype = 'channel'";79 ."inner join " . getTable('tag')." t "." on tid=t.id " 80 . " where ttype = 'channel'"; 81 81 }else{ 82 82 $sql .= " left join ".getTable('item')." i on (fid=i.id)," 83 . getTable('tag')." t "." wheretid=t.id "84 ." andttype = 'item'";83 ."inner join " . getTable('tag')." t "." on tid=t.id " 84 ." where ttype = 'item'"; 85 85 } 86 86 … … 121 121 $cntr ++; 122 122 } 123 124 125 123 } 126 124
