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