+sub bare_not_subselect
+{
+ my($self)=@_;
+ my @tags=grep { ref($_) eq "ID3FS::PathElement::Tag"; } @{$self->{elements}};
+ my $sql=("\tSELECT f1.id AS files_id FROM files f1 WHERE f1.id NOT IN (\n" .
+ "\t\tSELECT fxt1.files_id FROM tags t1\n" .
+ "\t\tINNER JOIN files_x_tags fxt1 ON t1.id=fxt1.tags_id\n" .
+ "\t\tWHERE ");
+ if(scalar(@tags) > 1)
+ {
+ $sql .= ("(t1.parents_id='" . $tags[0]->{id} . "' AND t1.id='" .
+ $tags[1]->{id} . "')");
+ }
+ else
+ {
+ $sql .= ("(t1.parents_id='' AND t1.id='" . $tags[0]->{id} . "')");
+ }
+ $sql .= "\n\t\tGROUP BY fxt1.files_id\n\t)\n";
+ return($sql);
+}
+