my %where = (
    status => ['Offered','Denied','Cancelled','Conditional Offer'],
    sent_email => { '!=' => [ -and => undef, '0000-00-00' ] },
);