As requested, code that reproduces the problem class Execute { public static void main(args: String []) throws Exception { Session session = getSession(); prepareRepository(session); createNode( new MyValueObject( "1" , "A" , "Title A" , new Date()), session); createNode( new MyValueObject( "2" , "B" , null , new Date()), session); createNode( new MyValueObject( "3" , "B" , "Title B" , new Date()), session); createNode( new MyValueObject( "4" , "C" , "Title C" , new Date()), session); session.save(); session.logout(); Session session2 = getSession(); javax.jcr.query.Query query = session2.getWorkspace().getQueryManager().createQuery( "select * from [namespace:mymixin] as m WHERE m.type = 'B' ORDER BY m.title ASC, m.created ASC" , javax.jcr.query.Query.JCR_SQL2); QueryResult queryResult = query.execute(); System .out.println(queryResult.getRows().getSize()); session2.logout(); } private static void prepareRepository(Session session) throws RepositoryException { session.getWorkspace().getNamespaceRegistry().registerNamespace( "namespace" , "http: //blah.com/blah/blah" ); NodeTypeManager manager= session.getWorkspace().getNodeTypeManager(); NodeTypeTemplate template = manager.createNodeTypeTemplate(); template.setName( "namespace:mymixin" ); template.setQueryable( true ); template.setAbstract( false ); template.setMixin( true ); manager.registerNodeType(template, false ); } private static Node createNode(MyValueObject vo, Session session) throws RepositoryException { final Node node; node = session.getRootNode().addNode(vo.getId()); node.addMixin( "namespace:mymixin" ); node.setProperty( "type" , vo.getType()); Calendar cal = Calendar.getInstance(); cal.setTime(vo.getDate()); node.setProperty( "created" , cal); node.setProperty( "title" , vo.getTitle()); return node; } private static Session getSession() /// Create new jcr session. static class MyValueObject { private final String id; private final String type; private final String title; private final Date date; public MyValueObject( String id, String type, String title, Date date) { this .id = id; this .type = type; this .title = title; this .date = date; } public String getId() { return id; } public String getType() { return type; } public String getTitle() { return title; } public Date getDate() { return date; } } }