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

(-)a/C4/Serials.pm (-3 / +2 lines)
Lines 660-666 sub GetSerials { Link Here
660
        publisheddatetext, planneddate,notes, routingnotes
660
        publisheddatetext, planneddate,notes, routingnotes
661
                        FROM   serial
661
                        FROM   serial
662
                        WHERE  subscriptionid = ? AND status NOT IN ( $statuses )
662
                        WHERE  subscriptionid = ? AND status NOT IN ( $statuses )
663
                        ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC";
663
                        ORDER BY IF(publisheddate IS NULL,planneddate,publisheddate) DESC";
664
    my $sth = $dbh->prepare($query);
664
    my $sth = $dbh->prepare($query);
665
    $sth->execute($subscriptionid);
665
    $sth->execute($subscriptionid);
666
666
Lines 682-688 sub GetSerials { Link Here
682
       FROM     serial
682
       FROM     serial
683
       WHERE    subscriptionid = ?
683
       WHERE    subscriptionid = ?
684
       AND      status IN ( $statuses )
684
       AND      status IN ( $statuses )
685
       ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC
685
       ORDER BY IF(publisheddate IS NULL,planneddate,publisheddate) DESC
686
      ";
686
      ";
687
    $sth = $dbh->prepare($query);
687
    $sth = $dbh->prepare($query);
688
    $sth->execute($subscriptionid);
688
    $sth->execute($subscriptionid);
689
- 

Return to bug 24002