Anzeige
kv pfeil links
kv pfeil rechts<
Turnen

TURNEN

Die Abteilung Turnen beim Post SV setzt sich zusammen aus:
Gerätturnen - Rhönrad - Rhythmische Sportgymnastik - Trampolin

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 = '1282361fd91dd7d33e973c529627e0a1' ORDER BY sa1.name, sa.name, p.name