SELECT nomemodulo,parcolungo,parcobreve FROM dbparks, gestori WHERE dbparks.codiceAP = 'RMRIZ' AND gestori.gestoriID = dbparks.gestoriID