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,'16/10/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,'16/10/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,'16/10/2019',103))
5,4
Climbing
5,40 € entrada diaria
SELECT TOP 1 precio FROM re_dias WHERE idrecurso IN (SELECT idrecurso from re_recursos WHERE idcentro=36) AND bloqueo='0' AND (fecha=convert(datetime,'16/10/2019',103))
0
Fiesta de Halloween - 31 Octubre
12,90 €/sesión
