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 |
- |
|
|