Hibernate:
select
entitya0_.ID as id1_0_,
entitya0_.ENTITY_B as entity_b2_0_
from
ENTITY_A entitya0_
inner join
ENTITY_B entityb1_
on entitya0_.ENTITY_B=entityb1_.ID
where
0<(
select
count(*)
from
REFERENCED_ENTITY referenced2_
where
referenced2_.foo=1
and referenced2_.ID=entityb1_.REF_NUMBER
)