|
Lines 592-598
sub GetBasketsInfosByBookseller {
Link Here
|
| 592 |
) AS expected_items |
592 |
) AS expected_items |
| 593 |
FROM aqbasket |
593 |
FROM aqbasket |
| 594 |
LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno |
594 |
LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno |
| 595 |
WHERE booksellerid = ? |
595 |
WHERE booksellerid = ? AND aqorders.datecancellationprinted IS NULL |
| 596 |
GROUP BY aqbasket.basketno |
596 |
GROUP BY aqbasket.basketno |
| 597 |
}; |
597 |
}; |
| 598 |
my $sth = $dbh->prepare($query); |
598 |
my $sth = $dbh->prepare($query); |
| 599 |
- |
|
|