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

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

Return to bug 12505