Hinweis
Hallenbad Ebensee
kv pfeil links
kv pfeil rechts
Hallenbad

Hallenbad

SQL: SELECT DISTINCT sa1.name sa1name, sa.name saname, p.name, p.public_description, p.recordid, sa.recordid said, sa1.recordid sa1id FROM `vs_permanent_sportoffer_sportareas` ps INNER JOIN vs_sport_area sa on sa.recordid = ps.sport_areaID INNER JOIN vs_sport_area sa1 on sa1.recordid = sa.superior_areaID INNER JOIN vs_permanent_sportoffer p on p.recordid = ps.permanent_sportofferID WHERE sa.recordid = '47058f0eaaec1bf1a7d5796190c7eb2b' ORDER BY sa1.name, sa.name, p.name
AngebotZeitTrainerSportstätte
Mo. 14:00-22:00Hallenbad Ebensee
Di. 06:00-22:00Hallenbad Ebensee
Mi. 09:00-20:30Hallenbad Ebensee
Do. 06:00-22:00Hallenbad Ebensee
Fr. 09:00-22:00Hallenbad Ebensee
Sa. 08:00-19:00Hallenbad Ebensee
So. 08:00-18:00Hallenbad Ebensee
8b27d59593eb64f0b52b12733f48887d
SELECT u.name, u.weekday,u.time,concat(m.vorname,' ',m.name)trainer, sl.name sportstaette FROM `vs_permanent_sportoffer_unit` u INNER JOIN vs_permanent_sportoffer pso on pso.recordid = u.permanent_sport_offerID LEFT JOIN vs_trainer tr on tr.recordid = u.trainerID LEFT JOIN vs_member m on m.recordid = tr.memberID LEFT JOIN vs_sportlocation sl on sl.recordid = u.sportlocationID WHERE `permanent_sport_offerID` = '8b27d59593eb64f0b52b12733f48887d' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name