Show
Ignore:
Timestamp:
08/24/06 01:14:02 (2 years ago)
Author:
cfriesen
Message:

Feel free to scream if this breaks something...

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • trunk/gregarius/cls/alltags.php

    r1181 r1544  
    7777        if($this -> type == 'channel'){ 
    7878            $sql .= " left join " . getTable('channels') . " c on (fid=c.id)," 
    79                 .getTable('tag')." t "." where tid=t.id " 
    80                 . " and ttype = 'channel'"; 
     79                ."inner join " . getTable('tag')." t "." on tid=t.id " 
     80                . " where ttype = 'channel'"; 
    8181        }else{ 
    8282            $sql .= " left join ".getTable('item')." i on (fid=i.id)," 
    83                 .getTable('tag')." t "." where tid=t.id " 
    84                 ." and ttype = 'item'"; 
     83                ."inner join " . getTable('tag')." t "." on tid=t.id " 
     84                ." where ttype = 'item'"; 
    8585        } 
    8686 
     
    121121            $cntr ++; 
    122122        } 
    123  
    124  
    125123    } 
    126124