Lines 587-592
sub GetFullSubscriptionsFromBiblionumber {
Link Here
|
587 |
aqbudget.bookfundid,aqbooksellers.name as aqbooksellername, |
587 |
aqbudget.bookfundid,aqbooksellers.name as aqbooksellername, |
588 |
biblio.title as bibliotitle, |
588 |
biblio.title as bibliotitle, |
589 |
subscription.branchcode AS branchcode, |
589 |
subscription.branchcode AS branchcode, |
|
|
590 |
branches.branchname AS branchname, |
590 |
subscription.subscriptionid AS subscriptionid|; |
591 |
subscription.subscriptionid AS subscriptionid|; |
591 |
if (C4::Context->preference('IndependantBranches') && |
592 |
if (C4::Context->preference('IndependantBranches') && |
592 |
C4::Context->userenv && |
593 |
C4::Context->userenv && |
Lines 601-606
sub GetFullSubscriptionsFromBiblionumber {
Link Here
|
601 |
(serial.subscriptionid=subscription.subscriptionid) |
602 |
(serial.subscriptionid=subscription.subscriptionid) |
602 |
LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid |
603 |
LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid |
603 |
LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id |
604 |
LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id |
|
|
605 |
LEFT JOIN branches ON branches.branchcode=subscription.branchcode |
604 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
606 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
605 |
WHERE subscription.biblionumber = ? |
607 |
WHERE subscription.biblionumber = ? |
606 |
ORDER BY year DESC, |
608 |
ORDER BY year DESC, |