From 29d3cf8e8ed7ef37f1e746dedeb2c97299ad36f6 Mon Sep 17 00:00:00 2001 From: Ian Beckwith Date: Fri, 15 Oct 2010 01:23:39 +0100 Subject: [PATCH] NOT: fix left joins --- lib/ID3FS/Path/Node.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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) { -- 2.11.0