[xwiki-users] hibernate query question

Hi guys, what is wrong here: --snip-- select prop.value from BaseObject as obj, StringProperty as prop, StringProperty as prop2, where obj.className='XWiki.ServicesReviewerClass' and prop.id.id=obj.id and prop2.id.id=obj.id and prop.id.name='name' and prop2.id.name='externintern' and prop2.value='intern' order by prop.value --snap-- I'm using this for a database list field in a class. I want to list all objects by the name property, but only those, where property "externintern" is set to extern (static list). Many thanx in advance. Cheers Sebastian