WHERE status='Review' OR
              ( ( status='Offered' OR
                   status='Denied' OR
                   status='Cancelled' OR
                   status='Conditional Offer') AND
                 ( sent_email is NULL OR
                   sent_email='0000-00-00')
             )