Budosport3 665x210
kv pfeil links
kv pfeil rechts
Budo

Budosport/Kampfkünste

Budo (japanischer Ausdruck für: Weg des Krieges) ist der Oberbegriff für alle japanischen Kampfkünste, also Ju-Jutsu, Judo, Karate, Aikido, Kendo, usw., die – im Gegensatz zu den traditionellen Bujutsu-Kriegskünsten – außer der Kampftechnik noch eine „innere“ Do-Lehre oder auch Philosophie enthalten. Der Begriff Do bezeichnet dabei einen individuellen Weg zur Erkenntnis. In dessen Zentrum steht eine Übung, deren Ziel jedoch nicht das Erlernen irgendeiner Fertigkeit, sondern das Erweitern des im Menschen liegenden Potenzials ist. Dadurch kann er zu seiner Sinnbestimmung wachsen und sein Leben mit Bewusstsein und Erkenntnis erfüllen.

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 = '49d67d53aeb86e49d4de15a9d2cfb0e5' ORDER BY sa1.name, sa.name, p.name
AngebotZeitTrainerSportstätte
Mi. 19:30-21:00Horst HahnSportzentrum Nordost
14895e9c83053104a635a8be68fd0b8c
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` = '14895e9c83053104a635a8be68fd0b8c' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mi. 21:00-22:00Horst HahnSportzentrum Nordost
Do. 20:15-22:00Anton Diringer-FeyrerGebrüder-Grimm-Schule
13727a6a8345c937670b671a1f6f313a
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` = '13727a6a8345c937670b671a1f6f313a' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
nach Absprache mit dem TrainerFr. 20:30-22:00Horst HahnVereinshalle Hasenbuck
4b5e2dad1aaea05fb70906d95bf4295c
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` = '4b5e2dad1aaea05fb70906d95bf4295c' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name

Themen siehe Abteilungshomepage

AngebotZeitTrainerSportstätte
Do. 18:15-19:45Alexander KöhlerSportzentrum Nordost
eb0700925102789f92551f4e03740e02
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` = 'eb0700925102789f92551f4e03740e02' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 18:30-20:00Dietmar OrtSportzentrum Nordost
Mi. 18:45-20:15Dietmar OrtSportzentrum Nordost
72c4a0d8bbe3fdb6ca750cf50671f03a
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` = '72c4a0d8bbe3fdb6ca750cf50671f03a' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 19:00-20:30Alexander KöhlerSportzentrum Nordost
Fr. 18:45-20:15Christoph LackSportzentrum Nordost
505390585d7a8e34a15b33a2994942f4
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` = '505390585d7a8e34a15b33a2994942f4' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 17:30-19:00Matthias GreßmannSportzentrum Nordost
Mi. 20:15-21:45Matthias GreßmannSportzentrum Nordost
98f242e5ddc10fd4d0eaf738ee59407a
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` = '98f242e5ddc10fd4d0eaf738ee59407a' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 19:00-20:30Peter RössSportzentrum Nordost
Mi. 18:45-20:15Peter RössSportzentrum Nordost
ca75de9a5fde50bc6a0ba910b1b1d908
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` = 'ca75de9a5fde50bc6a0ba910b1b1d908' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
14-tägigFr. 18:30-20:00Jürgen SchallerSportzentrum Nordost
5b2f91eda2aee3980052365e828986cc
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` = '5b2f91eda2aee3980052365e828986cc' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Do. 18:15-19:45Alexander KöhlerSportzentrum Nordost
f211cc963a0e4ec9f3c9b1bd4a985418
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` = 'f211cc963a0e4ec9f3c9b1bd4a985418' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Fr. 18:30-20:00Ahmedin GegicSportzentrum Nordost
a754051f06e802afe5daf552c86c9017
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` = 'a754051f06e802afe5daf552c86c9017' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 18:30-20:00Felix DomhöverSportzentrum Nordost
Do. 18:15-19:45Bernd HöherSportzentrum Nordost
8d4d8063febc840aebfb960758e5aeed
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` = '8d4d8063febc840aebfb960758e5aeed' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 17:00-18:30Ahmedin GegicSportzentrum Nordost
Do. 18:15-19:45Bernd HöherSportzentrum Nordost
9b0e182ca0eb4fa7e7e5958418aa8208
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` = '9b0e182ca0eb4fa7e7e5958418aa8208' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 19:00-20:30Sportzentrum Nordost
nach vorheriger AbspracheMo. 20:30-22:00Sportzentrum Nordost
Do. 18:15-20:30Alexander KöhlerSportzentrum Nordost
Fr. 20.00-21.30Sportzentrum Nordost
9f057b46713528b1c695484fc412e1cf
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` = '9f057b46713528b1c695484fc412e1cf' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name

Teilnahme erst ab dem Ju-Jutsu Gelbgurt und nach vorheriger Zustimmung des Trainers möglich.

AngebotZeitTrainerSportstätte
Fr. 20:15-21:45Friedrich KleinSportzentrum Nordost
8bb136fd832b36830cb250e66c169811
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` = '8bb136fd832b36830cb250e66c169811' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 19:00-20:30Karl-Heinz ZeitlerSportzentrum Nordost
3f66b79643c639e89c2aae4ea25946bf
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` = '3f66b79643c639e89c2aae4ea25946bf' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name

In unseren Übungs- und Trainingsstunden wo im Rahmen der Trainingseinheiten mit dem Erlernen von Techniken sowie der Vermittlung von Judowerten– u.a. Wertschätzung, Respekt, Mut, Selbstbeherrschung, Höflichkeit, Bescheidenheit – gelebt wird, sind Anfänger aller Altersklassen für die Sportart Judo gerne willkommen! Es sind noch Plätze frei!

AngebotZeitTrainerSportstätte
Di. 18:30-20:00Stephan StägeVereinshalle Hasenbuck
Do. 18:30-20:00Gernot NeuschröerVereinshalle Hasenbuck
69d35b97892dbba68ed1f50426796832
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` = '69d35b97892dbba68ed1f50426796832' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 17:00-18:30Matthias WackerVereinshalle Hasenbuck
Do. 17:00-18:30Johannes GerickeVereinshalle Hasenbuck
d7fc7f4fec81c2ef6db081698bf07846
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` = 'd7fc7f4fec81c2ef6db081698bf07846' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name

In unseren Übungs- und Trainingsstunden wo im Rahmen der Trainingseinheiten mit dem Erlernen von Techniken sowie der Vermittlung von Judowerten– u.a. Wertschätzung, Respekt, Mut, Selbstbeherrschung, Höflichkeit, Bescheidenheit – gelebt wird, sind Anfänger aller Altersklassen für die Sportart Judo gerne willkommen! Es sind noch Plätze frei!

Der neue Anfängerkurs hat bereits begonnen. Ein Schnuppertraining ist jederzeit möglich!

AngebotZeitTrainerSportstätte
Mo. 17:30-19:15Susanne MeiselVereinshalle Hasenbuck
9f2df8e8663790ab3ee45e4facc17908
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` = '9f2df8e8663790ab3ee45e4facc17908' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
So. 10:00-11:30Karl-Heinz FiedlerSportpark Ebensee
ba407823001de5c01a9beb1ced6a6521
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` = 'ba407823001de5c01a9beb1ced6a6521' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 20:00-21:30Ingo KurzweilVereinshalle Hasenbuck
Do. 20:00-21:30Steffen KühnrichVereinshalle Hasenbuck
4f5d25e8a1869d43356bfd165f4fb256
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` = '4f5d25e8a1869d43356bfd165f4fb256' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name

Es ist ein Spiel für Kinder, weil viele Griffe und Würfe, Angriffstechniken und Abwehrreaktionen spielerisch erlernt werden. Lehrt Kinder Konflikte fair zu lösen, Grenzen anzuerkennen und aufzuhören wenn jemand „am Boden ist“. Ist ein Wettkampfsport für Jugendliche und Erwachsene, die im fairen Zweikampf nach festen Regeln ihre Kräfte messen wollen. Fördert die Entwicklung der menschlichen Persönlichkeit durch Ausübung eines ganzheitlichen „Körper – Seele – Geist“ Weges. Judo ist eine Sportart für
jedes Körpermaß. Ob groß oder klein, dick oder dünn- durch die Vielfalt an Techniken findet jeder seine eigene Spezialtechnik.

Alle Teilnehmer müssen Vereinsmitglieder sein!

AngebotZeitTrainerSportstätte
Do. 15:30-16:15Susanne MeiselVereinshalle Hasenbuck
Do. 16:15-17:00Susanne MeiselVereinshalle Hasenbuck
e06b1d46158a43b35638722303b916be
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` = 'e06b1d46158a43b35638722303b916be' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 19:00-21:00Bernd HeubeckSportzentrum Süd
19beefa9fef3e751fed5ad3da295d38a
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` = '19beefa9fef3e751fed5ad3da295d38a' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Fortgeschrittene ab DanMo. 19:30-21:30Stefan GrötschSportzentrum Süd
Anfänger & UnterstufeMi. 19:00-21:00Stefan GrötschSportzentrum Süd
FortgeschritteneDo. 19:30-21:00Thomas Halva LabellaWillstätter Gymnasium
e6c5803498e62cb0ef3bfe44c72c57d6
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` = 'e6c5803498e62cb0ef3bfe44c72c57d6' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Anfänger und UnterstufeMo. 18:00-19:30Daniela LabellaSportzentrum Süd
Anfänger & FortgeschritteneDo. 18:00-19:30Mario ProussasWillstätter Gymnasium
09fc33e53018e6c214db6da7f89b2ea2
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` = '09fc33e53018e6c214db6da7f89b2ea2' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name