diff options
-rw-r--r-- | FS/bin/freeside-torrus-srvderive | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive index 9ecfbbc72..ce47414a6 100644 --- a/FS/bin/freeside-torrus-srvderive +++ b/FS/bin/freeside-torrus-srvderive @@ -48,6 +48,7 @@ my $sql = " WHERE NOT EXISTS ( SELECT 1 FROM srvexport AS other WHERE other.serviceid IN ( $in, $out ) + AND srvexport.srv_date = other.srv_date AND ABS( $_date - $other_date ) <= 60 ) ORDER BY srv_date, srv_time |