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)))
  )
m2
WHERE m1.member_id = m2.member_id