SELECT count(m1.email)FROM someClient_member m1, (( (SELECT someClient_member.member_id FROM someClient_member, someClient_report sp_rc WHERE sp_rc.campagne_id IN (SELECT campagne_id FROM campagne WHERE message_id = 939277) AND someClient_member.member_id = sp_rc.member_id(+) AND sp_rc.member_id IS NULL AND((someClient_member.typeclient NOT LIKE '%prospect%' OR someClient_member.typeclient IS NULL) AND(someClient_member.typeclient NOT LIKE '%web agence%' OR someClient_member.typeclient IS NULL) AND(someClient_member.typeclient NOT LIKE '%paunitSL%' OR someClient_member.typeclient IS NULL) AND(someClient_member.typeclient NOT LIKE '%usage interne%' OR someClient_member.typeclient IS NULL) AND(someClient_member.typeclient NOT LIKE '%Un particulier%' OR someClient_member.typeclient IS NULL) AND(someClient_member.typeclient NOT LIKE '%Agent immobilier%' OR someClient_member.typeclient IS NULL)) AND(someClient_member.dateunjoin IS NULL AND someClient_member.emvhbq IS NULL))) )m2WHERE m1.member_id = m2.member_id