I read this example: http://xwiki.markmail.org/message/e2mi4odgpucsd3cu #set ($hql ="select distinct doc.fullName, otherprop.value, doc.creationDate from XWikiDocument as doc, BaseObject as obj, StringProperty otherprop, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName  and obj.className='Blog.BlogPostClass' and obj.id=prop.id.id and prop.id.name='category' and list='Blog.Autres' and obj.id=otherprop.id.id and otherprop.id.name='title' order by doc.creationDate  desc") (must try with category property now)