Lines 4-10
if( CheckVersion( $DBversion ) ) {
Link Here
|
4 |
SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment |
4 |
SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment |
5 |
FROM borrower_debarments d |
5 |
FROM borrower_debarments d |
6 |
LEFT JOIN borrowers b ON b.borrowernumber=d.borrowernumber |
6 |
LEFT JOIN borrowers b ON b.borrowernumber=d.borrowernumber |
7 |
WHERE b.debarredcomment IS NULL AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) |
7 |
WHERE ( b.debarredcomment IS NULL OR b.debarredcomment = "" ) AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) |
8 |
GROUP BY d.borrowernumber |
8 |
GROUP BY d.borrowernumber |
9 |
|, { Slice => {} }); |
9 |
|, { Slice => {} }); |
10 |
|
10 |
|
11 |
- |
|
|