$clause .= " AND tags.id NOT IN (" . join(', ', @values) . ")";
}
$clause .= ")";
- push(@orclauses, $clause);
+ push(@andclauses, $clause);
}
else
{
# print "HASNT VALUES\n";;
if(@used)
{
- push(@orclauses, "(NOT (tags.parents_id='' AND tags.id IN (" . join(', ', @used) . ")))");
+ push(@andclauses, "(NOT (tags.parents_id='' AND tags.id IN (" . join(', ', @used) . ")))");
}
for my $pair (@used_with_vals)
{
- push(@orclauses, "(NOT (tags.parents_id='" . $pair->[0] . "' AND tags.id='" . $pair->[1] . "'))");
+ push(@andclauses, "(NOT (tags.parents_id='" . $pair->[0] . "' AND tags.id='" . $pair->[1] . "'))");
}
}