$sql = qq~SELECT * FROM event_topic 
  WHERE time BETWEEN '$time' AND '$etime' 
  AND (~
  . join ...