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

##</code><code>##

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' )