Funnyclimb
9,90 €/sesión
SELECT TOP 1 precio FROM re_dias WHERE idrecurso IN (SELECT idrecurso from re_recursos WHERE idcentro=4) AND bloqueo='0' AND (fecha=convert(datetime,'10/12/2019',103))
5,4
Softplay
5,40 €/sesión
SELECT TOP 1 precio FROM re_dias WHERE idrecurso IN (SELECT idrecurso from re_recursos WHERE idcentro=8) AND bloqueo='0' AND (fecha=convert(datetime,'10/12/2019',103))
6,4
Jumping
6,40 €/sesión
SELECT TOP 1 precio FROM re_dias WHERE idrecurso IN (SELECT idrecurso from re_recursos WHERE idcentro=18) AND bloqueo='0' AND (fecha=convert(datetime,'10/12/2019',103))
5,4
Climbing
5,40 € entrada diaria