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

(-)a/C4/Serials.pm (-2 / +1 lines)
Lines 1884-1890 sub check_routing { Link Here
1884
    my $sth              = $dbh->prepare(
1884
    my $sth              = $dbh->prepare(
1885
        "SELECT count(routingid) routingids FROM subscription LEFT JOIN subscriptionroutinglist 
1885
        "SELECT count(routingid) routingids FROM subscription LEFT JOIN subscriptionroutinglist 
1886
                              ON subscription.subscriptionid = subscriptionroutinglist.subscriptionid
1886
                              ON subscription.subscriptionid = subscriptionroutinglist.subscriptionid
1887
                              WHERE subscription.subscriptionid = ? ORDER BY ranking ASC
1887
                              WHERE subscription.subscriptionid = ? GROUP BY routingid ORDER BY ranking ASC
1888
                              "
1888
                              "
1889
    );
1889
    );
1890
    $sth->execute($subscriptionid);
1890
    $sth->execute($subscriptionid);
1891
- 

Return to bug 22812