$query = $this->createQueryBuilder('o');
$query->select('o');
$query->leftJoin(Pais::class, 'p', 'with', 'o.idPais = p.id');
$query->leftJoin( Contrato::class, 'c', 'with', 'o.idTipoContrato = c.id');
$query->andWhere('p.nombreCorto = :pais');
$query->andWhere('o.activa = 1');
$query->andWhere('o.eliminado is NULL');
$query->andWhere('o.caducidad > :hoy');
$query->setParameter('pais', $pais)->setParameter('hoy', new DateTime());

return $query->getQuery()->getArrayResult();

/**
 * @var ApplicationEntityPais
 *
 * @ORMManyToOne(targetEntity="ApplicationEntityPais")
 * @ORMJoinColumns({
 *   @ORMJoinColumn(name="id_pais", referencedColumnName="id", nullable=true)
 * })
 */
private $idPais;


/**
 * @var ApplicationEntityTipoContrato
 *
 * @ORMManyToOne(targetEntity="ApplicationEntityTipoContrato")
 * @ORMJoinColumns({
 *   @ORMJoinColumn(name="id_tipo_contrato", referencedColumnName="id", nullable=true)
 * })
 */
private $idTipoContrato;