kv pfeil links
kv pfeil rechts
Turnen

Turnen

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 = '388a513a9cf7a2873844b2d60d57eb8d' ORDER BY sa1.name, sa.name, p.name
AngebotZeitTrainerSportstätte
Mo. 16:00-17:00Heinz SchusterSportzentrum Süd
Mo. 17:00-18:00Heinz SchusterSportzentrum Süd
efd695c101bfd8e1781a7510dd8253c1
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` = 'efd695c101bfd8e1781a7510dd8253c1' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 17:00-18:00Harald PitschGrundschule St. Johannis
Di. 17:45-18:45Harald PitschGrundschule Paniersplatz
Mi. 16:00-18:00Harald PitschBirkenwald-Schule
Do. 17:45-18:45Harald PitschHolzgartenschule
Fr. 18:00-19:30Harald PitschTheodor-Billroth-Schule
2012404bdac2a3093b16a03a7caabab4
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` = '2012404bdac2a3093b16a03a7caabab4' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Do. 16:15-18:00Heinz SchusterSportzentrum Süd
Fr. 17:00-18:30Heinz SchusterMittelschule Hummelsteiner Weg
7e63f4f6314c09ff69eb4eda93e57fb3
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` = '7e63f4f6314c09ff69eb4eda93e57fb3' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Gruppe 1Mo. 14:00-15:00Elvira YabrovaSportzentrum Süd
Gruppe 2Mo. 15:00-16:00Elvira YabrovaSportzentrum Süd
531d2e0f8cdf9efe866a8a238688d686
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` = '531d2e0f8cdf9efe866a8a238688d686' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Gruppe 1Mo. 16:00-17:00Elvira YabrovaSportzentrum Süd
Gruppe 2Mo. 17:00-18:00Elvira YabrovaSportzentrum Süd
8e2d8074bfb500cfc2cff8dd4a8dfc0b
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` = '8e2d8074bfb500cfc2cff8dd4a8dfc0b' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 14:30-15:30Elvira YabrovaSportzentrum Süd
ee8a94dc58edb768e9116677f16ffcf2
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` = 'ee8a94dc58edb768e9116677f16ffcf2' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Sa. 10:00-11:30Yvonne HüllweberSportzentrum Süd
2cbc1892e1c7fed9cb4ec8adb3f5cfa7
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` = '2cbc1892e1c7fed9cb4ec8adb3f5cfa7' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Fr. 15:00-16:30Elvira YabrovaDürer-Gymnasium
03da7ad267ef3d61ce133d6c12f67140
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` = '03da7ad267ef3d61ce133d6c12f67140' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Di. 14:30-15:30Elvira YabrovaSportzentrum Süd
Di. 15:30-16:30Elvira YabrovaSportzentrum Süd
4d41eb1fed1e50de1bde0cfd140e4a86
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` = '4d41eb1fed1e50de1bde0cfd140e4a86' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
Mo. 18:00-19:00Elvira YabrovaSportzentrum Süd
Sa. 10:00-11:00Yvonne HüllweberSportzentrum Süd
Sa. 9:00-10:00Elvira YabrovaSportzentrum Süd
1dbcbdaa196026e26e999387e7bc1725
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` = '1dbcbdaa196026e26e999387e7bc1725' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
WL, LKMo. 19:00-20:00Elvira YabrovaSportzentrum Süd
WK, LK ab 10J.Di. 16:30-19:00Elvira YabrovaSportzentrum Süd
WK, LK ab 11J.Mi. 18:00-20:00Elvira YabrovaDürer-Gymnasium
WK, LK ab 9J.Fr. 16:30-18:00Elvira YabrovaDürer-Gymnasium
WK, LK ab 10J.Sa. 11:30-14:00Elvira YabrovaSportzentrum Süd
d8c024f21fc502a93ba71c6e05e3122b
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` = 'd8c024f21fc502a93ba71c6e05e3122b' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
AngebotZeitTrainerSportstätte
LK 9-10J.Mi. 17:00-18:30Elvira YabrovaDürer-Gymnasium
LK bis 10J.Sa. 10:00-11:30Elvira YabrovaSportzentrum Süd
a19885f5748a5db9a7b95ba84e0e22d0
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` = 'a19885f5748a5db9a7b95ba84e0e22d0' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name
Gruppenleiterin: 
Claudia Milde
E-mail: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
AngebotZeitTrainerSportstätte
Mo. 18:00-20:00Kai BöslauSportzentrum Süd
Di. 19:00-21:00Kai BöslauSportzentrum Süd
Fr. 18:00-20:30Kai BöslauSportzentrum Süd
603c32f40317b3179730bb4d8a032f84
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` = '603c32f40317b3179730bb4d8a032f84' ORDER BY fn_weekday_to_number(u.weekday), u.time, sl.name