lds as annotationField left outer join item.contentFields as bodyField left oute
r join titleField.contentFieldValues as title left outer join annotationField.co
ntentFieldValues as annotation left outer join bodyField.contentFieldValues as b
ody left outer join item.roles as role where titleField.identifier = 'title' and
annotationField.identifier = 'annotation' and bodyField.identifier = 'body' and
title.contentLocale = annotation.contentLocale and title.contentLocale = body.c
ontentLocale and title.contentLocale.identifier = ? order by item.publicationDa
te desc, title.simpleValue asc
对应的SQL：
Hibernate: select distinct newsitem0_.page_id as id, newsitem0_.publication_date
as publicat2_11_, newsitem0__1_.uri as uri6_, newsitem0__1_.usage_counter as us
age_co3_6_, newsitem0__1_.active as active6_, newsitem0__2_.version as version0_
, newsitem0__2_.class_name as class_name0_, newsitem0_.page_id as x0_0_, content
fie4_.simple_value as x1_0_, contentfie5_.value as x2_0_ from news_item newsitem
0_ inner join page newsitem0__1_ on newsitem0_.page_id=newsitem0__1_.localizable
_id inner join localizable newsitem0__2_ on newsitem0_.page_id=newsitem0__2_.id
left outer join field contentfie1_ on newsitem0_.page_id=contentfie1_.localizabl
e_id left outer join field contentfie2_ on newsitem0_.page_id=contentfie2_.local
izable_id left outer join field contentfie3_ on newsitem0_.page_id=contentfie3_.
localizable_id left outer join field_value contentfie4_ on contentfie1_.id=conte
ntfie4_.field_id left outer join field_value contentfie5_ on contentfie2_.id=con
tentfie5_.field_id left outer join field_value contentfie6_ on contentfie3_.id=c
ontentfie6_.field_id left outer join page_role roles7_ on newsitem0_.page_id=rol
es7_.page_id left outer join role role8_ on roles7_.rolename=role8_.rolename
