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

(-)a/C4/Letters.pm (-4 / +1 lines)
Lines 299-311 sub SendAlerts { Link Here
299
        # search the biblionumber
299
        # search the biblionumber
300
        my $strsth =  $type eq 'claimacquisition'
300
        my $strsth =  $type eq 'claimacquisition'
301
            ? qq{
301
            ? qq{
302
            SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.*,aqbooksellers.*,
302
            SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.*
303
            aqbooksellers.id AS booksellerid
304
            FROM aqorders
303
            FROM aqorders
305
            LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
304
            LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
306
            LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber
305
            LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber
307
            LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber
306
            LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber
308
            LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id
309
            WHERE aqorders.ordernumber IN (
307
            WHERE aqorders.ordernumber IN (
310
            }
308
            }
311
            : qq{
309
            : qq{
312
- 

Return to bug 12505