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