Anzeige
Handball665x210
kv pfeil links
kv pfeil rechts
Handball

Handball

Eine familiäre Atmosphäre und ein hochqualifizierter wie engagierter Trainerstab – die Markenzeichen der Post-SV-Handball-Abteilung, die auf diese Weise vor allem im Jugendbereich zu der Adresse in Mittelfranken geworden ist.

 

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 = '489dde05f53b59ffd2ec29bf410a0ebb' ORDER BY sa1.name, sa.name, p.name
AngebotZeitTrainerSportstätte
Di. 18:00-20:00Dennis HandrickGesamtschule Herriedener Straße
Do. 18:30-20:00Dennis HandrickSporthalle TV Eibach 03
Fr. 16:00-18:00Dennis HandrickKopernikus-Schule
c53751f3f59c8e925ee05c45509dc8a7
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` = 'c53751f3f59c8e925ee05c45509dc8a7' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 18:30-20:30Sven KöhlerSigmund Schuckert Gymnasium
Fr. 18:00-20:00Sven KöhlerGesamtschule Herriedener Straße
e14ca0a88717906cb42c7262d23c0c93
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` = 'e14ca0a88717906cb42c7262d23c0c93' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 18:00-20:00Björn WeltzienSigmund Schuckert Gymnasium
Fr. 18:00-20:00Sven KöhlerGesamtschule Herriedener Straße
b05b02309da2f4c4aed342d1bad07a65
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` = 'b05b02309da2f4c4aed342d1bad07a65' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 16:45-18:15Steve SchlosserSporthalle TV Eibach 03
Mi. 18:00-20:00Steve SchlosserGesamtschule Herriedener Straße
Do. 17:00-18:30Steve SchlosserTheodor-Billroth-Schule
992cede847aad40e1201b8a3afdc8e85
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` = '992cede847aad40e1201b8a3afdc8e85' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 20:00-22:00Sebastian GernerGesamtschule Herriedener Straße
Mi. 19:00-21:00Sebastian GernerGeschwister-Scholl-Realschule
Do. 18:00-20:00Sebastian GernerGeschwister-Scholl-Realschule
08457b5ff06564481f2455c1adad6fd5
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` = '08457b5ff06564481f2455c1adad6fd5' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 20:00-22:00Sebastian GernerGesamtschule Herriedener Straße
Mi. 18:30-20:30Sebastian GernerGeschwister-Scholl-Realschule
1a8600bc41598a4241e377c8072fce2f
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` = '1a8600bc41598a4241e377c8072fce2f' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Do. 16:15-17:30Kevin KöhlerTheodor-Billroth-Schule
e654b7dcfb5ad5e5b637c988bfc892eb
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` = 'e654b7dcfb5ad5e5b637c988bfc892eb' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 20:00-22:00Stefan HandrickGesamtschule Herriedener Straße
Do. 20:00-22:00Stefan HandrickSportpark Schweinau
f52e706be0c17df6673391a7f5c7814b
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` = 'f52e706be0c17df6673391a7f5c7814b' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mi. 20:00-22:00Ahmet DereliGesamtschule Herriedener Straße
76b455d9fb9e1d814007ee9ecc1b039d
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` = '76b455d9fb9e1d814007ee9ecc1b039d' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Fr. 18:30-22:00Ahmet DereliRöthenbach Ost
efd71d7b0fd9e79cc8dfbd9f96564f5e
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` = 'efd71d7b0fd9e79cc8dfbd9f96564f5e' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
ab 4 JahrenDo. 15.00-16.15Kevin KöhlerTheodor-Billroth-Schule
29a750edda88bfa7a2cda9416ee75813
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` = '29a750edda88bfa7a2cda9416ee75813' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name