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

(-)a/C4/Serials.pm (-1 / +8 lines)
Lines 657-663 sub SearchSubscriptions { Link Here
657
    my ( $args ) = @_;
657
    my ( $args ) = @_;
658
658
659
    my $query = qq{
659
    my $query = qq{
660
        SELECT subscription.*, subscriptionhistory.*, biblio.*, biblioitems.issn
660
        SELECT
661
            subscription.notes AS publicnotes,
662
            subscription.*,
663
            subscriptionhistory.*,
664
            biblio.notes AS biblionotes,
665
            biblio.title,
666
            biblio.author,
667
            biblioitems.issn
661
        FROM subscription
668
        FROM subscription
662
            LEFT JOIN subscriptionhistory USING(subscriptionid)
669
            LEFT JOIN subscriptionhistory USING(subscriptionid)
663
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
670
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt (-2 / +1 lines)
Lines 148-154 Link Here
148
                        </td>
148
                        </td>
149
                        <td><a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
149
                        <td><a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
150
                        </td>
150
                        </td>
151
                        <td>[% IF ( subscription.notes ) %][% subscription.notes %][% END %]
151
                        <td>[% IF ( subscription.publicnotes ) %][% subscription.publicnotes %][% END %]
152
                        [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
152
                        [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
153
                        </td>
153
                        </td>
154
                        <td>
154
                        <td>
155
- 

Return to bug 10689