$sth = $dbh->prepare( "
 SELECT  
   ## long complicated WHERE stuff
  " ) || die "Error: " . $dbh->errstr;

  $sth->execute() || die "Error: " . $dbh->errstr;    
  if( $sth->rows > 0 ){
     ## print out some results
  }