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

(-)a/C4/Serials.pm (-2 / +2 lines)
Lines 1856-1867 sub GetLateOrMissingIssues { Link Here
1856
        $sth = $dbh->prepare(
1856
        $sth = $dbh->prepare(
1857
            "SELECT
1857
            "SELECT
1858
            serialid,      aqbooksellerid,         name,
1858
            serialid,      aqbooksellerid,         name,
1859
            biblio.title,  planneddate,           serialseq,
1859
            biblio.title,  biblioitems.issn,       planneddate,       serialseq,
1860
                serial.status, serial.subscriptionid, claimdate, claims_count,
1860
                serial.status, serial.subscriptionid, claimdate, claims_count,
1861
                subscription.branchcode
1861
                subscription.branchcode
1862
            FROM serial
1862
            FROM serial
1863
                LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid
1863
                LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid
1864
                LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber
1864
                LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber
1865
                LEFT JOIN biblioitems ON subscription.biblionumber=biblioitems.biblionumber
1865
                LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
1866
                LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
1866
                WHERE subscription.subscriptionid = serial.subscriptionid
1867
                WHERE subscription.subscriptionid = serial.subscriptionid
1867
                        AND (serial.STATUS IN ($missing_statuses_string) OR ((planneddate < now() AND serial.STATUS = ?) OR serial.STATUS = ? OR serial.STATUS = ?))
1868
                        AND (serial.STATUS IN ($missing_statuses_string) OR ((planneddate < now() AND serial.STATUS = ?) OR serial.STATUS = ? OR serial.STATUS = ?))
1868
- 

Return to bug 17703