diff options
-rwxr-xr-x | bin/send-comments | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/bin/send-comments b/bin/send-comments index acd32d53a..1bd68e916 100755 --- a/bin/send-comments +++ b/bin/send-comments @@ -44,6 +44,8 @@ while ( my $council = $councils->next ) { my $comments = FixMyStreet::App->model('DB::Comment')->search( { 'me.whensent' => undef, 'me.external_id' => undef, + 'state' => 'confirmed', + 'confirmed' => { '!=' => undef }, 'problem.whensent' => { '!=' => undef }, 'problem.external_id' => { '!=' => undef }, 'problem.council' => { -like => '%' . $council->area_id .'%' }, |