public function findByStateId($id) { $reviewed = City::REVIEWED_OK; return $this->repository->createQueryBuilder('c')->join('c.state', 's')->where('s.id = :id')->andWhere('c.reviewed = :reviewed')->orderBy('c.name')->setParameters(compact('id', 'reviewed'))->getQuery()->getResult(); }