createQueryBuilder('c') ->innerJoin('c.film', 'flm')->addSelect('flm') ->innerJoin('c.user', 'usr')->addSelect('usr') ->setMaxResults($limit) ->orderBy('c.id', 'DESC') ->getQuery() ->getResult(); } }