Hibernate 3 existe alguma maneira de dizer que os relacionamento TCLIENTES é a mesa tabela invés de repedir 4 vezes, por causa do relacionamento ?
select
count(*) as y0_
from
TCLIENTES this_,
TESTABELECIMENTOS estabeleci1_,
TEST_REP representa5_,
TREPRESENTANTES rep8_,
TEMP_CLI empresacli6_,
TCLIENTES cliemp2x7_,
TEMP_EST empresaest2_,
TEMP_CLI empresacli3_,
TCLIENTES cliemp1x4_,
TEMP_CLI clienteemp9_,
TEMPRESAS empremp11_,
TCLIENTES cliemp10_
where
this_.id=estabeleci1_.CLI_ID
and estabeleci1_.id=representa5_.EST_ID
and representa5_.REP_ID=rep8_.id
and representa5_.EMPCLI_ID=empresacli6_.id
and empresacli6_.CLI_ID=cliemp2x7_.id
and estabeleci1_.id=empresaest2_.EST_ID
and empresaest2_.EMPCLI_ID=empresacli3_.id
and empresacli3_.CLI_ID=cliemp1x4_.id
and this_.id=clienteemp9_.CLI_ID
and clienteemp9_.EMPR_ID=empremp11_.id
and clienteemp9_.CLI_ID=cliemp10_.id
and empresaest2_.ativo=1
and cliemp1x4_.id=this_.id
and cliemp2x7_.id=this_.id
and rep8_.id=567
and clienteemp9_.ativo=1
and cliemp10_.id=this_.id
and clienteemp9_.id=empresacli3_.id
and clienteemp9_.id=empresacli6_.id
and empresacli3_.id=empresacli6_.id
and empremp11_.id=10