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

(-)a/C4/Serials.pm (-2 / +1 lines)
Lines 96-102 sub GetSuppliersWithLateIssues { Link Here
96
    FROM            subscription
96
    FROM            subscription
97
    LEFT JOIN       serial ON serial.subscriptionid=subscription.subscriptionid
97
    LEFT JOIN       serial ON serial.subscriptionid=subscription.subscriptionid
98
    LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
98
    LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
99
    WHERE  (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
99
    WHERE id > 0 AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
100
    return $dbh->selectall_arrayref($query, { Slice => {} });
100
    return $dbh->selectall_arrayref($query, { Slice => {} });
101
}
101
}
102
102
103
- 

Return to bug 4507