WHERE ( sent_email IS NOT NULL OR 
        sent_email != '0000-00-00' ) AND 
      ( status = 'Offer' OR 
        status = 'Declined' OR 
        status = 'Cancelled' OR 
        status = 'Conditional Offer' )