select count(email)
from parties where upper(email) = :upper_email
and party_id <> :user_id
select count(email)
from parties where upper(email) = :upper_email
and party_id <> :user_id
select count(email)
from parties where upper(email) = :upper_email
and party_id <> :user_id