Untitled

Doctrine2: left join WITH not working
$query = $this->getEntityManager()->createQuery("
            SELECT a, MIN(l.price) as minPrice, MAX(l.price) as maxPrice
                    FROM TechforgeApartmentBundle:ApFloor a
                    LEFT JOIN a.leases l
                    LEFT JOIN a.exemptions x WITH x.id = 3
                    WHERE a.apartment = ?1
                    GROUP BY a.id");

LEFT JOIN exemption_period e2_ ON a0_.id = e2_.ap_floor_id
AND (
3 = e2_.id
)