- my $strqueryfilter = "SELECT DISTINCT borrowernumber FROM ";
- $strqueryfilter .= "(SELECT borrowernumber from old_issues WHERE borrowernumber IS NOT NULL ";
- if ($filters->[1]){
- $strqueryfilter .= "AND old_issues.timestamp> '$filters->[1]' ";
- }
- $strqueryfilter .= "UNION SELECT borrowernumber FROM issues WHERE 1 ";
- if ($filters->[1]){
- $strqueryfilter .= "AND issues.timestamp> '$filters->[1]' ";
- }
- $strqueryfilter .= ") active_borrowers";
-
- $strcalc .= " AND borrowers.borrowernumber not in ($strqueryfilter)";
+ $strcalc .= " AND NOT EXISTS (SELECT * FROM issues WHERE issues.borrowernumber=borrowers.borrowernumber ";
+ $strcalc .= " AND issues.timestamp> '" . @$filters[1] . "'" if (@$filters[1]);
+ $strcalc .= ") ";
+ $strcalc .= " AND NOT EXISTS (SELECT * FROM old_issues WHERE old_issues.borrowernumber=borrowers.borrowernumber ";
+ $strcalc .= " AND old_issues.timestamp> '" . @$filters[1] . "'" if (@$filters[1]);
+ $strcalc .= ") ";