From 50a44fc4185bb62fdf2a405cb0dfafe782824362 Mon Sep 17 00:00:00 2001 From: Simon Green Date: Tue, 3 Dec 2013 08:44:46 +1000 Subject: Bug 944583 - sendunsentbugmail.pl has bad SQL r=glob, a=sgreen --- contrib/sendunsentbugmail.pl | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'contrib') diff --git a/contrib/sendunsentbugmail.pl b/contrib/sendunsentbugmail.pl index 536d12146..474554135 100755 --- a/contrib/sendunsentbugmail.pl +++ b/contrib/sendunsentbugmail.pl @@ -17,10 +17,9 @@ use Bugzilla::BugMail; my $dbh = Bugzilla->dbh; my $list = $dbh->selectcol_arrayref( - 'SELECT bug_id FROM bugs - WHERE lastdiffed IS NULL - OR lastdiffed < delta_ts - AND delta_ts < ' + 'SELECT bug_id FROM bugs + WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts) + AND delta_ts < ' . $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE') . ' ORDER BY bug_id'); -- cgit v1.2.3-24-g4f1b