Anzeige
Wasserball665x210
kv pfeil links
kv pfeil rechts
Wasserball

Wasserball

Wasserball ist ein Ballspiel im Wasser, bei dem die Spieler zweier Mannschaften versuchen, durch geschicktes Abspielen und Freischwimmen den Ball in das gegnerische Tor zu werfen. Ziel des Spieles ist es, mehr Tore als die gegnerische Mannschaft zu erzielen. Die Mannschaft mit den meisten anerkannten Toren ist der Sieger.

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 = 'd61f3a760c9bcbc9bb75228deddd9379' ORDER BY sa1.name, sa.name, p.name
AngebotZeitTrainerSportstätte
Freies TrainingMi. 6:00 - 7:30Hallenbad Langwasser
Freies TrainingFr. 15:00-16:30Hallenbad Langwasser
Freies TrainingSa. 6:30-8:00Hallenbad Langwasser
442430d1c45ede7cb479cc7434f6629e
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` = '442430d1c45ede7cb479cc7434f6629e' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball Herren Mo. 20:00-22:00Hallenbad Langwasser
Wasserball Herren Mi. 20:30-22:00Marc SteinbergerHallenbad Langwasser
be925cdb6f03c1b58212df4c2831aedd
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` = 'be925cdb6f03c1b58212df4c2831aedd' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Junioren (13-17)Mi. 17:30-19:00Hallenbad Langwasser
Junioren (13-17)Fr. 20:00-22:00Hallenbad Langwasser
Junioren(13-17)Sa. 17:00-19:00Hallenbad Langwasser
1b7c6426684afa00c917e3006b05202a
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` = '1b7c6426684afa00c917e3006b05202a' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball U10Mo. 18:30-20:00Hallenbad Langwasser
Wasserball U10Mi. 17:30-19:00Hallenbad Langwasser
Wasserball U10Sa. 17:00-18:30Hallenbad Langwasser
d2e2e4e5476e75f771d6445eef50b134
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` = 'd2e2e4e5476e75f771d6445eef50b134' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball U12Mo. 19.00-20.45Schwimmbad Bereitschaftspolizei Nürnberg
Wasserball U12Mi. 15:00-17:30Hallenbad Langwasser
Wasserball U12Do. 18:45-20:45Marc SteinbergerSchwimmbad Bereitschaftspolizei Nürnberg
Wasserball U12Fr. 15:00-16:30Marc SteinbergerHallenbad Langwasser
Wasserball U12Fr. 19:30-21:30Hallenbad Langwasser
Wasserball U12Sa. 17:00-19:00Marc SteinbergerHallenbad Langwasser
757eaa74c03af8ec29203a6a0c3457aa
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` = '757eaa74c03af8ec29203a6a0c3457aa' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball U14Mo. 19:00-20:45Marc SteinbergerSchwimmbad Bereitschaftspolizei Nürnberg
Wasserball U14Mi. 15:00-17:30Hallenbad Langwasser
Wasserball U14Do. 18:45-21:00Marc SteinbergerSchwimmbad Bereitschaftspolizei Nürnberg
Wasserball U14Fr. 20:00-22:00Marc SteinbergerHallenbad Langwasser
Wasserball U14Sa. 17.00-19:00Marc SteinbergerHallenbad Langwasser
301d01984fa7dce86bab6d4d613b6678
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` = '301d01984fa7dce86bab6d4d613b6678' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball U16Mo. 20:00-21:30Marc SteinbergerHallenbad Langwasser
Wasserball U16Mi. 15:00-17:30Hallenbad Langwasser
Wasserball U16Do. 18:45-21:00Marc SteinbergerSchwimmbad Bereitschaftspolizei Nürnberg
Wasserball U16Fr. 20:00-22:00Marc SteinbergerHallenbad Langwasser
Wasserball U16Sa. 17:00-19:00Marc SteinbergerHallenbad Langwasser
b50a2d5cb97432f08ef7523ec1d9f0ad
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` = 'b50a2d5cb97432f08ef7523ec1d9f0ad' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball U18Mo. 20:00-22:00Marc SteinbergerHallenbad Langwasser
Wasserball U18Mi. 22:00-22:00Marc SteinbergerHallenbad Langwasser
Wasserball U18Fr. 15:00-16:30Marc SteinbergerHallenbad Langwasser
Wasserball U18Sa. 06:30-08:00Marc SteinbergerHallenbad Langwasser
6a1f56ff54a7c3189d9904cb4918460d
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` = '6a1f56ff54a7c3189d9904cb4918460d' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Wasserball U8Fr. 14:00-15:00Hallenbad Langwasser
e71761235e978b5decb741daeac10e8d
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` = 'e71761235e978b5decb741daeac10e8d' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name