View | Details | Raw Unified | Return to bug 7105
Collapse All | Expand All

(-)a/C4/Serials.pm (-3 / +2 lines)
Lines 588-594 sub GetSubscriptions { Link Here
588
            $tmpstring =~ s/^AND //;
588
            $tmpstring =~ s/^AND //;
589
            push @sqlstrings, $tmpstring;
589
            push @sqlstrings, $tmpstring;
590
        }
590
        }
591
        $sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "(" . join( ") OR (", @sqlstrings ) . ")";
591
        $sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "((" . join( ") OR (", @sqlstrings ) . "))";
592
    }
592
    }
593
    if ($issn) {
593
    if ($issn) {
594
        my @sqlstrings;
594
        my @sqlstrings;
Lines 601-607 sub GetSubscriptions { Link Here
601
            $tmpstring =~ s/^OR //;
601
            $tmpstring =~ s/^OR //;
602
            push @sqlstrings, $tmpstring;
602
            push @sqlstrings, $tmpstring;
603
        }
603
        }
604
        $sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "(" . join( ") OR (", @sqlstrings ) . ")";
604
        $sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "((" . join( ") OR (", @sqlstrings ) . "))";
605
    }
605
    }
606
    $sql .= "$sqlwhere ORDER BY title";
606
    $sql .= "$sqlwhere ORDER BY title";
607
    $debug and warn "GetSubscriptions query: $sql params : ", join( " ", @bind_params );
607
    $debug and warn "GetSubscriptions query: $sql params : ", join( " ", @bind_params );
608
- 

Return to bug 7105