Restricting a JOIN clause by additional conditions:
    $query = $em->createQuery("SELECT u FROM CmsUser u LEFT JOIN u.articles a WITH a.topic LIKE :foo");
    $query->setParameter('foo', '%foo%');
    $users = $query->getResult();