my $query = <<"ESQL";
SELECT * FROM $table
    WHERE $description_field LIKE '%$search_term%'
      and $start_time_field between ? and ?
      or $end_time_field between ? and ?
ESQL