From: Ian Beckwith <ianb@erislabs.net>
Date: Fri, 15 Oct 2010 00:23:39 +0000 (+0100)
Subject: NOT: fix left joins
X-Git-Tag: debian/1.0-1~100
X-Git-Url: http://erislabs.net/gitweb/?p=id3fs.git;a=commitdiff_plain;h=29d3cf8e8ed7ef37f1e746dedeb2c97299ad36f6

NOT: fix left joins
---

diff --git a/lib/ID3FS/Path/Node.pm b/lib/ID3FS/Path/Node.pm
index 8ce259e..472fe41 100644
--- 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)
     {