biblio.author,

            biblio.author,

            biblio.biblionumber,

            biblio.biblionumber,

            aqbooksellers.name AS vendorname,

            aqbooksellers.name AS vendorname,

        FROM subscription

        FROM subscription

            LEFT JOIN subscriptionhistory USING(subscriptionid)

            LEFT JOIN subscriptionhistory USING(subscriptionid)

            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber

            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber

            LEFT JOIN biblioitems ON biblioitems.biblionumber = subscription.biblionumber

            LEFT JOIN biblioitems ON biblioitems.biblionumber = subscription.biblionumber

            LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id

            LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id

    |;

    |;

    $query .= q| WHERE 1|;

    $query .= q| WHERE 1|;

    my @where_strs;

    my @where_strs;

my @subs;

my @subs;

foreach my $subscription (@subscriptions) {

foreach my $subscription (@subscriptions) {

    my %cell;

    my %cell;

    my $serials_to_display;

    my $serials_to_display;

    $cell{subscriptionid}    = $subscription->{subscriptionid};

    $cell{subscriptionid}    = $subscription->{subscriptionid};

    $cell{callnumber}        = $subscription->{callnumber};

    $cell{callnumber}        = $subscription->{callnumber};

    $cell{location}          = $subscription->{location};

    $cell{location}          = $subscription->{location};

    $cell{closed}            = $subscription->{closed};

    $cell{closed}            = $subscription->{closed};

    #get the three latest serials.

    #get the three latest serials.

    $serials_to_display = $subscription->{staffdisplaycount};

    $serials_to_display = $subscription->{staffdisplaycount};

    $serials_to_display = C4::Context->preference('StaffSerialIssueDisplayCount') unless $serials_to_display;

    $serials_to_display = C4::Context->preference('StaffSerialIssueDisplayCount') unless $serials_to_display;

                    <th>Date arrived</th>

                    <th>Date arrived</th>

                    <th>Date published</th>

                    <th>Date published</th>

                    <th>Status</th>

                    <th>Status</th>

                    <th>Note</th>

                    <th>Note</th>

                </tr>

                </tr>

            [% FOREACH latestserial IN subscription.latestserials %]

            [% FOREACH latestserial IN subscription.latestserials %]

                      [% IF ( latestserial.status7 ) %]Claimed[% END %]

                      [% IF ( latestserial.status7 ) %]Claimed[% END %]

                      [% IF ( latestserial.status8 ) %]Stopped[% END %]

                      [% IF ( latestserial.status8 ) %]Stopped[% END %]

                    </td>

                    </td>

                    <td>[% latestserial.notes | html %]</td>

                    <td>[% latestserial.notes | html %]</td>

                </tr>

                </tr>

            [% END %]

            [% END %]