public function findChildren($parentCode)
{
$queryBuilder = $this->createQueryBuilder('o');
$queryBuilder->addSelect('translation')->leftJoin('o.translations', 'translation')->addSelect('child')->leftJoin('o.children', 'child')->leftJoin('o.parent', 'parent')->andWhere('parent.code = :parentCode')->addOrderBy('o.position')->setParameter('parentCode', $parentCode);
return $queryBuilder->getQuery()->getResult();
}