NOT: fix left joins

diff --git a/lib/ID3FS/Path/Node.pm b/lib/ID3FS/Path/Node.pm
index 8ce259e..472fe41 100644 (file)
--- a/lib/ID3FS/Path/Node.pm
+++ b/lib/ID3FS/Path/Node.pm
@@ -114,12 +114,12 @@ sub node_to_sql
     if(defined($node->{parents_id}))
     {
        $sql= "(t" . scalar(@joins) . ".parents_id='$node->{parents_id}'";
-       $sql .= " AND fxt" . scalar(@joins) . ".tags_id='" . $node->{id} . "'";
+       $sql .= " AND t" . scalar(@joins) . ".id='" . $node->{id} . "'";
     }
     else
     {
        $sql= "(t" . scalar(@joins) .".parents_id=''";
-       $sql .= " AND fxt" . scalar(@joins) . ".tags_id='" . $node->{id} . "'";
+       $sql .= " AND t" . scalar(@joins) . ".id='" . $node->{id} . "'";
     }
     if($not)
     {