Query = select * FROM Region r,Gebiet g,Wand w,Touren t WHERE t.RID = r.RID AND t.GID = g.GID AND t.WID = w.WID AND VersionGueltig=1 AND EinstiegLat order by WName,Tour
"Afternoon, Sector Afternoon",37.004551,26.944679,"" "Arena, Montag 18 Uhr",47.986618,15.337108,"" "Arena, Untere Arena",47.336727,15.378955,"" "Arhi, Sector Arhi",37.018929,26.965611,"" "Aufbau, Block Ade",47.322643,15.000000,"" "Aufbau, unbekannt",47.322643,15.000000,"" "Aufbau, Wasserrunse",47.322701,15.378410,"" "Baby House, Sector Baby House",37.046150,26.947149,"" "Badlwand, Badlwand",47.224369,15.342340,"" "Balcone, Sector Balcone",42.618641,12.799230,"" "Boulderhalle, Boulderhalle",48.237518,16.286209,"" "BoulderHoelle, BoulderHoelle",47.072254,15.508146,"" "BreiteWand, Alle Neune",47.322491,15.383390,"" "BreiteWand, Die glorreichen Sieben",47.322281,15.381750,"" "BreiteWand, Eldorado",47.322491,15.383390,"" "BreiteWand, Gintonic",47.323261,15.384520,"" "BreiteWand, Muffelkante",47.322620,15.384730,"" "BreiteWand, Sportmuffelweg",47.323021,15.383610,"" "BreiteWand, Tigerauge",47.322189,15.382140,"" "BreiteWand, Winnetouweg",47.322311,15.383010,"" "Burgstall, Burgstallritter",47.342468,15.390120,"" "Burgstall, Drachentoeter",47.342930,15.388240,"" "Burgstall, Steile Minna",47.343517,15.389764,"" "CAC - Graz, CAC - Graz",47.064774,15.423110,"" "City Rock, City Rock Liezen",47.565929,14.234440,"" "Cul de Chien, Cul de Chien",48.376282,2.522325,"" "Dacapo, Dacapodajaga",47.327370,15.398030,"" "Dacapo, Draufgabe",47.327591,15.399100,"" "Dacapo, Goldader",47.327534,15.398855,"" "Dacapo, Herbstzeitlose",47.327042,15.400360,"" "Dacapo, Paranabolika",47.327370,15.398030,"" "Efeu Grat, Efeu Grat",48.080757,16.270252,"" "Erika Grat, Erika Grat",48.081707,16.275162,"" "Falkenstein, Seenot",47.757900,13.397520,"" "Flatzerwand, Sektor Sunshine",47.747574,16.013079,"" "Gabbio, Sector Gabbio",42.629822,12.784960,"" "Gaisberg, Klettergarten Gaisberg",47.068291,15.382870,"" "Ghost Kitchen, Sector Ghost Kitchen",37.035221,26.961189,"" "Giesswaende, Haupt Wand",48.101551,16.219049,"" "Giesswaende, Plattige Wand",48.101089,16.218361,"" "Gindlhorn, Gindlkante",47.539619,14.055334,"" "Gipfelwand, Spekulatius",47.332809,15.405830,"" "Gipfelwand, Via Veterano",47.333111,15.406750,"" "Glocknergrat, Glocknergrat",48.082500,16.275990,"" "Grande Grotta, Sector Grande Grotta",37.003315,26.944035,"" "Hauptwand, Betty und Paul",47.832520,16.054020,"" "Hauptwand, Elk Meadows",47.329319,15.402340,"" "Hauptwand, Erdgeisterweg",47.329159,15.401969,"" "Hauptwand, Feuervogel",47.327976,15.400340,"" "Hauptwand, Fidel und Che",47.329552,15.402420,"" "Hauptwand, Huehnerbrust",47.327801,15.400530,"" "Hauptwand, Huehnerleiter",47.327801,15.400530,"" "Hauptwand, Mixtour",47.329029,15.402060,"" "Hauptwand, Rechtsruck",47.329941,15.403111,"" "Hauptwand, Rupertina",47.329029,15.402060,"" "Hauptwand, Serengeti",47.328892,15.401670,"" "Hauptwand, Waschrumpel",47.328800,15.401530,"" "Hauptwand, Weg der alten Maenner",47.329811,15.402640,"" "Hauptwand, Weg der schoenen Maenner",47.329742,15.402640,"" "Helenental, Jammerwandl",48.015377,16.198626,"" "Huatluckn, Huatluckn",47.213821,15.332840,"" "Iannis, Sector Iannis",36.999722,26.942150,"" "Iliada, Sector Iliada",37.008499,26.944740,"" "Intersport Eybl, Intersport Eybl",47.033924,15.417337,"" "Irox, Sector Irox",37.015888,26.910040,"" "Isatis, Isatis",48.409672,2.599700,"" "Isola, Sector Isola",42.618450,12.796610,"" "Jetaime, Sector Jetaime",36.997639,26.984358,"" "Jurassic Park, Sector Jurassic Park",37.006931,26.947390,"" "K1 Kletterhalle, K1 Kletterhalle",47.415085,9.734121,"" "Kalydna, Sector Kalydna",36.998829,26.944460,"" "Kanzianiberg , Westwand",46.551868,13.873100,"" "Kasteli, Sector Kasteli",37.017059,26.938379,"" "Klammgraben, Klettergarten Klammgraben",47.384171,15.494843,"" "Kleine Klause, Klausenpfeiler",47.842201,16.024864,"" "Kleine Klause, Teletottes",47.841450,16.025936,"" "Kletter-und Erlebnispark Riegersburg, Kletter-und Erlebnispark Riegersburg",47.006748,15.932280,"" "Klettergarten Bad Eisenkappel, Klettergarten Bad Eisenkappel",46.494961,14.589370,"" "Klettergarten Ligist-Unterwald, Klettergarten Hierzmannsperre",46.993969,15.087030,"" "Klettergarten Rabenstein, Klettergarten Rabenstein",46.688419,14.872790,"" "Kletterhalle Arnoldstein, Kletterhalle Arnoldstein",46.549129,13.711476,"" "Kletterhalle Bruck an der Mur, Kletterhalle Bruck an der Mur",47.411304,15.266619,"" "Kletterhalle Fuerstenfeld, Kletterhalle Fuerstenfeld",47.047901,16.087132,"" "Kletterhalle Hermagor, Kletterhalle Hermagor",46.628208,13.361644,"" "Kletterhalle Imst, Kletterhalle Imst",47.241650,10.749770,"" "Kletterhalle Linz, Kletterhalle Linz",48.244621,14.301590,"" "Kletterhalle Voecklabruck, Kletterhalle Voecklabruck",48.002090,13.648370,"" "Kletterhalle Wien, Kletterhalle Wien",48.226460,16.461296,"" "Kletterhalle Wolfsberg, Kletterhalle Wolfsberg",46.827930,14.849700,"" "Kletterkitz, Kletterkitz",47.443932,12.398919,"" "Kletterzentrum Grossraming, Kletterzentrum Grossraming",47.886520,14.539500,"" "Kreissaal, Sector Kreissaal",37.050320,26.934771,"" "Kugelstein, Ameisenriss",47.218651,15.334850,"" "Kugelstein, Basis",47.219238,15.334590,"" "Kugelstein, Dumpfbackenblick",47.224060,15.337310,"" "Kugelstein, Gemuesekante",47.216778,15.333977,"" "Kugelstein, Girandolenweg",47.218861,15.334900,"" "Kugelstein, Henkelgalerie",47.218029,15.333970,"" "Kugelstein, Nix fuer Hampler",47.215050,15.333170,"" "Kugelstein, Salatplatte",47.216751,15.333180,"" "Kugelstein, Schwarze Platte",47.218674,15.334340,"" "Kugelstein, Z",47.219238,15.334590,"" "Lausbubenwand, Lausbubenpfeiler",48.080444,16.272629,"" "Lausbubenwand, Obere Lausbubenwand",48.080109,16.272079,"" "Lausbubenwand, Untere Lausbubenwand",48.080830,16.272289,"" "Megapoint, Megapoint",46.617081,14.302000,"" "Mumie, Sector Mumie",42.618542,12.797580,"" "Nadelspitz, Bombadil",47.337231,15.388790,"" "Nadelspitz, Onodrim",47.337360,15.388750,"" "Nadelspitz, Ostseite",47.337360,15.388750,"" "Nadelspitz, Suedkante",47.336960,15.388830,"" "North Cape, Sector North Cape",37.016411,26.943310,"" "Oberes Brunntal, Krabbelstube",47.342846,15.403242,"" "Oberes Brunntal, Sanduhrenparadies",47.343441,15.405630,"" "Oberes Brunntal, Saxifraga",47.342846,15.403242,"" "Ocean Dream, Sector Ocean Dream",37.012459,26.947260,"" "Odyssey, Sector Odyssey",37.012020,26.944759,"" "Oestliche Hundswand, Highway",47.593700,15.115006,"" "Olympic Rock, Olympic Rock",45.625679,13.803215,"" "Ourania, Sector Ourania",36.987831,26.940500,"" "Palace, Sector Palace",37.045872,26.950970,"" "Peggauer Wand, Obere Peggauer Wand",47.203850,15.350280,"" "Peggauer Wand, Untere Peggauer Wand",47.203457,15.349919,"" "Peilstein, Cimone",48.015018,16.050028,"" "Peilstein, Duettpfeiler",48.013973,16.047897,"" "Peilstein, Grosse Peilsteinwand",48.014793,16.050051,"" "Peilstein, Grosser Zinnenkessel",48.013149,16.047449,"" "Peilstein, Spartastein",48.012878,16.046747,"" "Peilstein, Teufelsbadstubenwand",48.015007,16.049660,"" "Peilstein, Uhuwinkel",48.014801,16.049728,"" "Pfaffenkogel, Mixtour",47.172379,15.316400,"" "Pfaffenkogel, Rudlweg",47.172379,15.316400,"" "Pfeilerwege, Biotox",47.331890,15.404670,"" "Pfeilerwege, Biovandal",47.331600,15.404520,"" "Pfeilerwege, Euphoria",47.331730,15.404940,"" "Pfeilerwege, Kunststuecke",47.331650,15.404810,"" "Pfeilerwege, Thymianpfeiler",47.331291,15.404110,"" "Poets, Sector Poets",36.998360,26.940840,"" "Rampenwulst, Grastoeterdiagonale",47.336262,15.389140,"" "Rampenwulst, Roter Kamin",47.336262,15.389140,"" "Roche aux Sabots, Roche aux Sabots",48.374962,2.514220,"" "Rockblaster, Rockblaster",48.083096,16.299206,"" "Roter Ofen, Roter Ofen",48.089981,16.239470,"" "Saint Photis, Sector Saint Photis",36.957321,26.921391,"" "School, Sector School",37.019112,26.952950,"" "SO-Sporn, Elfengarten",47.324390,15.389500,"" "SO-Sporn, Jaegersteig",47.324841,15.387700,"" "SO-Sporn, Land des Laechelns",47.324558,15.386700,"" "SO-Sporn, Michelangelo",47.324200,15.387820,"" "SO-Sporn, Nadelstreif",47.324947,15.386952,"" "SO-Sporn, Postlerweg",47.324310,15.388880,"" "SO-Sporn, Ufo",47.324501,15.388440,"" "Spartacus, Sector Spartacus",37.004890,26.945499,"" "Sprungblock, Sprungblock",47.178989,15.481390,"" "Strassenblock, Strassenblock",47.184391,15.489990,"" "Strassentheater, Strassentheater",47.194740,15.483540,"" "Strittu, Sector Strittu",42.618210,12.800070,"" "Suedwand, Wunderwelt",47.325378,15.381330,"" "SuedWest, Alte Suedwest",47.325439,15.379470,"" "Suedwest, Amtsschimmel",47.321850,15.377880,"" "Suedwest, Grauer Weg",47.321865,15.377841,"" "SuedWest, Obere direkte Suedwest",47.325706,15.380734,"" "Suedwest, Suedpfeiler",47.321899,15.378250,"" "Suedwest, Suedwest",47.322430,15.377220,"" "Suedwestwand, Seeblick",47.643822,13.812110,"" "Summertime, Sector Summertime",37.016361,26.955601,"" "Syblegades Rocks, Sector Syblegades Rocks",36.986050,26.939859,"" "Sykati, Sector Sykati",37.059765,26.938906,"" "Tarvis, Kletterhalle Tarvis",46.506748,13.575120,"" "Thalhofergrat, Westseite",48.007080,16.036320,"" "Unteres Brunntal, Brunntalpfeiler",47.342567,15.399822,"" "Waidmannsdorf, Sportkletterarena Klagenfurt Waidmannsdorf",46.615883,14.288323,"" "Weinzoedl, Klettergarten Weinzoedl",47.112003,15.395998,"" "Weisse Wand, Weisse Wand",47.344410,15.391260,"" "West, WiglWogl",47.322620,15.377360,"" "Westwand, Suedgrat",47.545448,14.519940,"" "Westwand, Suedwestpfeiler",47.545738,14.519170,"" "Zigeunerloch, Zigeunerloch",47.139172,15.330590,"" Download File