-or =>[ status => 'Review' ,  
    -and => [ 
       -or => [
         status => 'Offered',
         status => 'Denied',
         status => 'Cancelled',
         status => 'Conditional Offer',
       ],
       sent_email => {'!=', undef },
       sent_email => {'!=', '0000-00-00'},
     ],
   ],