Kendo

Der Weg des Schwertes, oder kurz Kendo, hat seinen Ursprung in traditionellen japanischen Schwerttechniken, die wiederum Fitness und die Entwicklung der Persönlichkeit fördern. Ziel ist es, Anfänger in diese Sportart einzuführen, Fortgeschrittene vor immer neue Herausforderungen zu stellen und dabei ein Verständnis für den Geist von Kendo zu vermitteln.
Anfänger sind zu jeder Trainingseinheit herzlich willkommen.

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 = 'f8f656b73252c75518351df0289a43cc' ORDER BY sa1.name, sa.name, p.name
AngebotZeitTrainerSportstätte
Di. 20:00-22:00Takako InagakiWiesenschule
603effb477d4cf3d69dfce539d71d13a
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` = '603effb477d4cf3d69dfce539d71d13a' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Fr. 20:30-22:00Heiko MehldauSportzentrum Süd
7123bc005259d855df5c603f2f54c908
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` = '7123bc005259d855df5c603f2f54c908' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Sa. 10:30-12:15Takako InagakiVereinshalle Hasenbuck
f13b90a328a74225058779710e5a628c
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` = 'f13b90a328a74225058779710e5a628c' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name