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

(-)a/C4/Serials.pm (-6 / +6 lines)
Lines 254-266 sub GetSubscription { Link Here
254
    my ($subscriptionid) = @_;
254
    my ($subscriptionid) = @_;
255
    my $dbh              = C4::Context->dbh;
255
    my $dbh              = C4::Context->dbh;
256
    my $query            = qq(
256
    my $query            = qq(
257
        SELECT  subscription.*,
257
       SELECT
258
                subscriptionhistory.*,
258
                subscription.*,
259
                histstartdate, histenddate, missinglist, recievedlist, opacnote, librariannote,
259
                aqbooksellers.name AS aqbooksellername,
260
                aqbooksellers.name AS aqbooksellername,
260
                biblio.title AS bibliotitle,
261
                biblio.title AS bibliotitle,
261
                subscription.biblionumber as bibnum
262
                subscription.biblionumber as bibnum
262
       FROM subscription
263
       FROM subscription
263
       LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid
264
       LEFT JOIN subscriptionhistory USING(subscriptionid)
264
       LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id
265
       LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id
265
       LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber
266
       LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber
266
       WHERE subscription.subscriptionid = ?
267
       WHERE subscription.subscriptionid = ?
Lines 408-418 sub GetSubscriptionsFromBiblionumber { Link Here
408
    my $query          = qq(
409
    my $query          = qq(
409
        SELECT subscription.*,
410
        SELECT subscription.*,
410
               branches.branchname,
411
               branches.branchname,
411
               subscriptionhistory.*,
412
               histstartdate, histenddate, missinglist, recievedlist, opacnote, librariannote,
412
               aqbooksellers.name AS aqbooksellername,
413
               aqbooksellers.name AS aqbooksellername,
413
               biblio.title AS bibliotitle
414
               biblio.title AS bibliotitle
414
       FROM subscription
415
       FROM subscription
415
       LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid
416
       LEFT JOIN subscriptionhistory USING(subscriptionid)
416
       LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id
417
       LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id
417
       LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber
418
       LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber
418
       LEFT JOIN branches ON branches.branchcode=subscription.branchcode
419
       LEFT JOIN branches ON branches.branchcode=subscription.branchcode
419
- 

Return to bug 27964