Alpenüberquerung Salzburg - Triest | Teil 1
Von den Berchtesgadener Alpen in die Hohen Tauern

Alle 15 Fotos ansehen

Alpenüberquerung von Salzburg nach Triest | Teil 1

Die Alpenüberquerung der Extraklasse beginnt vor den Toren Salzburgs mit der Auffahrt auf den sagenumwobenen Untersberg. Weiter geht es über den Königssee vorbei an der imposanten Watzmann Ostwand ins Steinerne Meer. Der weitere Weg bringt uns ins Herz der Hohen Tauern, wo wir unsere erste Etappe des Fernwanderweges beenden.

7 Tage

min. 6, max. 8

Durchgeführt von unserem Partner weltweit!

Bergsteigerschule Watzmann - Deine Vorteile Deshalb sind wir der richtige Partner für diese Tour.

NUR 8 Personen pro Gruppe! Nicht 10 - 12 Personen
Wandern von Salzburg nach Triest
Herausfordernde Tagesetappen
Ruhiger unterwegs als auf dem E5
Bequeme Bahnanreise nach Salzburg

Dein Vorteil & Deine Sicherheit

Zahlungsziel 3 Tage vor Reisebeginn bei sicherer Durchführung! Gültig seit 15.03.2020

Reiseprogramm So ist der reguläre Ablauf dieser Reise. Abweichungen aufgrund von Wetter / Verhältnissen sind möglich!

Tourbeginn: Regulär 10:00 Uhr Markt Schellenberg

Tourende: Vorraussichtlich 18:00 Uhr Markt Schellenberg

1. Tag:
Über den Untersberg zum Stöhrhaus

Treffpunkt am Vormittag am Wanderparkplatz in Markt Schellenberg. Nach einem kurzen Ausrüstungscheck begeben wir uns zur Talsation der Untersbergseilbahn, mit der wir uns den Aufstieg verkürzen. Die anschließende Wanderung über das Hochplateau des sagenumwobenen Untersbergs gibt einen Vorgeschmack auf die kommenden Wandertage. Als perfekter Stützpunkt dient uns das Stöhrhaus. Bei traditioneller Küche und einheimischen Spezialitäten lassen wir den Abend auf der Panoramaterrasse gemütlich ausklingen. Unser Blick schweift über den Berchtesgadener Talkessel und König Watzmann thront majestätisch vor uns.

600 Hm
4 h
StöhrhausHalbpension

2. Tag:
Über den Königssee in den Nationalpark Berchtesgaden

Nach dem Früstück starten wir mit dem Abstieg vom Untersberg. Vorbei am Reißenkaser führt uns unser Weg nach Bischofswiesen. Von hier nehmen wir den Bus zum Königssee. Mit dem Schiff geht es über den See hinein ins Herz des Nationalparks Berchtesgaden. Der Blick schweift über die legendäre Watzmann Ostwand und die Wallfahrtskapelle St. Bartholomä könnte keinen besseren Kontrast dazu geben. Unser weiterer Weg führt uns über die vielen Serpentinen der Saugasse aufs Kärlingerhaus, unser heutiges Etappenziel.

1.300 Hm
1.200 Hm
6 - 7 h
KärlingerhausHalbpension

3. Tag:
Durch das Steinerne Meer zum Riemannhaus

Vor uns liegt das Steinerne Meer! Vorbei an Zirbelkiefern, die wir sicher auch in flüssiger Form verkosten werden, geht es mitten hinein in das schroffe Gelände. Am Riemannhaus angekommen machen wir eine kurze Rast und setzen unseren Weg auf den Spuren der Wallfahrer fort. Von Maria Alm verkürzen wir den Aufstieg zum Statzerhaus mit dem Taxi. Nach einem längeren Aufstieg erreichen wir das Statzerhaus, genießen die letzten Sonnenstrahlen und lassen den Tag ganz entspannt ausklingen.

1.500 Hm
1.100 Hm
7 h
StatzerhausHalbpension

4. Tag:
Von Taxenbach ins Rauriser Tal

Vom Statzerhaus geht es heute hinab nach Taxenbach. Der Weg schlängelt sich durch die fantastische Landschaft, die von der Landwirtschaft stark geprägt wurde. Von Taxenbach aus verkürzen wir den Weg ins Rauriser Tal mit dem Taxi und treten den Weg zum Schutzhaus Neubau an. Vorbei am Naturfreundehaus und den Giganten den Rauriser Tals zu unserer Rechten, führt uns der Weg zu unserer gemütlichen Unterkunft.

800 Hm
1.400 Hm
7 h
Schutzhaus NeubauHalbpension

5. Tag:
Vorbei am Hohen Sonnblick zur Fraganter Schutzhaus

Nach dem Frühstück machen wir uns wieder auf den Weg, der uns vorbei am Hohen Sonnblick in Richtung Fraganter Schutzhaus führt. Die heutige Etappe ist unserer längste auf diesem Teil der Alpenüberquerung. Wir machen viele Höhenmeter im Auf- und Abstieg und am Ende dieser langen Etappe werden wir mit leckerem Essen auf unserer heutigen Berghütte begrüßt und für die Anstrengungen des Tages belohnt.

1.500 Hm
1.100 Hm
6 - 7 h
Fraganter Schutzhaus Halbpension

6. Tag:
Kreuzeckgruppe und Feldnerhütte

Vom Fraganter Schutzhaus gehen wir hinunter nach Innerfragant. Hier bringt uns ein Taxi ins nächste Tal und wir steigen auf die Feldner Hütte auf. Der abwechslungsreiche Weg führt uns in Richtung Kreuzeck, den höchsten Berg der Kreuzeckgruppe. Nach dem Glenktörl erreichen wir nach einem kurzen Abstieg unser heutiges Ziel - die Feldnerhütte. Den letzten Abend lassen wir in gemütlicher Atmosphäre ausklingen und lassen das Erlebte noch einmal Revue passieren.

950 Hm
1.000 Hm
6 h
FeldnerhütteHalbpension

7. Tag:
Über den Höhenweg und Abstieg ins Tal

Heute steht die letzte Etappe unserer Wanderung an. Über den Höhenweg vorbei am Stawipfel steigen wir immer weiter ins Tal ab. Immer näher kommen wir dem Ziel unseres letzten gemeinsamen Tages. Ein letztes mal bewundern wir die österreichische Bergwelt und lassen uns von den Eindrücken der letzten Tage verzaubern. Der lange Abstieg bietet die perfekte Gelegenheit, die erste Etappe unserer Wanderung abzuschließen.

300 Hm
1.900 Hm
6 h
Frühstück

Anforderungen Das musst du können, um für diese Tour gerüstet zu sein.

Alpine Erfahrung

Level 1

Level 2

Level 3

Level 4

Level 5

Anforderungen

Kondition

Technik

Ernsthaftigkeit

Schwierigkeit

3.0

Mittelschwere & schwere Bergwege ROT & SCHWARZ. Für diese geführte Alpenüberquerung von Salzburg nach Greifenburg solltest Du als erfahrener Bergwanderer über eine sehr gute Kondition für Gehzeiten bis 7 Stunden verfügen. Die Aufstiege bei der Alpenüberquerung betragen maximal 1.500 Höhenmeter am Tag. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt beim Wandern ca. 300 Höhenmeter pro Stunde. Ausgesetzte, versicherte oder absturzgefährdete Stellen sind auf der Alpenüberquerung von Salzburg nach Triest sehr wenige zu erwarten. Es gibt eine Stelle dieser Kategorie ab dem Riemannhaus, welche Trittsicherheit und Schwindelfreiheit erfordert.

Mäßige Alpine Erfahrung | Mittlere alpine Unternehmung

Mäßige Ernsthaftigkeit / Gefährdung
Erfahrung Bergwandern
Trittsicherheit und Schwindelfreiheit
Teamfähigkeit für Alpenüberquerung in einer Gruppe

1.500 Hm1.400 Hm7 hROT - SCHWARZ

Ausführliche Information zur Schwierigkeitsbewertung von Bergtouren

Leistungen Bei dieser Tour hast du folgende Inklusivleistungen, Exklusivleistungen und Reiseoptionen.

Leistungen inklusive

7 Tage Führung und Organisation durch einen Bergwanderführer/Bergführer
6 x Übernachtung inkl. Halbpension | Hütte - Mehrbettzimmer oder Lager
Sämtliche Transfers vor Ort gem. Programm
Rücktransfer nach Berchtesgaden

Reiseoptionen

Freiwilliger myclimate Klimaschutzbeitrag : 15,00 €

Leistungen exklusive

Speisen und Getränke außerhalb der Halbpension
Parkplatzgebühren bei PKW-Anreise
Individuelle Trinkgelder
*Die Zusatzkosten können variieren und dienen lediglich zur Orientierung!

Tourtermine Für diese Tour sind folgende Termine verfügbar

03.07. - 09.07.2022

1.090,00 €

Bergführer: Manfred Beier

Erste Buchungen vorhanden

31.07. - 06.08.2022

1.090,00 €

Bergführer: Manfred Beier

Ausgebucht

07.08. - 13.08.2022

1.090,00 €

Bergführer: Alpine Welten Profi

Durchführungsgarantie ab 6 TN

21.08. - 27.08.2022

1.090,00 €

Bergführer: Andreas Maier

Durchführungsgarantie ab 6 TN

Dein bevorzugter Termin ist nicht mit dabei oder hat nicht genügend freie Plätze?
Kein Problem - frage hier einen Wunschtermin an:

Jetzt Alternativ- oder Zusatztermin anfragen!

Weitere verfügbare Touren mit deinen Reisedaten

Unterkünfte während der Tour Hier findest du Informationen rund um die Unterkünfte dieser Tour

Stöhrhaus

1.894 m

Das Stöhrhaus liegt in unmittelbarer Nähe zum Berchtesgadener Hochtron am Untersberg in den Berchtesgadener Alpen. Das Stöhrhaus ist ein beliebter Stützpunkt für Kletterer, Höhlenforscher, Wanderer und Bergsteiger. Ein besonderes Erlebnis ist der Ausblick…

Kärlingerhaus

1.631 m

Der Nationalpark in Berchtesgaden benötigt nicht viel Beschreibung. Ein Naturparadies umrahmt von majestätischen Bergen, durchwachsen von Bächen und Seen, herausfordernde Klettertouren, und gemütliche Wanderungen. Ein Naturschauspie der Extraklasse. Das…

Statzerhaus

2.117 m

Das Statzerhaus ist eine kleine Schutzhütte in den Salzburger Schieferalpen. Das Haus steht auf dem höchsten Grasberg Europas, dem Hundstein. Die Umgebung der Hütte ist geprägt von einer wildromantischen Almenlandschaft. Hier finden sich herrliche Wege um zu…

Schutzhaus Neubau

2.175 m

Das Schutzhaus Neubau liegt in Salzburg im Herzen vom Nationalpark Hohe Tauern. Am Fuße des Hohen Sonnblick gelegen ist das Schutzhaus die ideale Basis für Wanderungen und Bergtouren. Auch im Winter kommen hier Skitourengeher und Schneeschuhgeher vorbei,…

Fraganter Schutzhaus

1.810 m

Das Fraganter Schutzhaus ist eine Schutzhütte in der Goldberggruppe in Kärnten. Die moderne Hütte wird gerne als Stützpunkt für ausgedehnte Wanderungen, Bergtouren und Mountainbike Touren genutzt. Auch im Winter eignet sich die Hütte hervorragend für…

Feldnerhütte

2.182 m

Die Feldnerhütte ist eine Schutzhütte im Oberdrautal in Kärnten. Gelegen in der Kreuzeckgruppe ist die Hütte ein idealer Ausgangspunkt für Wanderungen und Bergtouren. Auch im Winter eignet sich der Winterraum der Hütte, um Skitouren und Schneeschuhtouren zu…

Wichtige Hinweise und Infos zur Region Allgemeine Informationen und spezielle Hinweise.

Der Untersberg ist das nördlichstes Massiv der Berchtesgadener Alpen und liegt in den Ländern Bayern und Salzburg. Hauptsächlich besteht der Berg aus einem ausgeprägten Gipfelplateau und verfügt über die Hauptgipfel Berchtesgadener Hochthron (1972 m) und Salzburger Hochthron (1853 m). Der Berg weist zahlreiche Höhlensysteme auf, darunter die als Schauhöhle erschlossene Schellenberger Eishöhle und die Riesending Schachthöhle. Mitunter bedingt durch die Höhlen ranken sich zahlreiche Sagen und Mythen um den Untersberg.

Der Königssee ist ein langgestreckter Gebirgssee am östlichen Fuß des Watzmanns und wird im Wesentlichen durch den Saletbach gespeist. Durch die den See begrenzenden steilen Berghänge wird er als fjordartig beschrieben. Der Königssee hat Trinkwasserqualität und gilt als einer der saubersten Seen Deutschlands. Hauptsächlich liegt der Königssee im Nationalpark Berchtesgaden.

Der Watzmann gipfelt in der 2.713 m hohen Watzmann-Mittelspitze, dem höchsten Punkt des Berchtesgadener Landes. Die Watzmannsage behandelt den Hauptgipfel und seine Nebengipfel (Watzmannfrau und Kinder). Die Watzmann Ostwand ist die höchste Wand der Ostalpen.

Das Steinerne Meer ist eine verkarstete Hochfläche, die durch die Grenze Bayern zu Salzburg geteilt wird. Die höchsten Gipfel sind das Selbhorn (2.655 m) und die Schönfeldspitze (2.653 m).

Die Salzburger Schieferalpen, auch Salzburger Grasberge, befinden sich in Österreich im Bundesland Salzburg, zu kleinem Teil in der Steiermark. Als Teil der Schieferalpen werden sie zur Grauwackenzone und entweder zu den Nord- oder den Zentralalpen gezählt.

Die Kreuzeckgruppe ist eine Gebirgsgruppe in Österreich in den Bundesländern Tirol und Kärnten. Der Anteil Tirols beschränkt sich auf einen kleinen Teill im Westen. Die Kreuzeckgruppe besteht hauptsächlich aus Gneisen und Glimmerschiefern. Gemeinsam mit anderen Bergregionen bildet die Kreuzeckgruppe die Hohen Tauern. Die Kreuzeckgruppe wird haupsächlich zur Alm- und Forstwirtschaft genutzt und weist keine nennenswerten Siedlungen auf.

Informationen zum Reiseland Hier findest Du detaillierte Angaben zum Reiseland. Von der Währung über die Einreisebestimmungen bis zu Gesundheitshinweisen..

Länderinformationen Deutschland

Länderinformationen Österreich

Bitte beachte folgenden Link:
Wichtige Hinweise zu Reisen mit besonderen Risiken

Versicherungen

Reiserücktritt: Wir empfehlen Dir dringend den Abschluss einer Reiserücktrittsversicherung sowie einer Versicherung zur Deckung der Rückführungskosten bei Unfall oder Krankheit. Bitte prüfe hierfür Deinen Versicherungsschutz. Mit der Reisebestätigung übersenden wir Dir eine entsprechende Möglichkeit diesen Versicherungsschutz herzustellen.
Auslandsreisekrankenversicherung: Ebenso empfehlen wir für unsere Bergreisen den Abschluss einer Auslandsreisekrankenversicherung zur Deckung von ausländischen Selbstbehalten.
Mitgliedschaft in einem alpinen Verein: Die Mitgliedschaft in einem alpinen Verein (z. B. Deutscher Alpenverein oder Österreichischer Alpenverein) deckt bereits die Kosten einer eventuellen Hubschrauberrettung ab und wird von uns empfohlen.

Covid Hinweis

Im Zusammenhang mit Covid-19 bestehen behördliche und gesetzliche Vorgaben zur Ein- und Ausreise sowie unterschiedlichste Testbestimmungen, welche insbesondere für Reisende ohne Covid-19 Grundimmunisierung sehr häufig geändert werden und vor Ort im Rahmen der Tour/Reise nicht umgesetzt werden können. Die Nutzung von Hotels, Berghütten, Seilbahnen usw. unterliegt zudem weiteren Regularien, welche lokal abweichen können. Diese Lage birgt für Reisende ohne Covid-19 Grundimmunisierung und uns als Veranstalter ein erhebliches Risiko in der Reiseorganisation. Vor diesem Hintergrund ist die Teilnahme an dieser Reise/Tour nur mit gültigem, digitalem Covid-19 Impfnachweis bzw. Genesenen-Nachweis möglich (2-G-Regel). Erfahre mehr im Covid-19 Information Hub

Mindestteilnehmerzahl

Diese Reise kann nur ab der angegebenen Mindestteilnehmerzahl durchgeführt werden. Sollte diese 20 Tage vor Antritt der Reise nicht erreicht sein, so kann eine Absage der Veranstaltung durch den Veranstalter erfolgen. Im Falle einer Absage sind wir jedoch bestrebt Dir ein alternatives Angebot zu unterbreiten. Bitte beachte hierzu unsere ergänzenden Hinweise in den Reisebedingungen.

Reiseveranstalter

Alpine Welten Die Bergführer GmbH & Co. KG, Rauher Berg 8, 89180 Berghülen

Mobilitätshinweis

Diese Reise ist für Personen mit eingeschränkter Mobilität nicht geeignet.

FAQ Häufig gestellte Fragen und Antworten zu dieser Tour

Sind meine Schuhe zum Bergwandern geeignet?

Das „geeignete“ Schuhwerk Kategorie B - max. C

In der Alpine Welten Akademie behandeln wir das Thema Bergschuhe zum Wandern sehr ausführlich. Klick Dich rein und sammle wertvolle Tipps! Es ist sehr wichtig, dass Du auf Deiner geplanten Bergwanderung gut ausgerüstet unterwegs bist. Lass Dich im Fachhandel ausgiebig beraten und nimm Dir für den Schuhkauf Zeit. Unten findest Du ein Video zum Thema Bergwanderschuhe. Das obige Bild sollte darstellen, dass zu leichte und auch zu schwere/stabile Schuhe ungeeignet sind zum Bergwandern!

Besonderheit Alpenüberquerung!

Bei anspruchsvollen Wanderungen müssen häufig Schneefelder begangen werden, zudem ist das Gepäck meist schwerer als bei kürzeren Touren. Aus diesem Grund ist für diese Touren ein Bergschuh der Kategorie B meistens nicht geeignet! Einige Negativ-Beispiele haben wir unten aufgelistet. Diese Schuhe sind ungeeignet, da sie nicht der Kategorie B entsprechen, sondern obwohl sie knöchelhoch sind, der Kategorie A zuzuordnen sind. Fehlende Sohlensteifigkeit und mangelnder Knöchelhalt sind die Ausschlusskriterien!

Kann ich für meine Alpenüberquerung einen Gepäcktransport buchen?

Wir bieten keinen Gepäcktransport für unsere Alpenüberquerungen an, da wir der Meinung sind, dass es für eine Bergwanderung ganz einfach mit dazu gehört, dass man seinen Rucksack selbst trägt! ☝️Denke an die unnötige CO2 Belastung, die dadurch entsteht. Wer nicht in der Lage ist einen Rucksack von 8 - 10 kg über die Tourdauer zu tragen, meldet sich falsch an!

Wann endet die Tour?

Die grobe Schätzung zum Tourende findest Du im Reiseprogramm. ☝️Wenn Du Deine Rückreise planst, berücksichtige unbedingt einen ausreichenden "Puffer", da sich die Zeit aus den verschiedensten Gründen (Wetter, Teilnehmer, Stau etc.) verschieben kann.

Weitere häufige Fragen zu Bergreisen mit Bergführer findest Du in unserem Hilfe-Center.

Neuigkeiten Aktuelles zur Tour.

Deutschland | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Deutschland. Besonderheiten, die bei einer Hüttenübernachtung in Deutschland zu beachten sind.

Österreich | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Österreich. Besonderheiten, die bei einer Hüttenübernachtung in Österreich zu beachten sind.

AGB Änderung buchen ohne Anzahlung

15.03.20 Wir ändern für Dich unser AGB! Buchen ohne Anzahlung auf allen unseren Reisen. Zahlungsziel erst 3 Tage vor Reisebeginn.

#deinabenteuerbeginnt Hier haben wir noch ein wenig Inspiration für dich.

#reisebericht

Salzburg Triest | Alpenüberquerung auf stillen Wegen

#kennstduschon

#KENNSTDUSCHON ... die Alpenüberquerung von Salzburg nach Triest

Cookie Einstellungen

Wir setzen automatisiert nur technisch notwendige Cookies, deren Daten von uns nicht weitergegeben werden und ausschließlich zur Bereitstellung der Funktionalität dieser Seite dienen.

Außerdem verwenden wir Cookies, die Dein Verhalten beim Besuch der Webseiten messen, um das Interesse unserer Besucher besser kennen zu lernen. Wir erheben dabei nur pseudonyme Daten, eine Identifikation Deiner Person erfolgt nicht.

Weitere Informationen findest Du in unserer Datenschutzerklärung.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent702e6d7fd00a6f14bcc094a4c956d69f
  time1643278006
  countdown10
- _Token(array)
  key68bef9517c9c4435eb0e4bec0e479a155bccd31ab6659f063cf91934351eee43223fe477230a5cb41fdb5dfbb81a29934bee86b3eae7d5e6f04da47fc59941e3
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  68bef9517c9c4435eb0e4bec0e479a155bccd31ab6659f063cf91934351eee43223fe477230a5cb41fdb5dfbb81a29934bee86b3eae7d5e6f04da47fc59941e31643265406
====
Request
+
Request

Cake Params
- pluginFrontendTours
- controllerFrontendTours
- actiontour
- named(empty)
- pass(array)
  0306
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Tour306
- route(array)
  id2623
  hashb798412c39ab8033cd9fa3323c2a5b8f
  created2018-08-01 09:49:28
  updated2021-11-09 10:48:30
  modelTour
  foreign_key306
  base/
  aliasalpenueberquerung-salzburg-triest-teil-1
  controllerFrontendTours.FrontendTours
  actiontour
  parent_id(null)
  lft4187
  rght4188
  route/alpenueberquerung-salzburg-triest-teil-1
- isAjax(false)
- _Token(array)
  key68bef9517c9c4435eb0e4bec0e479a155bccd31ab6659f063cf91934351eee43223fe477230a5cb41fdb5dfbb81a29934bee86b3eae7d5e6f04da47fc59941e3
  unlockedFields(empty)
Post data

No post data.

Query string
- steptour
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(null)
  actionindex
- template/*
====

Sql Log

Sql Logs

default

Total Time: 42 ms
Total Queries: 186 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/alpenueberquerung-salzburg-triest-teil-1' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 4187 AND `Route`.`rght` >= 4188 ORDER BY `Route`.`lft` asc	1	1	2	maybe slow
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `alpinewelten`.`settings` AS `Setting` LEFT JOIN `alpinewelten`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	46	46	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `alpinewelten`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`languages` AS `Language` WHERE `Language`.`title` = 'www.bergsteigerschule-watzmann.de' LIMIT 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'faq' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 421 AND `Menu`.`rght` < 422 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'down_payment_reminder' LIMIT 1	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'remaining_payment_reminder' LIMIT 1	1	1	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'default' AND `EmailTemplate`.`status_value` = 'warning' LIMIT 1	1	1	0
SELECT `Tour`., `FirmsTour`., `Microsite`., `Firm`.`title`, `Firm`.`id`, `Microsite`.`id`, `Tour`.`id`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights. FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight` FROM `alpinewelten`.`tours` AS `Tour` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Tour`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`microsites` AS `Microsite` ON (`Tour`.`microsite_id` = `Microsite`.`id`) LEFT JOIN `alpinewelten`.`tour_texts` AS `TourTexts` ON (`TourTexts`.`tour_id` = `Tour`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Tour`.`id` AND `Route`.`model` = 'Tour') LEFT JOIN `alpinewelten`.`firms_tours` AS `FirmsTour` ON (`FirmsTour`.`tour_id` = `Tour`.`id` AND `FirmsTour`.`firm_id` = '3') WHERE `Tour`.`id` = 306 LIMIT 1	1	1	1
SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `LogoMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Firm' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9556) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `LogoHorizontalMedia`.`id`, `LogoHorizontalMedia`.`hash`, `LogoHorizontalMedia`.`created`, `LogoHorizontalMedia`.`updated`, `LogoHorizontalMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoHorizontalMedia`.`id`) AS `LogoHorizontalMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `LogoHorizontalMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `LogoHorizontalMedia`.`id`) WHERE `MediaEntity`.`model` = 'Firm' AND `MediaEntity`.`field` = 'logo_horizontal' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9419) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 306	1	1	1
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 306 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TourDate`.`id`, `TourDate`.`hash`, `TourDate`.`created`, `TourDate`.`updated`, `TourDate`.`status`, `TourDate`.`tour_id`, `TourDate`.`tour_date_number`, `TourDate`.`title`, `TourDate`.`subtitle`, `TourDate`.`participants_min`, `TourDate`.`participants_max`, `TourDate`.`duration_days`, `TourDate`.`tour_price`, `TourDate`.`down_payment`, `TourDate`.`country_of_service`, `TourDate`.`saison`, `TourDate`.`travel_insurance_certificate`, `TourDate`.`rating_condition`, `TourDate`.`rating_technique`, `TourDate`.`rating_experience`, `TourDate`.`rating_difficulty_category`, `TourDate`.`start_zip`, `TourDate`.`start_city`, `TourDate`.`start_street`, `TourDate`.`start_country`, `TourDate`.`start_meeting_point`, `TourDate`.`start_time`, `TourDate`.`end_alternate_address`, `TourDate`.`end_time`, `TourDate`.`flight`, `TourDate`.`flight_details`, `TourDate`.`region_id`, `TourDate`.`date_start`, `TourDate`.`mountain_guide_status`, `TourDate`.`manual_booking_status`, `TourDate`.`participant_list_visible`, `TourDate`.`speciality`, `TourDate`.`special_features`, `TourDate`.`mountain_guide_tour_info`, `TourDate`.`customer_tour_info`, `TourDate`.`ws_text_requirements`, `TourDate`.`ws_text_travel_program`, `TourDate`.`ws_text_accomodation`, `TourDate`.`ws_text_services`, `TourDate`.`rating_seriousness`, `TourDate`.`rating_overall_score`, `TourDate`.`infotext_booking`, `TourDate`.`last_minute`, `TourDate`.`travel_information`, `TourDate`.`meeting_point_map_lat`, `TourDate`.`meeting_point_map_marker`, `TourDate`.`meeting_point_map_type`, `TourDate`.`meeting_point_map_zoom`, `TourDate`.`meeting_point_map_long`, `TourDate`.`participant_list_visible2`, `TourDate`.`cancelled`, `TourDate`.`days_before_start_for_last_notice`, `TourDate`.`execution_feasibility`, `TourDate`.`days_before_start_for_cancellation`, `TourDate`.`ws_text_overview`, `TourDate`.`mountain_guide_tour_search_information`, `TourDate`.`allow_double_assignment`, `TourDate`.`customer_tour_material_info`, `TourDate`.`material_list_link`, `TourDate`.`minimum_reached_notification`, `TourDate`.`c19_cancellation`, `TourDate`.`ws_text_course_content`, `TourDate`.`ws_text_information`, `TourDate`.`gmap_marker`, `TourDate`.`ws_text_short_description`, `TourDate`.`gmap_type`, `TourDate`.`gmap_zoom`, `TourDate`.`ws_text_location_description`, `TourDate`.`ws_text_detail_description`, `TourDate`.`gmap_lat`, `TourDate`.`gmap_long`, `TourDate`.`callout_icon_multiple`, `TourDate`.`ws_text_advantages`, `TourDate`.`ws_text_detail_description_new`, `TourDate`.`ws_text_information_new`, `TourDate`.`ws_text_accomodation_new`, (CONCAT_WS (',',`TourDate`.`gmap_lat`,`TourDate`.`gmap_long`)) AS `TourDate__gmap`, (CONCAT_WS (',',`TourDate`.`meeting_point_map_lat`,`TourDate`.`meeting_point_map_long`)) AS `TourDate__meeting_point_map`, (COALESCE(`TourDate`.`end_zip`, `TourDate`.`start_zip`)) AS `TourDate__end_zip`, (COALESCE(`TourDate`.`end_city`, `TourDate`.`start_city`)) AS `TourDate__end_city`, (COALESCE(`TourDate`.`end_street`, `TourDate`.`start_street`)) AS `TourDate__end_street`, (COALESCE(`TourDate`.`end_country`, `TourDate`.`start_country`)) AS `TourDate__end_country`, (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) AS `TourDate__date_end`, (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')) AS `TourDate__count_participants`, (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`) AS `TourDate__count_mountain_guides`, (`TourDate`.`date_start` <= "2022-09-30" AND (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) >= "2022-06-01") AS `TourDate__peak_season`, (CONCAT((SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')), " + " , (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`))) AS `TourDate__participants_booked`, (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "bookings_present" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= 1 ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = 0 ) THEN 0 END)))WHEN 0 THEN "places_free" WHEN 1 THEN "bookings_present" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" END) AS `TourDate__booking_status`, ( IF( `TourDate`.`cancelled`, 'canceled', IF((SELECT SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) > 0 AND SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) = SUM(IF(`Booking`.`status` NOT IN ('new_from_website', 'waiting_list', 'called_off', 'canceled'), 1, 0)) FROM bookings AS Booking WHERE `Booking`.`tour_date_id` = `TourDate`.`id`), 'completed', 'in_process') )) AS `TourDate__processing_status`, (`TourDate`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tour_dates AS TourTravelOptionXTourDates inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTourDates`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTourDates`.`tour_date_id` = `TourDate`.`id`), 0)) AS `TourDate__price_excl_flight` FROM `alpinewelten`.`tour_dates` AS `TourDate` WHERE `TourDate`.`date_start` > CURDATE() AND `TourDate`.`status` = 'active' AND `TourDate`.`tour_id` = (306) ORDER BY `TourDate`.`date_start` ASC	4	4	3	maybe slow
SELECT `TravelOptions`.`id`, `TravelOptions`.`hash`, `TravelOptions`.`created`, `TravelOptions`.`updated`, `TravelOptions`.`title`, `TravelOptions`.`description`, `TravelOptions`.`type`, (SELECT COUNT(1) FROM tour_travel_options_tours AS TourTravelOptionCrossTab WHERE `TourTravelOptionCrossTab`.`tour_travel_option_id` = `TravelOptions`.`id`) AS `TravelOptions__tour_count`, `TourTravelOptionsTourDate`.`id`, `TourTravelOptionsTourDate`.`tour_date_id`, `TourTravelOptionsTourDate`.`tour_travel_option_id`, `TourTravelOptionsTourDate`.`price`, `TourTravelOptionsTourDate`.`position` FROM `alpinewelten`.`tour_travel_options` AS `TravelOptions` JOIN `alpinewelten`.`tour_travel_options_tour_dates` AS `TourTravelOptionsTourDate` ON (`TourTravelOptionsTourDate`.`tour_date_id` IN (14006, 13174, 14008, 14009) AND `TourTravelOptionsTourDate`.`tour_travel_option_id` = `TravelOptions`.`id`)	4	4	1	maybe slow
SELECT `MountainGuides`.`id`, `MountainGuides`.`hash`, `MountainGuides`.`created`, `MountainGuides`.`updated`, `MountainGuides`.`mountain_guide_number`, `MountainGuides`.`mountain_guide_type`, `MountainGuides`.`mountain_guide_salutation`, `MountainGuides`.`mountain_guide_name`, `MountainGuides`.`mountain_guide_lastname`, `MountainGuides`.`mountain_guide_street`, `MountainGuides`.`mountain_guide_zip`, `MountainGuides`.`mountain_guide_city`, `MountainGuides`.`mountain_guide_country`, `MountainGuides`.`mountain_guide_language`, `MountainGuides`.`mountain_guide_mobile`, `MountainGuides`.`mountain_guide_phone`, `MountainGuides`.`mountain_guide_email`, `MountainGuides`.`mountain_guide_birthday`, `MountainGuides`.`bank_account_holder_lastname`, `MountainGuides`.`bank_account_holder_name`, `MountainGuides`.`bank_account_number`, `MountainGuides`.`bank_code`, `MountainGuides`.`bank_name`, `MountainGuides`.`bank_iban`, `MountainGuides`.`bank_bic`, `MountainGuides`.`tax_number`, `MountainGuides`.`vat_number`, `MountainGuides`.`mountain_guide_education`, `MountainGuides`.`height`, `MountainGuides`.`clothing_comment`, `MountainGuides`.`passport_number`, `MountainGuides`.`id_number`, `MountainGuides`.`comment`, `MountainGuides`.`alpine_club_number`, `MountainGuides`.`adac_number`, `MountainGuides`.`other_insurances`, `MountainGuides`.`youtube`, `MountainGuides`.`emergency_contact_relation`, `MountainGuides`.`emergency_contact_salutation`, `MountainGuides`.`emergency_contact_name`, `MountainGuides`.`emergency_contact_lastname`, `MountainGuides`.`emergency_contact_street`, `MountainGuides`.`emergency_contact_zip`, `MountainGuides`.`emergency_contact_city`, `MountainGuides`.`emergency_contact_country`, `MountainGuides`.`emergency_contact_language`, `MountainGuides`.`emergency_contact_mobile`, `MountainGuides`.`emergency_contact_phone`, `MountainGuides`.`emergency_contact_email`, `MountainGuides`.`firm_id`, `MountainGuides`.`ws_text_content`, `MountainGuides`.`ws_text_motivation`, `MountainGuides`.`ws_text_out_of_apline_hobbies`, `MountainGuides`.`ws_text_personal_information`, `MountainGuides`.`ws_text_additional_qualifications`, `MountainGuides`.`member_id`, `MountainGuides`.`previous_url`, `MountainGuides`.`status`, `MountainGuides`.`exact_shoe_size`, `MountainGuides`.`exact_trousers_size`, `MountainGuides`.`exact_trousers_large`, `MountainGuides`.`exact_jacket_size`, `MountainGuides`.`exact_shirt_size`, `MountainGuides`.`last_api_call`, (SELECT GROUP_CONCAT(`Region`.`title`, " ", `MountainGuideDailyRate`.`daily_rate`, " €" SEPARATOR " \| ") FROM `alpinewelten`.`mountain_guide_daily_rates` AS `MountainGuideDailyRate` JOIN `alpinewelten`.`regions` AS `Region` ON (`MountainGuideDailyRate`.`region_id` = `Region`.`id`) WHERE `MountainGuideDailyRate`.`mountain_guide_id` = `MountainGuides`.`id`) AS `MountainGuides__daily_rates`, (CONCAT(mountain_guide_name, " ", mountain_guide_lastname)) AS `MountainGuides__fullname`, `MountainGuidesTourDate`.`id`, `MountainGuidesTourDate`.`tour_date_id`, `MountainGuidesTourDate`.`mountain_guide_id` FROM `alpinewelten`.`mountain_guides` AS `MountainGuides` JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MountainGuidesTourDate` ON (`MountainGuidesTourDate`.`tour_date_id` IN (14006, 13174, 14008, 14009) AND `MountainGuidesTourDate`.`mountain_guide_id` = `MountainGuides`.`id`)	3	3	1	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 79 AND `Route`.`model` = 'MountainGuide'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 176 AND `Route`.`model` = 'MountainGuide'	1	1	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Accomodations.AccomodationsTourDate' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'send_participant_list' LIMIT 1	1	1	0
SELECT `Accomodations`.`id`, `Accomodations`.`hash`, `Accomodations`.`created`, `Accomodations`.`updated`, `Accomodations`.`number`, `Accomodations`.`name`, `Accomodations`.`type`, `Accomodations`.`owners`, `Accomodations`.`phone_cabin`, `Accomodations`.`phone_valley`, `Accomodations`.`mobile`, `Accomodations`.`fax`, `Accomodations`.`email`, `Accomodations`.`url`, `Accomodations`.`zip`, `Accomodations`.`city`, `Accomodations`.`street`, `Accomodations`.`country`, `Accomodations`.`region_area_id`, `Accomodations`.`remark`, `Accomodations`.`geopoint_lat`, `Accomodations`.`geopoint_long`, `Accomodations`.`cancellation_period`, `Accomodations`.`tighter_cancellation_period`, `Accomodations`.`status`, `Accomodations`.`subline`, `Accomodations`.`height`, `Accomodations`.`video_url`, `Accomodations`.`opening_hours`, `Accomodations`.`premises`, `Accomodations`.`equipment`, `Accomodations`.`currency`, `Accomodations`.`detail_description`, `Accomodations`.`days_before_to_send_participant_list`, `Accomodations`.`country_id`, `Accomodations`.`url_booking_system`, (CONCAT_WS (',',`Accomodations`.`geopoint_lat`,`Accomodations`.`geopoint_long`)) AS `Accomodations__geopoint`, `AccomodationsTourDate`.`id`, `AccomodationsTourDate`.`tour_date_id`, `AccomodationsTourDate`.`accomodation_id`, `AccomodationsTourDate`.`overnight_stay`, `AccomodationsTourDate`.`number_participants`, `AccomodationsTourDate`.`number_mountain_guides`, `AccomodationsTourDate`.`reservation_status`, `AccomodationsTourDate`.`reservation_type`, `AccomodationsTourDate`.`reservation_type_actual`, `AccomodationsTourDate`.`number_participants_actual`, `AccomodationsTourDate`.`number_mountain_guides_actual`, `AccomodationsTourDate`.`base_camp`, `AccomodationsTourDate`.`created`, `AccomodationsTourDate`.`updated` FROM `alpinewelten`.`accomodations` AS `Accomodations` JOIN `alpinewelten`.`accomodations_tour_dates` AS `AccomodationsTourDate` ON (`AccomodationsTourDate`.`tour_date_id` IN (14006, 13174, 14008, 14009) AND `AccomodationsTourDate`.`accomodation_id` = `Accomodations`.`id`)	24	24	1
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 376 AND `Route`.`model` = 'Accomodation'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 59 AND `Route`.`model` = 'Accomodation'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 381 AND `Route`.`model` = 'Accomodation'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 382 AND `Route`.`model` = 'Accomodation'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 383 AND `Route`.`model` = 'Accomodation'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 384 AND `Route`.`model` = 'Accomodation'	1	1	0
SELECT `TeaserMedia`.`id`, `TeaserMedia`.`hash`, `TeaserMedia`.`created`, `TeaserMedia`.`updated`, `TeaserMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserMedia`.`id`) AS `TeaserMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (376, 59, 381, 382, 383, 384) AND `MediaEntity`.`media_id` = `TeaserMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'teaser' ORDER BY `MediaEntity`.`pos` ASC	2	2	1	maybe slow
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (1724, 8470) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	23	23	1
SELECT `Countries`.`id`, `Countries`.`hash`, `Countries`.`created`, `Countries`.`updated`, `Countries`.`title`, `Countries`.`abbreviation`, `Countries`.`subtitle`, `Countries`.`link_embassy_german`, `Countries`.`link_embassy_austrian`, `Countries`.`link_embassy_swiss`, `Countries`.`link_embassy_italian`, `Countries`.`best_travel_season`, `Countries`.`general`, `Countries`.`security`, `Countries`.`nature_climate`, `Countries`.`travel_info`, `Countries`.`entry_customs`, `Countries`.`visa`, `Countries`.`health`, `Countries`.`tours_summer`, `Countries`.`tours_winter`, `Countries`.`microsite_id`, `CountriesTourDate`.`id`, `CountriesTourDate`.`country_id`, `CountriesTourDate`.`tour_date_id` FROM `alpinewelten`.`countries` AS `Countries` JOIN `alpinewelten`.`countries_tour_dates` AS `CountriesTourDate` ON (`CountriesTourDate`.`tour_date_id` IN (14006, 13174, 14008, 14009) AND `CountriesTourDate`.`country_id` = `Countries`.`id`)	8	8	6	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 46 AND `Route`.`model` = 'Country'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 248 AND `Route`.`model` = 'Country'	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Country' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (46, 248) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 306 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	2	2	0
SELECT `TourMainType`.`id`, `TourMainType`.`hash`, `TourMainType`.`created`, `TourMainType`.`updated`, `TourMainType`.`title`, `TourMainType`.`position`, `TourMainType`.`packing_list_text_start`, `TourMainType`.`packing_list_text_end` FROM `alpinewelten`.`tour_main_types` AS `TourMainType` WHERE `TourMainType`.`id` = 3	1	1	0
SELECT `Services`.`id`, `Services`.`hash`, `Services`.`created`, `Services`.`updated`, `Services`.`title`, `Services`.`description`, `Services`.`type`, `Services`.`archive`, (SELECT COUNT(1) FROM tour_services_tours AS TourServiceCrossTab WHERE `TourServiceCrossTab`.`tour_service_id` = `Services`.`id`) AS `Services__tour_count`, `TourServicesTour`.`id`, `TourServicesTour`.`tour_id`, `TourServicesTour`.`tour_service_id`, `TourServicesTour`.`type`, `TourServicesTour`.`price`, `TourServicesTour`.`position` FROM `alpinewelten`.`tour_services` AS `Services` JOIN `alpinewelten`.`tour_services_tours` AS `TourServicesTour` ON (`TourServicesTour`.`tour_id` = 306 AND `TourServicesTour`.`tour_service_id` = `Services`.`id`)	4	4	3	maybe slow
SELECT `TravelOptions`.`id`, `TravelOptions`.`hash`, `TravelOptions`.`created`, `TravelOptions`.`updated`, `TravelOptions`.`title`, `TravelOptions`.`description`, `TravelOptions`.`type`, (SELECT COUNT(1) FROM tour_travel_options_tours AS TourTravelOptionCrossTab WHERE `TourTravelOptionCrossTab`.`tour_travel_option_id` = `TravelOptions`.`id`) AS `TravelOptions__tour_count`, `TourTravelOptionsTour`.`id`, `TourTravelOptionsTour`.`tour_id`, `TourTravelOptionsTour`.`tour_travel_option_id`, `TourTravelOptionsTour`.`price`, `TourTravelOptionsTour`.`position` FROM `alpinewelten`.`tour_travel_options` AS `TravelOptions` JOIN `alpinewelten`.`tour_travel_options_tours` AS `TourTravelOptionsTour` ON (`TourTravelOptionsTour`.`tour_id` = 306 AND `TourTravelOptionsTour`.`tour_travel_option_id` = `TravelOptions`.`id`)	1	1	1
SELECT `Accomodations`.`id`, `Accomodations`.`hash`, `Accomodations`.`created`, `Accomodations`.`updated`, `Accomodations`.`number`, `Accomodations`.`name`, `Accomodations`.`type`, `Accomodations`.`owners`, `Accomodations`.`phone_cabin`, `Accomodations`.`phone_valley`, `Accomodations`.`mobile`, `Accomodations`.`fax`, `Accomodations`.`email`, `Accomodations`.`url`, `Accomodations`.`zip`, `Accomodations`.`city`, `Accomodations`.`street`, `Accomodations`.`country`, `Accomodations`.`region_area_id`, `Accomodations`.`remark`, `Accomodations`.`geopoint_lat`, `Accomodations`.`geopoint_long`, `Accomodations`.`cancellation_period`, `Accomodations`.`tighter_cancellation_period`, `Accomodations`.`status`, `Accomodations`.`subline`, `Accomodations`.`height`, `Accomodations`.`video_url`, `Accomodations`.`opening_hours`, `Accomodations`.`premises`, `Accomodations`.`equipment`, `Accomodations`.`currency`, `Accomodations`.`detail_description`, `Accomodations`.`days_before_to_send_participant_list`, `Accomodations`.`country_id`, `Accomodations`.`url_booking_system`, (CONCAT_WS (',',`Accomodations`.`geopoint_lat`,`Accomodations`.`geopoint_long`)) AS `Accomodations__geopoint`, `AccomodationsTour`.`id`, `AccomodationsTour`.`tour_id`, `AccomodationsTour`.`accomodation_id`, `AccomodationsTour`.`overnight_stay`, `AccomodationsTour`.`number_participants`, `AccomodationsTour`.`number_mountain_guides`, `AccomodationsTour`.`reservation_type`, `AccomodationsTour`.`base_camp` FROM `alpinewelten`.`accomodations` AS `Accomodations` JOIN `alpinewelten`.`accomodations_tours` AS `AccomodationsTour` ON (`AccomodationsTour`.`tour_id` = 306 AND `AccomodationsTour`.`accomodation_id` = `Accomodations`.`id`)	6	6	1	maybe slow
SELECT `Countries`.`id`, `Countries`.`hash`, `Countries`.`created`, `Countries`.`updated`, `Countries`.`title`, `Countries`.`abbreviation`, `Countries`.`subtitle`, `Countries`.`link_embassy_german`, `Countries`.`link_embassy_austrian`, `Countries`.`link_embassy_swiss`, `Countries`.`link_embassy_italian`, `Countries`.`best_travel_season`, `Countries`.`general`, `Countries`.`security`, `Countries`.`nature_climate`, `Countries`.`travel_info`, `Countries`.`entry_customs`, `Countries`.`visa`, `Countries`.`health`, `Countries`.`tours_summer`, `Countries`.`tours_winter`, `Countries`.`microsite_id`, `CountriesTour`.`id`, `CountriesTour`.`country_id`, `CountriesTour`.`tour_id` FROM `alpinewelten`.`countries` AS `Countries` JOIN `alpinewelten`.`countries_tours` AS `CountriesTour` ON (`CountriesTour`.`tour_id` = 306 AND `CountriesTour`.`country_id` = `Countries`.`id`)	2	2	1	maybe slow
SELECT `RegionAreas`.`id`, `RegionAreas`.`hash`, `RegionAreas`.`created`, `RegionAreas`.`updated`, `RegionAreas`.`title`, `RegionAreas`.`region_id`, `RegionAreasTour`.`id`, `RegionAreasTour`.`region_area_id`, `RegionAreasTour`.`tour_id` FROM `alpinewelten`.`region_areas` AS `RegionAreas` JOIN `alpinewelten`.`region_areas_tours` AS `RegionAreasTour` ON (`RegionAreasTour`.`tour_id` = 306 AND `RegionAreasTour`.`region_area_id` = `RegionAreas`.`id`)	1	1	1
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 306 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1511) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	21	21	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 306 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	15	15	1	maybe slow
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (3000, 1722, 1511, 3017, 2996, 1611, 1433, 1724, 1602, 1440, 1465, 1890, 1996, 1679, 5803) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	169	169	2
SELECT `AccomodationImagesMedia`.`id`, `AccomodationImagesMedia`.`hash`, `AccomodationImagesMedia`.`created`, `AccomodationImagesMedia`.`updated`, `AccomodationImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `AccomodationImagesMedia`.`id`) AS `AccomodationImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `AccomodationImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 306 AND `MediaEntity`.`media_id` = `AccomodationImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'accomodation_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `VideoThumbnailMedia`.`id`, `VideoThumbnailMedia`.`hash`, `VideoThumbnailMedia`.`created`, `VideoThumbnailMedia`.`updated`, `VideoThumbnailMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `VideoThumbnailMedia`.`id`) AS `VideoThumbnailMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `VideoThumbnailMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 306 AND `MediaEntity`.`media_id` = `VideoThumbnailMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'video_thumbnail' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `OutputChannel`.`id`, `OutputChannel`.`hash`, `OutputChannel`.`created`, `OutputChannel`.`updated`, `OutputChannel`.`title`, `OutputChannel`.`abbreviation`, `OutputChannel`.`oa_offerer_id`, `FirmsTour`.`id`, `FirmsTour`.`firm_id`, `FirmsTour`.`tour_id`, `FirmsTour`.`position` FROM `alpinewelten`.`firms` AS `OutputChannel` JOIN `alpinewelten`.`firms_tours` AS `FirmsTour` ON (`FirmsTour`.`tour_id` = 306 AND `FirmsTour`.`firm_id` = `OutputChannel`.`id`) ORDER BY `FirmsTour`.`position` ASC	2	2	0
SELECT `TourFaqItemsForCustomer`.`id`, `TourFaqItemsForCustomer`.`hash`, `TourFaqItemsForCustomer`.`created`, `TourFaqItemsForCustomer`.`updated`, `TourFaqItemsForCustomer`.`title`, `TourFaqItemsForCustomer`.`target_group`, `TourFaqItemsForCustomer`.`tags`, `TourFaqItemsForCustomer`.`question`, `TourFaqItemsForCustomer`.`answer`, `TourFaqItemsForCustomer`.`login_required`, `TourFaqItemsForCustomer`.`highlight`, `TourFaqItemsForCustomer`.`always_show`, `FaqItemsTour`.`id`, `FaqItemsTour`.`tour_id`, `FaqItemsTour`.`faq_item_id`, `FaqItemsTour`.`position`, `FaqItemsTour`.`for` FROM `alpinewelten`.`faq_items` AS `TourFaqItemsForCustomer` JOIN `alpinewelten`.`faq_items_tours` AS `FaqItemsTour` ON (`FaqItemsTour`.`tour_id` = 306 AND `FaqItemsTour`.`faq_item_id` = `TourFaqItemsForCustomer`.`id`) WHERE `FaqItemsTour`.`for` = 'customer' AND `login_required` = '0' ORDER BY `FaqItemsTour`.`position` ASC	3	3	2	maybe slow
SELECT `TravelReport`.`id`, `TravelReport`.`hash`, `TravelReport`.`created`, `TravelReport`.`updated`, `TravelReport`.`title`, `TravelReport`.`status`, `TravelReport`.`release`, `TravelReport`.`hide`, `TravelReport`.`alias`, `TravelReport`.`country_id`, `TravelReport`.`tour_id`, `TravelReport`.`user_id`, `TravelReport`.`publishing_date`, `TravelReport`.`menu_id`, (NOW() BETWEEN COALESCE(`TravelReport`.`release`, NOW()) AND COALESCE(`TravelReport`.`hide`, NOW())) AS `TravelReport__published`, `ToursTravelReport`.`id`, `ToursTravelReport`.`tour_id`, `ToursTravelReport`.`travel_report_id`, `ToursTravelReport`.`position` FROM `alpinewelten`.`travel_reports` AS `TravelReport` JOIN `alpinewelten`.`tours_travel_reports` AS `ToursTravelReport` ON (`ToursTravelReport`.`tour_id` = 306 AND `ToursTravelReport`.`travel_report_id` = `TravelReport`.`id`) ORDER BY `ToursTravelReport`.`position` ASC	2	2	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 8 AND `Route`.`model` = 'TravelReport'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 143 AND `Route`.`model` = 'TravelReport'	1	1	0
SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 8 AND `Teaser`.`model` = 'TravelReport'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2784 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6753) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	17	17	1	maybe slow
SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 143 AND `Teaser`.`model` = 'TravelReport'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4110 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6774) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	16	16	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` IN (8, 143) AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'TravelReport' AND `TagEntity`.`field` = 'tags'	2	2	1	maybe slow
SELECT `Countries`.`id`, `Countries`.`hash`, `Countries`.`created`, `Countries`.`updated`, `Countries`.`title`, `Countries`.`abbreviation`, `Countries`.`subtitle`, `Countries`.`link_embassy_german`, `Countries`.`link_embassy_austrian`, `Countries`.`link_embassy_swiss`, `Countries`.`link_embassy_italian`, `Countries`.`best_travel_season`, `Countries`.`general`, `Countries`.`security`, `Countries`.`nature_climate`, `Countries`.`travel_info`, `Countries`.`entry_customs`, `Countries`.`visa`, `Countries`.`health`, `Countries`.`tours_summer`, `Countries`.`tours_winter`, `Countries`.`microsite_id`, `CountriesTravelReport`.`id`, `CountriesTravelReport`.`country_id`, `CountriesTravelReport`.`travel_report_id`, `CountriesTravelReport`.`position` FROM `alpinewelten`.`countries` AS `Countries` JOIN `alpinewelten`.`countries_travel_reports` AS `CountriesTravelReport` ON (`CountriesTravelReport`.`travel_report_id` IN (8, 143) AND `CountriesTravelReport`.`country_id` = `Countries`.`id`) ORDER BY `CountriesTravelReport`.`position` ASC	6	6	1	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 191 AND `Route`.`model` = 'Country'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 89 AND `Route`.`model` = 'Country'	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Country' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (191, 248, 46, 89) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `TourMainTypes`.`id`, `TourMainTypes`.`hash`, `TourMainTypes`.`created`, `TourMainTypes`.`updated`, `TourMainTypes`.`title`, `TourMainTypes`.`position`, `TourMainTypes`.`packing_list_text_start`, `TourMainTypes`.`packing_list_text_end`, `TourMainTypesTravelReport`.`id`, `TourMainTypesTravelReport`.`tour_main_type_id`, `TourMainTypesTravelReport`.`travel_report_id`, `TourMainTypesTravelReport`.`position` FROM `alpinewelten`.`tour_main_types` AS `TourMainTypes` JOIN `alpinewelten`.`tour_main_types_travel_reports` AS `TourMainTypesTravelReport` ON (`TourMainTypesTravelReport`.`travel_report_id` IN (8, 143) AND `TourMainTypesTravelReport`.`tour_main_type_id` = `TourMainTypes`.`id`) ORDER BY `TourMainTypesTravelReport`.`position` ASC	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'TourMainType' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `FaqItem`.`id`, `FaqItem`.`hash`, `FaqItem`.`created`, `FaqItem`.`updated`, `FaqItem`.`title`, `FaqItem`.`target_group`, `FaqItem`.`tags`, `FaqItem`.`question`, `FaqItem`.`answer`, `FaqItem`.`login_required`, `FaqItem`.`highlight`, `FaqItem`.`always_show` FROM `alpinewelten`.`faq_items` AS `FaqItem` WHERE `always_show` = '1'	0	0	0
SELECT `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight`, `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tours` AS `Tour` LEFT JOIN `alpinewelten`.`tour_texts` AS `TourTexts` ON (`TourTexts`.`tour_id` = `Tour`.`id`) WHERE `Tour`.`id` = 306 LIMIT 1	1	1	1
SELECT `TourRatingText`.`id`, `TourRatingText`.`hash`, `TourRatingText`.`created`, `TourRatingText`.`updated`, `TourRatingText`.`type`, `TourRatingText`.`level`, `TourRatingText`.`description`, `TourRatingText`.`tour_main_type_id` FROM `alpinewelten`.`tour_rating_texts` AS `TourRatingText` WHERE ((((`type` = 'rating_experience') AND (`level` = 2))) OR (((`type` = 'rating_condition') AND (`level` = 4))) OR (((`type` = 'rating_technique') AND (`level` = 4))) OR (((`type` = 'rating_seriousness') AND (`level` = 2))))	11	11	0
SELECT `Firm`.`id`, `Firm`.`title` FROM `alpinewelten`.`firms` AS `Firm` WHERE 1 = 1	3	3	0
SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `LogoMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1, 3, 2) AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Firm' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC	3	3	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (3850, 3849, 9556) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	3	3	0
SELECT `LogoHorizontalMedia`.`id`, `LogoHorizontalMedia`.`hash`, `LogoHorizontalMedia`.`created`, `LogoHorizontalMedia`.`updated`, `LogoHorizontalMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoHorizontalMedia`.`id`) AS `LogoHorizontalMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `LogoHorizontalMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1, 3, 2) AND `MediaEntity`.`media_id` = `LogoHorizontalMedia`.`id`) WHERE `MediaEntity`.`model` = 'Firm' AND `MediaEntity`.`field` = 'logo_horizontal' ORDER BY `MediaEntity`.`pos` ASC	3	3	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (9162, 9161, 9419) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	3	3	0
SELECT `News`.`id`, `News`.`title`, `News`.`type`, `News`.`publishing_date`, `News`.`external_url`, `News`.`target`, `News`.`safety`, `News`.`travel_warning`, `News`.`is_updated`, `User`.*, `Teaser`.`id`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Menu`.`id`, `User`.`id` FROM `alpinewelten`.`news` AS `News` LEFT JOIN `alpinewelten`.`menus` AS `Menu` ON (`News`.`menu_id` = `Menu`.`id`) LEFT JOIN `alpinewelten`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `News`.`id` AND `Teaser`.`model` = 'News') LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `News`.`id` AND `Route`.`model` = 'News') JOIN `alpinewelten`.`firms_news` AS `FirmsNews` ON (`FirmsNews`.`news_id` = `News`.`id` AND `FirmsNews`.`firm_id` = '3') LEFT JOIN `alpinewelten`.`news_tours` AS `TourNews` ON (`TourNews`.`news_id` = `News`.`id`) LEFT JOIN `alpinewelten`.`news_tour_main_types` AS `TourMainTypeNews` ON (`TourMainTypeNews`.`news_id` = `News`.`id`) LEFT JOIN `alpinewelten`.`countries_news` AS `CountryNews` ON (`CountryNews`.`news_id` = `News`.`id`) WHERE `News`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`News`.`release`, NOW()) AND COALESCE(`News`.`hide`, NOW())) = '1' AND `News`.`visibility_website` = '1' AND ((`TourNews`.`tour_id` = '306') OR (`TourMainTypeNews`.`tour_main_type_id` IN ('3', '3')) OR (`CountryNews`.`country_id` IN ('46', '248'))) GROUP BY `News`.`id` ORDER BY `publishing_date` DESC LIMIT 10	3	3	2	maybe slow
SELECT `AvatarWebsiteUpload`.`id`, `AvatarWebsiteUpload`.`hash`, `AvatarWebsiteUpload`.`created`, `AvatarWebsiteUpload`.`updated`, `AvatarWebsiteUpload`.`model`, `AvatarWebsiteUpload`.`field`, `AvatarWebsiteUpload`.`foreign_key`, `AvatarWebsiteUpload`.`alias`, `AvatarWebsiteUpload`.`thumbnail`, `AvatarWebsiteUpload`.`parent_id`, `AvatarWebsiteUpload`.`file`, `AvatarWebsiteUpload`.`size`, `AvatarWebsiteUpload`.`ext`, `AvatarWebsiteUpload`.`mime`, `AvatarWebsiteUpload`.`width`, `AvatarWebsiteUpload`.`height` FROM `alpinewelten`.`uploads` AS `AvatarWebsiteUpload` WHERE `AvatarWebsiteUpload`.`model` = 'User' AND `AvatarWebsiteUpload`.`field` = 'avatar_website' AND `AvatarWebsiteUpload`.`foreign_key` = (25) ORDER BY FIELD(COALESCE(`AvatarWebsiteUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3321 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2448) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3313 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (345) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3886 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (7326) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 61 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 60 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 80 AND `Route`.`model` = 'News'	1	1	0
SELECT `Audit`.`id`, `Audit`.`event`, `Audit`.`model`, `Audit`.`alias`, `Audit`.`entity_id`, `Audit`.`json_object`, `Audit`.`description`, `Audit`.`source_id`, `Audit`.`created` FROM `alpinewelten`.`audits` AS `Audit` WHERE `model` = 'News.News' AND `Audit`.`event` = 'CREATE' AND `Audit`.`entity_id` IN (61, 60, 80)	3	3	0
SELECT `User`.`id`, `User`.`hash`, `User`.`created`, `User`.`updated`, `User`.`activity`, `User`.`group_id`, `User`.`status`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`lastname`, `User`.`email`, `User`.`limit`, `User`.`language`, `User`.`email_signature`, `User`.`telephone`, `User`.`dept_for_trigger_mail`, `User`.`expert_text` FROM `alpinewelten`.`users` AS `User` WHERE `User`.`id` = 23	1	1	0
SELECT `AvatarWebsiteUpload`.`id`, `AvatarWebsiteUpload`.`hash`, `AvatarWebsiteUpload`.`created`, `AvatarWebsiteUpload`.`updated`, `AvatarWebsiteUpload`.`model`, `AvatarWebsiteUpload`.`field`, `AvatarWebsiteUpload`.`foreign_key`, `AvatarWebsiteUpload`.`alias`, `AvatarWebsiteUpload`.`thumbnail`, `AvatarWebsiteUpload`.`parent_id`, `AvatarWebsiteUpload`.`file`, `AvatarWebsiteUpload`.`size`, `AvatarWebsiteUpload`.`ext`, `AvatarWebsiteUpload`.`mime`, `AvatarWebsiteUpload`.`width`, `AvatarWebsiteUpload`.`height` FROM `alpinewelten`.`uploads` AS `AvatarWebsiteUpload` WHERE `AvatarWebsiteUpload`.`model` = 'User' AND `AvatarWebsiteUpload`.`field` = 'avatar_website' AND `AvatarWebsiteUpload`.`foreign_key` = (23) ORDER BY FIELD(COALESCE(`AvatarWebsiteUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `FileMedia`.`id`, `FileMedia`.`hash`, `FileMedia`.`created`, `FileMedia`.`updated`, `FileMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `FileMedia`.`id`) AS `FileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `FileMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (61, 60, 80) AND `MediaEntity`.`media_id` = `FileMedia`.`id`) WHERE `MediaEntity`.`model` = 'News' AND `MediaEntity`.`field` = 'file' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` IN (61, 60, 80) AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'News' AND `TagEntity`.`field` = 'tags'	3	3	0
SELECT `TourDate`.`id`, `TourDate`.`hash`, `TourDate`.`created`, `TourDate`.`updated`, `TourDate`.`status`, `TourDate`.`tour_id`, `TourDate`.`tour_date_number`, `TourDate`.`title`, `TourDate`.`subtitle`, `TourDate`.`participants_min`, `TourDate`.`participants_max`, `TourDate`.`duration_days`, `TourDate`.`tour_price`, `TourDate`.`down_payment`, `TourDate`.`country_of_service`, `TourDate`.`saison`, `TourDate`.`travel_insurance_certificate`, `TourDate`.`rating_condition`, `TourDate`.`rating_technique`, `TourDate`.`rating_experience`, `TourDate`.`rating_difficulty_category`, `TourDate`.`start_zip`, `TourDate`.`start_city`, `TourDate`.`start_street`, `TourDate`.`start_country`, `TourDate`.`start_meeting_point`, `TourDate`.`start_time`, `TourDate`.`end_alternate_address`, `TourDate`.`end_time`, `TourDate`.`flight`, `TourDate`.`flight_details`, `TourDate`.`region_id`, `TourDate`.`date_start`, `TourDate`.`mountain_guide_status`, `TourDate`.`manual_booking_status`, `TourDate`.`participant_list_visible`, `TourDate`.`speciality`, `TourDate`.`special_features`, `TourDate`.`mountain_guide_tour_info`, `TourDate`.`customer_tour_info`, `TourDate`.`ws_text_requirements`, `TourDate`.`ws_text_travel_program`, `TourDate`.`ws_text_accomodation`, `TourDate`.`ws_text_services`, `TourDate`.`rating_seriousness`, `TourDate`.`rating_overall_score`, `TourDate`.`infotext_booking`, `TourDate`.`last_minute`, `TourDate`.`travel_information`, `TourDate`.`meeting_point_map_lat`, `TourDate`.`meeting_point_map_marker`, `TourDate`.`meeting_point_map_type`, `TourDate`.`meeting_point_map_zoom`, `TourDate`.`meeting_point_map_long`, `TourDate`.`participant_list_visible2`, `TourDate`.`cancelled`, `TourDate`.`days_before_start_for_last_notice`, `TourDate`.`execution_feasibility`, `TourDate`.`days_before_start_for_cancellation`, `TourDate`.`ws_text_overview`, `TourDate`.`mountain_guide_tour_search_information`, `TourDate`.`allow_double_assignment`, `TourDate`.`customer_tour_material_info`, `TourDate`.`material_list_link`, `TourDate`.`minimum_reached_notification`, `TourDate`.`c19_cancellation`, `TourDate`.`ws_text_course_content`, `TourDate`.`ws_text_information`, `TourDate`.`gmap_marker`, `TourDate`.`ws_text_short_description`, `TourDate`.`gmap_type`, `TourDate`.`gmap_zoom`, `TourDate`.`ws_text_location_description`, `TourDate`.`ws_text_detail_description`, `TourDate`.`gmap_lat`, `TourDate`.`gmap_long`, `TourDate`.`callout_icon_multiple`, `TourDate`.`ws_text_advantages`, `TourDate`.`ws_text_detail_description_new`, `TourDate`.`ws_text_information_new`, `TourDate`.`ws_text_accomodation_new`, (CONCAT_WS (',',`TourDate`.`gmap_lat`,`TourDate`.`gmap_long`)) AS `TourDate__gmap`, (CONCAT_WS (',',`TourDate`.`meeting_point_map_lat`,`TourDate`.`meeting_point_map_long`)) AS `TourDate__meeting_point_map`, (COALESCE(`TourDate`.`end_zip`, `TourDate`.`start_zip`)) AS `TourDate__end_zip`, (COALESCE(`TourDate`.`end_city`, `TourDate`.`start_city`)) AS `TourDate__end_city`, (COALESCE(`TourDate`.`end_street`, `TourDate`.`start_street`)) AS `TourDate__end_street`, (COALESCE(`TourDate`.`end_country`, `TourDate`.`start_country`)) AS `TourDate__end_country`, (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) AS `TourDate__date_end`, (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')) AS `TourDate__count_participants`, (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`) AS `TourDate__count_mountain_guides`, (`TourDate`.`date_start` <= "2022-09-30" AND (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) >= "2022-06-01") AS `TourDate__peak_season`, (CONCAT((SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')), " + " , (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`))) AS `TourDate__participants_booked`, (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "bookings_present" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= 1 ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = 0 ) THEN 0 END)))WHEN 0 THEN "places_free" WHEN 1 THEN "bookings_present" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" END) AS `TourDate__booking_status`, ( IF( `TourDate`.`cancelled`, 'canceled', IF((SELECT SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) > 0 AND SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) = SUM(IF(`Booking`.`status` NOT IN ('new_from_website', 'waiting_list', 'called_off', 'canceled'), 1, 0)) FROM bookings AS Booking WHERE `Booking`.`tour_date_id` = `TourDate`.`id`), 'completed', 'in_process') )) AS `TourDate__processing_status`, (`TourDate`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tour_dates AS TourTravelOptionXTourDates inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTourDates`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTourDates`.`tour_date_id` = `TourDate`.`id`), 0)) AS `TourDate__price_excl_flight` FROM `alpinewelten`.`tour_dates` AS `TourDate` WHERE `TourDate`.`id` IS NULL LIMIT 1	0	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Firm`.`id`, `Firm`.`hash`, `Firm`.`created`, `Firm`.`updated`, `Firm`.`title`, `Firm`.`abbreviation`, `Firm`.`oa_offerer_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`languages` AS `Language` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Language`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`firm_id` = 1 LIMIT 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Firm`.`id`, `Firm`.`hash`, `Firm`.`created`, `Firm`.`updated`, `Firm`.`title`, `Firm`.`abbreviation`, `Firm`.`oa_offerer_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`languages` AS `Language` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Language`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`firm_id` = 3 LIMIT 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 474 AND `Menu`.`rght` < 519 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	22	22	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (705, 338, 195, 709, 696, 194, 327, 326, 532, 554, 686, 687, 707, 689, 337, 351, 544, 545, 685, 688, 697, 698) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_more' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 520 AND `Menu`.`rght` < 533 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	6	6	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (354, 356, 570, 355, 199, 357) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'wf' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Firm`.`id`, `Firm`.`hash`, `Firm`.`created`, `Firm`.`updated`, `Firm`.`title`, `Firm`.`abbreviation`, `Firm`.`oa_offerer_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`languages` AS `Language` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Language`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	3	3	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2, 3) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Tour' AND `Seo`.`foreign_key` = 306 LIMIT 1	1	1	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2584 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5814) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	1	maybe slow
SELECT `TourType`.`id`, `TourType`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) WHERE 1 = 1 GROUP BY `TourType`.`id` ORDER BY `TourType`.`title` ASC	40	40	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 184 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 976 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3735) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 621 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (184) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 184 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 184 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'text_search' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 740 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5141 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3879 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (740) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 740 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 740 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 420 AND `Menu`.`rght` < 425 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (712, 684) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'tour_list' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 426 AND `Menu`.`rght` < 473 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	23	23	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (201, 203, 634, 339, 204, 340, 341, 202, 342, 343, 344, 345, 346, 347, 348, 536, 738, 542, 543, 736, 325, 353, 476) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	20	20	0
SELECT `Highlight`.`id`, `Highlight`.`hash`, `Highlight`.`created`, `Highlight`.`updated`, `Highlight`.`status`, `Highlight`.`type`, `Highlight`.`tour_id`, `Highlight`.`manually_title`, `Highlight`.`manually_text`, `Highlight`.`manually_button_label`, `Highlight`.`manually_link`, `Highlight`.`position`, `Highlight`.`language_id`, `Highlight`.`manually_target_blank`, `Highlight`.`menu_id`, `Highlight`.`teaser_home_header`, `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight` FROM `alpinewelten`.`highlights` AS `Highlight` LEFT JOIN `alpinewelten`.`tours` AS `Tour` ON (`Highlight`.`tour_id` = `Tour`.`id`) WHERE `Highlight`.`type` = 'tour' AND `Highlight`.`teaser_home_header` = '1' AND `Highlight`.`language_id` = 3 ORDER BY `position` ASC	4	4	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 330 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 330 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9376) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	17	17	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 281 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 281 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (256) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 401 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 401 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 402 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 402 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (468) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `TourMainTypes`.`id`, `TourMainTypes`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) JOIN `alpinewelten`.`tour_main_types` AS `TourMainTypes` ON (`TourMainTypes`.`id` = `TourType`.`tour_main_type_id`) WHERE 1 = 1 ORDER BY `TourMainTypes`.`position` ASC	524	524	0
SELECT `Microsite`.`id`, `Microsite`.`hash`, `Microsite`.`created`, `Microsite`.`updated`, `Microsite`.`status`, `Microsite`.`title`, `Microsite`.`url`, `Microsite`.`position`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`microsites` AS `Microsite` LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Microsite`.`id` AND `Teaser`.`model` = 'Microsite') WHERE 1 = 1	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2951 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (52) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2952 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (459) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2953 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (688) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2954 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5427) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2955 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2275) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'wf' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'wf' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE 1 != 1 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	0	0	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'wf' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 185 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 977 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 622 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (185) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 185 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 185 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'difficulty-rating' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'contact' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'search' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'safety_instructions' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'travel_conditions' LIMIT 1	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 6689 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6689) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 6689 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 6690 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6690) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 6690 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 5529 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5529) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 5529 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'faq_index' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'news' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'myclimate' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'travel_reports_index' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 30.87 MB

Message	Memory use
Component initialization	1.77 MB
Controller action start	2.83 MB
Controller render start	8.79 MB
View render complete	11.93 MB

Timers

Total Request Time: 1286 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	111.00
Event: Controller.initialize	36.26
Event: Controller.startup	3.88
Controller action	276.90
Event: Controller.beforeRender	191.99
» Processing toolbar data	149.47
Rendering View	519.16
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendTours/View/FrontendTours/tour.php	382.04
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_detail_navigation.php	11.57
» » » Rendering APP/View/Elements/icon.php	10.07
» » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.50
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_mosaic.php	1.89
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_shortinfos.php	22.31
» » » Rendering APP/View/Elements/icon.php #2	9.85
» » » Rendering APP/View/Elements/icon.php #3	9.79
» » » Rendering APP/View/Elements/icon.php #4	0.29
» » » Rendering APP/View/Elements/icon.php #5	0.25
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_firm_banner.php	0.58
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_experience.php	61.60
» » » Rendering APP/View/Elements/icon.php #6	11.44
» » » Rendering APP/View/Elements/icon.php #7	9.54
» » » Rendering APP/View/Elements/icon.php #8	9.76
» » » Rendering APP/View/Elements/icon.php #9	9.46
» » » Rendering APP/View/Elements/icon.php #10	9.74
» » » Rendering APP/View/Elements/icon.php #11	9.34
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_requirements.php	2.57
» » » Rendering APP/View/Elements/icon.php #12	0.35
» » » Rendering APP/View/Elements/icon.php #13	0.33
» » » Rendering APP/View/Elements/icon.php #14	0.34
» » Rendering APP/View/Elements/icon.php #15	9.48
» » Rendering APP/Plugin/FrontendContents/View/Elements/tour_service_item.php	0.29
» » Rendering APP/Plugin/FrontendContents/View/Elements/tour_service_item.php #2	9.83
» » » Rendering APP/View/Elements/icon.php #16	9.29
» » Rendering APP/Plugin/FrontendContents/View/Elements/tour_service_item.php #3	0.27
» » Rendering APP/Plugin/FrontendContents/View/Elements/tour_service_item.php #4	0.26
» » Rendering APP/View/Elements/icon.php #17	9.32
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_dates_slider.php	28.96
» » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php	1.46
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #2	0.40
» » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #2	1.26
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #3	0.39
» » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #3	1.15
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #4	0.38
» » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #4	1.25
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #5	0.38
» » » Rendering APP/View/Elements/icon.php #18	9.24
» » » Rendering APP/View/Elements/icon.php #19	9.35
» » » Rendering APP/View/Elements/icon.php #20	0.34
» » » Rendering APP/View/Elements/icon.php #21	0.35
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser_slider.php	154.96
» » » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser.php	21.29
» » » » Rendering APP/View/Elements/icon.php #22	9.44
» » » » Rendering APP/View/Elements/icon.php #23	10.14
» » » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser.php #2	27.62
» » » » Rendering APP/View/Elements/icon.php #24	15.36
» » » » Rendering APP/View/Elements/icon.php #25	10.63
» » » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser.php #3	21.48
» » » » Rendering APP/View/Elements/icon.php #26	10.09
» » » » Rendering APP/View/Elements/icon.php #27	9.83
» » » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser.php #4	21.57
» » » » Rendering APP/View/Elements/icon.php #28	10.05
» » » » Rendering APP/View/Elements/icon.php #29	10.02
» » » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser.php #5	20.63
» » » » Rendering APP/View/Elements/icon.php #30	9.50
» » » » Rendering APP/View/Elements/icon.php #31	9.78
» » » Rendering APP/Plugin/FrontendAccomodations/View/Elements/teaser.php #6	20.45
» » » » Rendering APP/View/Elements/icon.php #32	9.66
» » » » Rendering APP/View/Elements/icon.php #33	9.54
» » » Rendering APP/View/Elements/icon.php #34	9.68
» » » Rendering APP/View/Elements/icon.php #35	9.66
» » Rendering APP/View/Elements/icon.php #36	0.25
» » Rendering APP/View/Elements/icon.php #37	0.24
» » Rendering APP/View/Elements/icon.php #38	0.37
» » Rendering APP/View/Elements/icon.php #39	0.34
» » Rendering APP/Plugin/FrontendNews/View/Elements/teaser_slider.php #2	37.62
» » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #7	2.09
» » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php	0.48
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php	0.44
» » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #8	2.07
» » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #2	0.47
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #2	0.54
» » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #9	1.26
» » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #3	0.42
» » » Rendering APP/View/Elements/icon.php #40	9.69
» » » Rendering APP/View/Elements/icon.php #41	9.58
» » » Rendering APP/View/Elements/icon.php #42	9.69
» » Rendering APP/Plugin/FrontendTravelReports/View/Elements/teaser.php #10	1.85
» » » Rendering APP/View/Elements/icon.php #43	0.62
» » Rendering APP/Plugin/FrontendTravelReports/View/Elements/teaser.php #11	0.65
» » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #6	0.43
» Rendering APP/Plugin/FrontendTours/View/FrontendTours/base.php	1.39
» » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #3	0.66
» Event: View.afterRender	0.13
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/3.php	132.65
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.90
» » Rendering APP/View/Elements/header/header.php	46.85
» » » Rendering APP/View/Elements/header/header_navbar.php	46.23
» » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.26
» » » » Rendering APP/View/Elements/navigation_secondary.php	23.31
» » » » » Rendering APP/View/Elements/icon.php #44	10.05
» » » » » Rendering APP/View/Elements/icon.php #45	0.62
» » » » » Rendering APP/View/Elements/icon.php #46	0.52
» » » » » Rendering APP/View/Elements/icon.php #47	9.71
» » » » Rendering APP/View/Elements/navigation.php	20.45
» » » » » Rendering APP/View/Elements/icon.php #48	0.59
» » » » » Rendering APP/View/Elements/icon.php #49	0.56
» » » » » Rendering APP/View/Elements/icon.php #50	0.52
» » » » » Rendering APP/View/Elements/icon.php #51	0.55
» » » » » Rendering APP/View/Elements/icon.php #52	0.51
» » » » » Rendering APP/View/Elements/icon.php #53	0.57
» » » » » Rendering APP/View/Elements/icon.php #54	0.38
» » » » » Rendering APP/View/Elements/icon.php #55	0.53
» » » » » Rendering APP/View/Elements/icon.php #56	0.53
» » » » » Rendering APP/View/Elements/icon.php #57	0.55
» » » » » Rendering APP/View/Elements/icon.php #58	0.53
» » » » » Rendering APP/View/Elements/icon.php #59	0.39
» » » » » Rendering APP/View/Elements/icon.php #60	0.55
» » » » » Rendering APP/View/Elements/icon.php #61	0.51
» » » » » Rendering APP/View/Elements/icon.php #62	0.55
» » » » » Rendering APP/View/Elements/icon.php #63	0.56
» » » » » Rendering APP/View/Elements/icon.php #64	0.59
» » » » » Rendering APP/View/Elements/icon.php #65	0.56
» » » » » Rendering APP/View/Elements/icon.php #66	0.53
» » » » » Rendering APP/View/Elements/icon.php #67	0.55
» » » » » Rendering APP/View/Elements/icon.php #68	0.52
» » » » » Rendering APP/View/Elements/icon.php #69	0.54
» » » » » Rendering APP/View/Elements/icon.php #70	0.40
» » Rendering APP/View/Elements/footer/footer.php	32.89
» » » Rendering APP/View/Elements/icon.php #71	10.53
» » » Rendering APP/View/Elements/icon.php #72	9.16
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.25
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.24
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.24
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.23
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.25
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php #2	0.23
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.28
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.25
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.31
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.24
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.24
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.24
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.24
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.25
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.25
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.24
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.23
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.24
» » Rendering APP/View/Elements/contact_widget.php	48.37
» » » Rendering APP/View/Elements/icon.php #73	9.33
» » » Rendering APP/View/Elements/icon.php #74	9.18
» » » Rendering APP/View/Elements/icon.php #75	9.26
» » » Rendering APP/View/Elements/icon.php #76	9.15
» » » Rendering APP/View/Elements/icon.php #77	9.26
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- _wizardVars(array)
 steps(array)
 0tour
 1tour_date
 2login
 3customer
 6overview
 currentSteptour
 redirectUrl(array)
 route2623
 queryNamestep
 stepTranslation(array)
 tourTour
 loginAnmelden
 customerPersönliche Daten
 tour_dateTourtermin
 fellow_travellersMitreisende
 optionsReiseoptionen
 insuranceReiseversicherung
 overviewÜberprüfen & Buchen
- canonicalUrlhttps://www.alpinewelten.com/alpenueberquerung-salzburg-triest-teil-1?step=tour
- news(array)
 0(array)
 News(array)
 id61
 titleDeutschland | Bergsport & Corona
 typecontent
 publishing_date2022-01-17
 external_url(null)
 target(null)
 safety(true)
 travel_warning(false)
 is_updated(true)
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2022-01-26 15:25:01
 group_id3
 statusactive
 username080573-H-51510
 passwordbbfcd1b3a8b9ab1238d0bb9c0ba97b67
 nameHans
 lastnameHonold
 emailhanshonold@alpinewelten.com
 limit100
 languagede
 email_signatureHans Honold | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-1
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Expeditionen, Polarforschung und Bergsteigen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id500132
 hash51cc28e1bfe6258422f2c9cf4b038d13
 created2020-11-05 16:50:42
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5fa41f561ea66.jpg
 size104668
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id500133
 hash7a1e9d03084551e33967a67d2316ac17
 created2020-11-05 16:50:46
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id500132
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5fa41f5620300.jpg
 size100367
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 Teaser(array)
 id3321
 titleDeutschland | Bergsport & Corona
 contentAllgemeine Covid-19 Hinweise zur Reiseplanung für Deutschland. Besonderheiten, die bei einer Hüttenübernachtung in Deutschland zu beachten sind.
 buttonHier erfährst du mehr
 ImageMedia(array)
 0(array)
 id2448
 hash7e93972627292c39a8114d4ddb88425b
 created2016-10-10 16:52:44
 updated2016-10-10 16:52:44
 titleDer Gipfel der Zugspitze erreicht ueber den Klettersteig Hoellental
 cross_reference_count2
 MediaEntity(array)
 id447400
 pos1
 media_id2448
 modelTeaser
 fieldimage
 foreign_key3321
 FileUpload(array)
 0(array)
 id27798
 hash1fc7238b59fa3b2863b5bf501592f56e
 created2016-10-10 16:52:38
 updated2016-10-10 16:52:44
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/57fbab3cd7da7.jpg
 size388432
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id153197
 hashfd72175663964bfc5f7c5109c91bb30b
 created2017-09-19 19:16:47
 updated2017-09-19 19:16:47
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id27798
 filewebroot/files/Media/File/ThTourHeaderImage/59c150fedef79.jpg
 size53313
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id448895
 hash1cd4e318bb8a75b44b82e014beebf9a8
 created2020-10-28 00:28:24
 updated2020-10-28 00:28:24
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id27798
 filewebroot/files/Media/File/ThMediaFileIndex/5f98ad1890a57.jpg
 size19833
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id448896
 hashe583a3411878670e9de24d5d40fe60fd
 created2020-10-28 00:28:25
 updated2020-10-28 00:28:25
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id27798
 filewebroot/files/Media/File/CkeditorXs/5f98ad18c963a.jpg
 size6802
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id448897
 hashf25d332746699467c74d4485633c3c7e
 created2020-10-28 00:28:25
 updated2020-10-28 00:28:25
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id27798
 filewebroot/files/Media/File/CkeditorSm/5f98ad191c765.jpg
 size19833
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id448898
 hashb1c0121165229d9ccdb53fd67a415748
 created2020-10-28 00:28:25
 updated2020-10-28 00:28:25
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id27798
 filewebroot/files/Media/File/CkeditorMd/5f98ad19564ef.jpg
 size31396
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id448899
 hash8b583c4031ac1139afb44ff1d25ad82a
 created2020-10-28 00:28:25
 updated2020-10-28 00:28:25
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id27798
 filewebroot/files/Media/File/CkeditorLg/5f98ad198b855.jpg
 size65028
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 7(array)
 id385691
 hash9cda723dd41a13149428b17cd917d81e
 created2020-08-18 12:57:34
 updated2020-08-18 12:57:34
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-thcountryteaserimage.jpg
 thumbnailth-country-teaser-image
 parent_id27798
 filewebroot/files/Media/File/ThCountryTeaserImage/5f3bb41eba1fa.jpg
 size53536
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 8(array)
 id385692
 hash1cdbca6a309f1d85eb4c01a4da917380
 created2020-08-18 12:57:35
 updated2020-08-18 12:57:35
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-thcountryteaserimagedesaturated.jpg
 thumbnailth-country-teaser-image-desaturated
 parent_id27798
 filewebroot/files/Media/File/ThCountryTeaserImageDesaturated/5f3bb41f132bc.jpg
 size38503
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 9(array)
 id602592
 hash37ef6e8bd85b0e0b09c5e28d4962dae0
 created2022-01-19 09:49:25
 updated2022-01-19 09:49:25
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-thteaserimageresponsive.jpg
 thumbnailth-teaser-image-responsive
 parent_id27798
 filewebroot/files/Media/File/ThTeaserImageResponsive/61e7d094ea693.jpg
 size53536
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 10(array)
 id602593
 hash3bdb161f97e4bf51f9120f6e69d7ef47
 created2022-01-19 09:49:25
 updated2022-01-19 09:49:25
 modelMedia
 fieldfile
 foreign_key2448
 aliasder-gipfel-der-zugspitze-erreicht-ueber-den-klettersteig-hoellental-thteaserimageresponsivedesaturated.jpg
 thumbnailth-teaser-image-responsive-desaturated
 parent_id27798
 filewebroot/files/Media/File/ThTeaserImageResponsiveDesaturated/61e7d09531928.jpg
 size38503
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 Menu(array)
 id(null)
 Route(array)
 id4697
 hashcdf2e7ea9a002ff75ebd4025393afdcf
 created2020-10-02 12:00:22
 updated2022-01-19 09:49:24
 modelNews
 foreign_key61
 base/
 aliasdeutschland-bergsport-corona
 controllerFrontendNews.FrontendNews
 actionnews
 parent_id(null)
 lft5907
 rght5908
 route/deutschland-bergsport-corona
 Audit(array)
 0(array)
 id5f76fa36-12fc-4590-a76f-79ea55ec31aa
 eventCREATE
 modelNews.News
 aliasNews
 entity_id61
 json_object{"News":{"id":"61","hash":"fd5c4a80ea658c6c2693ac01eec75b66","created":"2020-10-02 12:00:22","updated":"2020-10-02 12:00:22","title":"Deutschland | Bergsport & Corona","status":"inactive","type":"no_details","release":null,"hide":null,"publishing_date":"2020-10-02","customer_status":null,"visibility_website":"1","visibility_customer":"0","visibility_mountainguide":"0","mountain_guide_type":null,"target":null,"external_url":null,"menu_id":null,"alias":"","mountain_guide_qualification_category":null,"safety":false,"travel_warning":false,"is_updated":false}}
 description(null)
 source_id23
 created2020-10-02 12:00:22
 User(array)
 id23
 hashb7778096d248af34b9cce0f400fe278b
 created2015-10-02 09:36:34
 updated2021-11-15 08:56:10
 activity2022-01-26 16:50:28
 group_id3
 statusactive
 usernameh.stoeckl
 passworddbbcfb8dc20f56a809f28032a8cd0af4
 nameHansi
 lastnameStöckl
 emailinfo@alpinewelten.com
 limit100
 languagede
 email_signatureHansi Stöckl | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-2
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Gesamter Alpenraum und Skitourenreisen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id415437
 hash8d46892011673030d51c56d4196f9795
 created2020-10-20 11:25:07
 updated2020-10-20 11:25:11
 modelUser
 fieldavatar_website
 foreign_key23
 aliasavatar-hansi-webseite.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5f8eacf710d3f.jpg
 size25278
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id488137
 hashc5815bfe87b6c033b135f17bc5e095f6
 created2020-10-28 02:49:37
 updated2020-10-28 02:49:37
 modelUser
 fieldavatar_website
 foreign_key23
 aliasavatar-hansi-webseite-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id415437
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5f98ce31af752.jpg
 size47026
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 FileMedia(empty)
 TagsTag(array)
 0(array)
 id1087
 hasha9e7a4b7f9df2a9e3078ca180a0393c8
 created2020-03-04 14:58:40
 updated2020-03-04 14:58:40
 titlecorona
 scope(null)
 cross_reference_count123
 TagEntity(array)
 id33324
 tag_id1087
 modelNews
 fieldtags
 foreign_key61
 1(array)
 News(array)
 id60
 titleÖsterreich | Bergsport & Corona
 typecontent
 publishing_date2022-01-14
 external_url(null)
 target(null)
 safety(true)
 travel_warning(true)
 is_updated(true)
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2022-01-26 15:25:01
 group_id3
 statusactive
 username080573-H-51510
 passwordbbfcd1b3a8b9ab1238d0bb9c0ba97b67
 nameHans
 lastnameHonold
 emailhanshonold@alpinewelten.com
 limit100
 languagede
 email_signatureHans Honold | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-1
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Expeditionen, Polarforschung und Bergsteigen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id500132
 hash51cc28e1bfe6258422f2c9cf4b038d13
 created2020-11-05 16:50:42
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5fa41f561ea66.jpg
 size104668
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id500133
 hash7a1e9d03084551e33967a67d2316ac17
 created2020-11-05 16:50:46
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id500132
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5fa41f5620300.jpg
 size100367
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 Teaser(array)
 id3313
 titleÖsterreich | Bergsport & Corona
 contentAllgemeine Covid-19 Hinweise zur Reiseplanung für Österreich. Besonderheiten, die bei einer Hüttenübernachtung in Österreich zu beachten sind.
 buttonHier erfährst du mehr
 ImageMedia(array)
 0(array)
 id345
 hashd1e8a25d375936f4e7c6db5d7fa36798
 created2016-09-12 08:00:07
 updated2016-09-12 08:00:07
 titleGipfel Großglockner
 cross_reference_count4
 MediaEntity(array)
 id446646
 pos1
 media_id345
 modelTeaser
 fieldimage
 foreign_key3313
 FileUpload(array)
 0(array)
 id3274
 hash65b0c4c45aa0d680ad609c3ae003ce21
 created2016-09-12 08:00:03
 updated2016-09-12 08:00:07
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/57d64467c2c06.jpg
 size286710
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id591111
 hash4c1bd492d650bcb904dd3845d79d2400
 created2021-11-09 11:08:55
 updated2021-11-09 11:08:55
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id3274
 filewebroot/files/Media/File/ThTourHeaderImage/618a48b6e8190.jpg
 size47918
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 2(array)
 id434440
 hash6f73c458f18c464df1d9166f5dd6df12
 created2020-10-27 23:44:35
 updated2020-10-27 23:44:35
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id3274
 filewebroot/files/Media/File/ThMediaFileIndex/5f98a2d36490a.jpg
 size15466
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id434442
 hash31f206b21766a69a5f43653665332291
 created2020-10-27 23:44:36
 updated2020-10-27 23:44:36
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id3274
 filewebroot/files/Media/File/CkeditorXs/5f98a2d3b76fa.jpg
 size5406
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id434443
 hash085be9f65b1cc3dadcde8543d94e462f
 created2020-10-27 23:44:36
 updated2020-10-27 23:44:36
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id3274
 filewebroot/files/Media/File/CkeditorSm/5f98a2d40bd0e.jpg
 size15466
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id434445
 hash5b49e6337d756ff3499e5b7377d19fe8
 created2020-10-27 23:44:36
 updated2020-10-27 23:44:36
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id3274
 filewebroot/files/Media/File/CkeditorMd/5f98a2d449963.jpg
 size24273
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id434447
 hash2ac52a531f50c58c38428bef539c03c9
 created2020-10-27 23:44:36
 updated2020-10-27 23:44:36
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id3274
 filewebroot/files/Media/File/CkeditorLg/5f98a2d489fc4.jpg
 size47517
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 7(array)
 id560704
 hash1b5242a4a7a24f2bff8c1468040a4815
 created2021-07-27 11:35:34
 updated2021-07-27 11:35:34
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-thcountrycontentgalleryresponsive.jpg
 thumbnailth-country-content-gallery-responsive
 parent_id3274
 filewebroot/files/Media/File/ThCountryContentGalleryResponsive/60ffd366456ff.jpg
 size83771
 ext.jpg
 mimeimage/jpeg
 width1140
 height702
 8(array)
 id601713
 hash9ae6b998ffb3dff5bb7aa8c68781f13c
 created2022-01-14 17:08:19
 updated2022-01-14 17:08:19
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-thteaserimageresponsive.jpg
 thumbnailth-teaser-image-responsive
 parent_id3274
 filewebroot/files/Media/File/ThTeaserImageResponsive/61e19ff36c089.jpg
 size35407
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 9(array)
 id601714
 hash7233999d15053f5cec74a029b39fd6e5
 created2022-01-14 17:08:19
 updated2022-01-14 17:08:19
 modelMedia
 fieldfile
 foreign_key345
 aliasgipfel-grossglockner-thteaserimageresponsivedesaturated.jpg
 thumbnailth-teaser-image-responsive-desaturated
 parent_id3274
 filewebroot/files/Media/File/ThTeaserImageResponsiveDesaturated/61e19ff3952fc.jpg
 size27678
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 Menu(array)
 id(null)
 Route(array)
 id4689
 hashe8d8c3fcc9baf08d3398d1e02eb68652
 created2020-10-02 07:39:33
 updated2022-01-14 17:08:19
 modelNews
 foreign_key60
 base/
 aliasoesterreich-bergsport-corona
 controllerFrontendNews.FrontendNews
 actionnews
 parent_id(null)
 lft5905
 rght5906
 route/oesterreich-bergsport-corona
 Audit(array)
 0(array)
 id5f76bd15-a014-46d8-82db-081455ec31aa
 eventCREATE
 modelNews.News
 aliasNews
 entity_id60
 json_object{"News":{"id":"60","hash":"397dc697b52a40401cafabc8ebf9ecb1","created":"2020-10-02 07:39:33","updated":"2020-10-02 07:39:33","title":"\u00dcbernachten auf Bergh\u00fctten in Corona Zeiten","status":"active","type":"content","release":null,"hide":null,"publishing_date":"2020-10-02","customer_status":null,"visibility_website":"1","visibility_customer":"0","visibility_mountainguide":"0","mountain_guide_type":null,"target":null,"external_url":null,"menu_id":null,"alias":"","mountain_guide_qualification_category":null,"safety":true,"travel_warning":false,"is_updated":false}}
 description(null)
 source_id23
 created2020-10-02 07:39:33
 User(array)
 id23
 hashb7778096d248af34b9cce0f400fe278b
 created2015-10-02 09:36:34
 updated2021-11-15 08:56:10
 activity2022-01-26 16:50:28
 group_id3
 statusactive
 usernameh.stoeckl
 passworddbbcfb8dc20f56a809f28032a8cd0af4
 nameHansi
 lastnameStöckl
 emailinfo@alpinewelten.com
 limit100
 languagede
 email_signatureHansi Stöckl | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-2
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Gesamter Alpenraum und Skitourenreisen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id415437
 hash8d46892011673030d51c56d4196f9795
 created2020-10-20 11:25:07
 updated2020-10-20 11:25:11
 modelUser
 fieldavatar_website
 foreign_key23
 aliasavatar-hansi-webseite.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5f8eacf710d3f.jpg
 size25278
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id488137
 hashc5815bfe87b6c033b135f17bc5e095f6
 created2020-10-28 02:49:37
 updated2020-10-28 02:49:37
 modelUser
 fieldavatar_website
 foreign_key23
 aliasavatar-hansi-webseite-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id415437
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5f98ce31af752.jpg
 size47026
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 FileMedia(empty)
 TagsTag(array)
 0(array)
 id1087
 hasha9e7a4b7f9df2a9e3078ca180a0393c8
 created2020-03-04 14:58:40
 updated2020-03-04 14:58:40
 titlecorona
 scope(null)
 cross_reference_count123
 TagEntity(array)
 id33308
 tag_id1087
 modelNews
 fieldtags
 foreign_key60
 2(array)
 News(array)
 id80
 titleAGB Änderung buchen ohne Anzahlung
 typecontent
 publishing_date2020-03-15
 external_url(null)
 target(null)
 safety(false)
 travel_warning(false)
 is_updated(false)
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2022-01-26 15:25:01
 group_id3
 statusactive
 username080573-H-51510
 passwordbbfcd1b3a8b9ab1238d0bb9c0ba97b67
 nameHans
 lastnameHonold
 emailhanshonold@alpinewelten.com
 limit100
 languagede
 email_signatureHans Honold | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-1
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Expeditionen, Polarforschung und Bergsteigen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id500132
 hash51cc28e1bfe6258422f2c9cf4b038d13
 created2020-11-05 16:50:42
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5fa41f561ea66.jpg
 size104668
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id500133
 hash7a1e9d03084551e33967a67d2316ac17
 created2020-11-05 16:50:46
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id500132
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5fa41f5620300.jpg
 size100367
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 Teaser(array)
 id3886
 titleAGB Änderung buchen ohne Anzahlung
 content15.03.20 Wir ändern für Dich unser AGB! Buchen ohne Anzahlung auf allen unseren Reisen. Zahlungsziel erst 3 Tage vor Reisebeginn. 
 buttonHier erfährst du mehr
 ImageMedia(array)
 0(array)
 id7326
 hash7df08debf97028e9b58f099b07e821af
 created2020-03-31 09:58:17
 updated2020-03-31 11:35:03
 titlebuchen-ohne-anzahlung-header.jpeg
 cross_reference_count2
 MediaEntity(array)
 id402610
 pos1
 media_id7326
 modelTeaser
 fieldimage
 foreign_key3886
 FileUpload(array)
 0(array)
 id337204
 hash92ddc674ad5232b42e0e51eae4713edf
 created2020-03-31 11:35:01
 updated2020-03-31 11:35:03
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1.jpeg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5e830ec71b92b.jpeg
 size177294
 ext.jpeg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id477997
 hash90ea835a8dc3d61da653c347005a1c61
 created2020-10-28 02:08:53
 updated2020-10-28 02:08:53
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thmediafileindex.jpeg
 thumbnailth-media-file-index
 parent_id337204
 filewebroot/files/Media/File/ThMediaFileIndex/5f98c4a57e0af.jpeg
 size19034
 ext.jpeg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id477998
 hashf90d2e6f36181090766d4567f1f42de0
 created2020-10-28 02:08:54
 updated2020-10-28 02:08:54
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-ckeditorxs.jpeg
 thumbnailckeditor_xs
 parent_id337204
 filewebroot/files/Media/File/CkeditorXs/5f98c4a5b29df.jpeg
 size6380
 ext.jpeg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id477999
 hash266f89d365e8f9da9b61c80e8145d305
 created2020-10-28 02:08:54
 updated2020-10-28 02:08:54
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-ckeditorsm.jpeg
 thumbnailckeditor_sm
 parent_id337204
 filewebroot/files/Media/File/CkeditorSm/5f98c4a6049a9.jpeg
 size19034
 ext.jpeg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id478000
 hashf85c5468c28fd48dfbe9b7f3379fbfc7
 created2020-10-28 02:08:54
 updated2020-10-28 02:08:54
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-ckeditormd.jpeg
 thumbnailckeditor_md
 parent_id337204
 filewebroot/files/Media/File/CkeditorMd/5f98c4a639ead.jpeg
 size30060
 ext.jpeg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id478001
 hashbbabe0f787735f82e2088ddf0818b760
 created2020-10-28 02:08:54
 updated2020-10-28 02:08:54
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-ckeditorlg.jpeg
 thumbnailckeditor_lg
 parent_id337204
 filewebroot/files/Media/File/CkeditorLg/5f98c4a666108.jpeg
 size60469
 ext.jpeg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id550209
 hashf2d217fd1203353d4036216fa5376feb
 created2021-05-07 11:55:02
 updated2021-05-07 11:55:02
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thteaserimageresponsive.jpg
 thumbnailth-teaser-image-responsive
 parent_id337204
 filewebroot/files/Media/File/ThTeaserImageResponsive/60950e760c359.jpg
 size49857
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id550210
 hash4a471402fe5ef0c5db8aeda641e40aca
 created2021-05-07 11:55:02
 updated2021-05-07 11:55:02
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thteaserimageresponsivedesaturated.jpg
 thumbnailth-teaser-image-responsive-desaturated
 parent_id337204
 filewebroot/files/Media/File/ThTeaserImageResponsiveDesaturated/60950e7654ea2.jpg
 size40777
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 8(array)
 id550211
 hashed216dcbdae23d0b616bb5fbcb13ab5c
 created2021-05-07 11:55:03
 updated2021-05-07 11:55:03
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id337204
 filewebroot/files/Media/File/ThSeoImageFacebook/60950e769c2f7.png
 size337886
 ext.png
 mimeimage/png
 width720
 height405
 9(array)
 id550212
 hash28404480247b50cb7c40443607d5270e
 created2021-05-07 11:55:03
 updated2021-05-07 11:55:03
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id337204
 filewebroot/files/Media/File/ThSeoImageGoogle/60950e7719d89.png
 size337886
 ext.png
 mimeimage/png
 width720
 height405
 10(array)
 id550213
 hashf741c9e5eac4a77f04fb557f46f3aad2
 created2021-05-07 11:55:03
 updated2021-05-07 11:55:03
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id337204
 filewebroot/files/Media/File/ThSeoImageTwitter/60950e777363f.png
 size117291
 ext.png
 mimeimage/png
 width375
 height210
 11(array)
 id405994
 hash5b7b3d3ec6e1476d11fcfe17fd5b75a5
 created2020-09-29 16:46:18
 updated2020-09-29 16:46:18
 modelMedia
 fieldfile
 foreign_key7326
 aliasunknown-1-thmenuheaderimagessmooth.jpg
 thumbnailth-menu-header-images-smooth
 parent_id337204
 filewebroot/files/Media/File/ThMenuHeaderImagesSmooth/5f7348baa177e.jpg
 size176988
 ext.jpg
 mimeimage/jpeg
 width1140
 height300
 Menu(array)
 id(null)
 Route(array)
 id5287
 hash8d0aef30182a24690a9b757fe48eea88
 created2020-10-29 12:33:11
 updated2021-11-08 11:32:52
 modelNews
 foreign_key80
 base/
 aliasagb-aenderung-buchen-ohne-anzahlung
 controllerFrontendNews.FrontendNews
 actionnews
 parent_id(null)
 lft5999
 rght6000
 route/agb-aenderung-buchen-ohne-anzahlung
 Audit(array)
 0(array)
 id5f9aa877-a340-4f5b-a111-5b8755ec31aa
 eventCREATE
 modelNews.News
 aliasNews
 entity_id80
 json_object{"News":{"id":"80","hash":"4c18ad81c37cb4568cf4c3330b701cf2","created":"2020-10-29 12:33:11","updated":"2020-10-29 12:33:11","title":"AGB \u00c4nderung buchen ohne Anzahlung","status":"inactive","type":"content","release":null,"hide":null,"publishing_date":"2020-03-15","customer_status":null,"visibility_website":"1","visibility_customer":"0","visibility_mountainguide":"0","mountain_guide_type":null,"target":null,"external_url":null,"menu_id":null,"alias":"","mountain_guide_qualification_category":null,"safety":false,"travel_warning":false,"is_updated":false,"user_id":"25"}}
 description(null)
 source_id23
 created2020-10-29 12:33:11
 User(array)
 id23
 hashb7778096d248af34b9cce0f400fe278b
 created2015-10-02 09:36:34
 updated2021-11-15 08:56:10
 activity2022-01-26 16:50:28
 group_id3
 statusactive
 usernameh.stoeckl
 passworddbbcfb8dc20f56a809f28032a8cd0af4
 nameHansi
 lastnameStöckl
 emailinfo@alpinewelten.com
 limit100
 languagede
 email_signatureHansi Stöckl | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-2
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Gesamter Alpenraum und Skitourenreisen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id415437
 hash8d46892011673030d51c56d4196f9795
 created2020-10-20 11:25:07
 updated2020-10-20 11:25:11
 modelUser
 fieldavatar_website
 foreign_key23
 aliasavatar-hansi-webseite.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5f8eacf710d3f.jpg
 size25278
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id488137
 hashc5815bfe87b6c033b135f17bc5e095f6
 created2020-10-28 02:49:37
 updated2020-10-28 02:49:37
 modelUser
 fieldavatar_website
 foreign_key23
 aliasavatar-hansi-webseite-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id415437
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5f98ce31af752.jpg
 size47026
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 FileMedia(empty)
 TagsTag(array)
 0(array)
 id1087
 hasha9e7a4b7f9df2a9e3078ca180a0393c8
 created2020-03-04 14:58:40
 updated2020-03-04 14:58:40
 titlecorona
 scope(null)
 cross_reference_count123
 TagEntity(array)
 id30137
 tag_id1087
 modelNews
 fieldtags
 foreign_key80
- accomodations(array)
 376(array)
 id376
 hashc3d727575a9b1b650bc956f75c19df54
 created2018-07-02 17:02:21
 updated2020-09-02 15:19:01
 number900376
 nameStöhrhaus
 typecabin
 ownersHans und Walburga Gschoßmann
 phone_cabin+49 (0)8652-7233
 phone_valley
 mobile
 fax
 emailinfo@stoehrhaus.de
 urlhttps://www.stoehrhaus.de/die-huette/uebernachtung.html
 zip83471
 cityBerchtesgaden
 street
 countryDE
 region_area_id6
 remark
 geopoint_lat47.693089
 geopoint_long12.980508
 cancellation_period20
 tighter_cancellation_period(false)
 statusactive
 sublineStützpunkt am Hochplateau des sagenumwogenen Untersberg
 height1.894
 video_url
 opening_hours1008
 premisesDas Stöhrhaus liegt in unmittelbarer Nähe zum Berchtesgadener Hochtron am Untersberg in den Berchtesgadener Alpen. Das Stöhrhaus ist ein beliebter Stützpunkt für Kletterer, Höhlenforscher, Wanderer und Bergsteiger. Ein besonderes Erlebnis ist der Ausblick vom Hochplateau über die umliegenden Berge von Berchtesgaden. Der prominente Watzmann prägt das Bild. Die Hütte wurde frisch renoviert und die Küche ist hervorragend. Die Produkte stammen vorwiegend aus lokaler Produktion und werden auf der Hütte schmackhaft zubereitet. Unsere Bergwanderführer nutzen die Hütte für die geführte Wanderung Genusswandern in den Berchtesgadener Alpen, die geführte Alpenüberquerung von Salzburg nach Triest | Teil 1 und die geführte Themenwanderung Untersberg Intensiver Kraftberg.
 equipment13837
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id46
 url_booking_system(null)
 geopoint47.693089,12.980508
 AccomodationsTour(array)
 id685
 tour_id306
 accomodation_id376
 overnight_stay1
 number_participants8
 number_mountain_guides1
 reservation_type
 base_camp(false)
 Route(array)
 id3886
 hashe0122556989f3e00e9228b436504ee9d
 created2020-05-28 15:55:19
 updated2020-09-02 15:19:02
 modelAccomodation
 foreign_key376
 base/
 aliasstoerhaus
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5113
 rght5114
 route/stoerhaus
 TeaserMedia(array)
 0(array)
 id8470
 hashea9d3027c4ae9b35ff445f3a20658a58
 created2020-09-02 15:14:12
 updated2020-09-02 15:14:12
 titleStoehrhaus_Abend
 cross_reference_count3
 MediaEntity(array)
 id325229
 pos1
 media_id8470
 modelAccomodation
 fieldteaser
 foreign_key376
 FileUpload(array)
 0(array)
 id392374
 hashee15a62bae4c4c6aa370f669a133f832
 created2020-09-02 15:14:09
 updated2020-09-02 15:14:12
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f4f9aa48b11d.jpg
 size279512
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id483602
 hashbd1c20acd49aa7c59fb7664ded76b68f
 created2020-10-28 02:32:34
 updated2020-10-28 02:32:34
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id392374
 filewebroot/files/Media/File/ThMediaFileIndex/5f98ca31d810d.jpg
 size17251
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id483603
 hash0f044ac42efc266700b9dc9f0f2aa39d
 created2020-10-28 02:32:34
 updated2020-10-28 02:32:34
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id392374
 filewebroot/files/Media/File/CkeditorXs/5f98ca3219fc6.jpg
 size5906
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id483604
 hash74b4cf940b0a75be82634db2f1759541
 created2020-10-28 02:32:34
 updated2020-10-28 02:32:34
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id392374
 filewebroot/files/Media/File/CkeditorSm/5f98ca32658d7.jpg
 size17251
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id483605
 hash0a644ce66f9b3f6aec336af2bde98fdb
 created2020-10-28 02:32:34
 updated2020-10-28 02:32:34
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id392374
 filewebroot/files/Media/File/CkeditorMd/5f98ca32a137c.jpg
 size27535
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id483606
 hashf5e5d6f0e515612f387dc32f99e94e70
 created2020-10-28 02:32:35
 updated2020-10-28 02:32:35
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id392374
 filewebroot/files/Media/File/CkeditorLg/5f98ca32d4467.jpg
 size58038
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id431672
 hashe3137f233824bc86697bf5b479b017a1
 created2020-10-27 23:34:16
 updated2020-10-27 23:34:16
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id392374
 filewebroot/files/Media/File/ThSeoImageFacebook/5f98a067234bd.png
 size1359745
 ext.png
 mimeimage/png
 width1500
 height843
 7(array)
 id431673
 hash08fe296972972985f3f20b5983bd2a31
 created2020-10-27 23:34:17
 updated2020-10-27 23:34:17
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id392374
 filewebroot/files/Media/File/ThSeoImageGoogle/5f98a06876e09.png
 size1359745
 ext.png
 mimeimage/png
 width1500
 height843
 8(array)
 id489274
 hash2181d28343a554278478e869df7b8cf4
 created2020-10-28 15:50:55
 updated2020-10-28 15:50:55
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id392374
 filewebroot/files/Media/File/ThAccomodationTeaserImage/5f99854fb09fb.jpg
 size44060
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 9(array)
 id431674
 hasha70c5e7a266dce455ff94b88767c44cd
 created2020-10-27 23:34:18
 updated2020-10-27 23:34:18
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id392374
 filewebroot/files/Media/File/ThSeoImageTwitter/5f98a069d16d5.png
 size113614
 ext.png
 mimeimage/png
 width375
 height210
 10(array)
 id489275
 hash3b8b4fcf241a0e9fd3ef9b0fa152807f
 created2020-10-28 15:50:56
 updated2020-10-28 15:50:56
 modelMedia
 fieldfile
 foreign_key8470
 aliasstoehrhaus-abend-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id392374
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/5f99854feafd5.jpg
 size104816
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 59(array)
 id59
 hash199587514d200165b8672d58f7c62809
 created2015-12-01 15:49:48
 updated2021-07-29 08:46:17
 number900059
 nameKärlingerhaus
 typecabin
 ownersAndreas und Michael Bachmann Reservierungen: Marion Wiesenfarth +49176 432 275 87 marionwiesenfarth@hotmail.com
 phone_cabin+4986526091010
 phone_valley
 mobile00436504400371 Sophie
 faxstornofrist 5 Tage
 emailhuettenleben@gmx.at
 urlhttps://www.kaerlingerhaus.de/
 zip83471
 citySchönau am Königssee
 street
 countryDE
 region_area_id6
 remarkReservierung per Email oder Alpsonline
 geopoint_lat47.495548
 geopoint_long12.937217
 cancellation_period10
 tighter_cancellation_period(false)
 statusactive
 sublineMalerische Hütte im Herzen des Nationalparks in Berchtesgaden
 height1.631
 video_url
 opening_hours992
 premisesDer Nationalpark in Berchtesgaden benötigt nicht viel Beschreibung. Ein Naturparadies umrahmt von majestätischen Bergen, durchwachsen von Bächen und Seen, herausfordernde Klettertouren, und gemütliche Wanderungen. Ein Naturschauspie der Extraklasse. Das Kärlingerhaus liegt mitten im Nationalpark Berchtesgaden am malerischen Funtensee.
 equipment13835
 currency1
 detail_descriptionWir nutzen das Kärlingerhaus für viele verschiedene Touren. Angefangen von Wanderungen wie Wandern rund um den Königssee zum Watzmann, Wandern im Nationalpark Berchtesgaden, Die Watzmanntour und ready to go - Alpinwandern, über Alpenüberquerungen wie Alpenüberquerung von Salzburg nach Triest | Teil 1 und die Alpenüberquerung vom Watzmann zu den Drei Zinnen bis hin zur bekannten Skidurchquerung Große Reibn. Das Kärlingerhaus bietet extrem viele Tourenmöglichkeiten und ist mit seiner Lage für viele Touren ein wichtiger Standort. Gelegen ist die auch "Funtenseehaus" getaufte Hütte am kältesten Punkt Deutschlands dem Funtensee. Hier kommen die teils extremen Bedingungen im Winter durch einen so genannten „Kältesunk“ zusammen. Die kalte Luft sammelt sich durch die seitlich Aufsteigenden Hänge am tiefsten Punkt dem Funtensee. Schon wenige Meter höher ist es bereits viel wärmer. Im Sommer ist der See perfekt für ein erfrischendes Bad, denn auch wenn es der kälteste Ort Deutschlands ist, wärmt sich der See im Sommer auf angenehme Temperaturen auf. Auf dem Weg kann man auch gleich die „Teufelsmühle“, eine Gletschermühle mit Geschichte und die Brennhütte der Enzianbrennerei Grassl bewundern. Hier werden Enzian und Meisterwurz Wurzel gegraben und zu Schnaps gebrannt. Der Bergbrenner ist allerdings nicht jedes Jahr auf der Hütte. Das Kärlingerhaus liegt sehr zentral inmitten des Nationalparks. Die Aussicht von der Sonnenterasse auf die umliegenden Berge wie Schottmalhorn und Funtenseetauern ist gigantisch. Ein Anblick den man nicht so schnell vergisst. Das Haus an sich ist sehr groß und bietet mehr als 200 Personen einen Platz zum Schlafen. Die Verpflegung ist hervorragend und es bleiben keine Wünsche offen. Die gemütliche Gaststube lädt auf das eine oder andere Bier ein und garantiert einen gemütlichen Hüttenabend. Alles in allem ein Erlebnis welches noch Lange in Erinnerung bleiben wird. <h3>Öffnungszeiten:</h3> <ul> <li>Sommer: Ende Mai bis Mitte Oktober</li> <li>Winter: 2 Wochen um Ostern</li> </ul> <h3>Highlights:</h3> Über den Tag dem Konzert der Murmeltiere zu lauschen oder am morgen den Nebel über dem Funtensee zu bewundern ist ein wahres Fest. <h3>Erreichbarkeit | Zustieg:</h3> Die Hütte erreicht man üblicherweise von St. Bartholomä aus in ca. 4 Stunden oder von den Umgebenden Hütten wie zum Beispiel der Wasseralm (4-5 Stunden). <h3>Gut zu Wissen:</h3> <ul> <li>Es gibt keinen Handyempfang in der Umgebung und auch kein WLAN auf der Hütte.</li> </ul>
 days_before_to_send_participant_list(null)
 country_id46
 url_booking_system
 geopoint47.495548,12.937217
 AccomodationsTour(array)
 id686
 tour_id306
 accomodation_id59
 overnight_stay2
 number_participants8
 number_mountain_guides1
 reservation_type
 base_camp(false)
 Route(array)
 id3451
 hasha05a60abc0f54a28de29181399d9fbe6
 created2020-04-27 14:55:28
 updated2021-07-29 08:46:17
 modelAccomodation
 foreign_key59
 base/
 aliaskaerlingerhaus
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft4677
 rght4678
 route/kaerlingerhaus
 TeaserMedia(array)
 0(array)
 id1724
 hashc91d47247b78dcb8fdf6d40a36cda70c
 created2016-09-26 18:51:30
 updated2020-04-28 14:47:49
 titleHuettentour zum Kaerlingerhaus
 cross_reference_count12
 MediaEntity(array)
 id413281
 pos1
 media_id1724
 modelAccomodation
 fieldteaser
 foreign_key59
 FileUpload(array)
 0(array)
 id17513
 hash38ed101c9387eaede06870b70ff27ef5
 created2016-09-26 18:51:07
 updated2016-09-26 18:51:30
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/57e95212c1e26.jpg
 size304244
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id590128
 hash4e8136bd0d56b882655244bb0c222bcd
 created2021-11-09 10:22:54
 updated2021-11-09 10:22:54
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thtouraccomodationimages.jpg
 thumbnailth-tour-accomodation-images
 parent_id17513
 filewebroot/files/Media/File/ThTourAccomodationImages/618a3dee1270e.jpg
 size81989
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id561996
 hashee7d9315eafc921cf82d0aba2561b0ea
 created2021-07-29 08:46:17
 updated2021-07-29 08:46:17
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id17513
 filewebroot/files/Media/File/ThAccomodationTeaserImage/61024eb940b81.jpg
 size81989
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 3(array)
 id562001
 hash955a438054b1dc44d60343f0666d7682
 created2021-07-29 08:46:18
 updated2021-07-29 08:46:18
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id17513
 filewebroot/files/Media/File/ThSeoImageFacebook/61024eba52d87.png
 size617068
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id562002
 hash430f45ea7676842c4f2b66f8a5f74931
 created2021-07-29 08:46:18
 updated2021-07-29 08:46:18
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id17513
 filewebroot/files/Media/File/ThSeoImageGoogle/61024eba9bf83.png
 size617068
 ext.png
 mimeimage/png
 width720
 height405
 5(array)
 id562003
 hash176cf2483656d6dd9b726995543d678e
 created2021-07-29 08:46:19
 updated2021-07-29 08:46:19
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id17513
 filewebroot/files/Media/File/ThSeoImageTwitter/61024ebadb843.png
 size166347
 ext.png
 mimeimage/png
 width375
 height210
 6(array)
 id444030
 hash24471d829076b98bcf3a0a65fe221383
 created2020-10-28 00:14:25
 updated2020-10-28 00:14:25
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id17513
 filewebroot/files/Media/File/ThMediaFileIndex/5f98a9d1afc56.jpg
 size14158
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 7(array)
 id444031
 hash2ab026e44721e1a3354b4aaace7192aa
 created2020-10-28 00:14:26
 updated2020-10-28 00:14:26
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id17513
 filewebroot/files/Media/File/CkeditorXs/5f98a9d1de6e6.jpg
 size4286
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 8(array)
 id444032
 hash68dbb2c2e41117889e2defebf8a449ce
 created2020-10-28 00:14:26
 updated2020-10-28 00:14:26
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id17513
 filewebroot/files/Media/File/CkeditorSm/5f98a9d2258ae.jpg
 size14158
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 9(array)
 id444033
 hash13ba74562dcfbc378d1b9033dc3b3ec3
 created2020-10-28 00:14:26
 updated2020-10-28 00:14:26
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id17513
 filewebroot/files/Media/File/CkeditorMd/5f98a9d2513ac.jpg
 size23234
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 10(array)
 id444034
 hash56494d3bfdbc9c4ff3b4b7d7f13e7ad6
 created2020-10-28 00:14:26
 updated2020-10-28 00:14:26
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id17513
 filewebroot/files/Media/File/CkeditorLg/5f98a9d27849c.jpg
 size51784
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 11(array)
 id590725
 hash2b069d1d01a8ce2fd6aed390925cd620
 created2021-11-09 10:48:29
 updated2021-11-09 10:48:29
 modelMedia
 fieldfile
 foreign_key1724
 aliashuettentour-zum-kaerlingerhaus-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id17513
 filewebroot/files/Media/File/ThTourHeaderImage/618a43ed1a978.jpg
 size113207
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 381(array)
 id381
 hash5f5ebee5004886c7843654114b7962ca
 created2018-08-03 10:07:34
 updated2020-10-30 11:46:16
 number900381
 nameStatzerhaus
 typecabin
 ownersFamilie Hasenauer
 phone_cabin+43 6542 74438
 phone_valley +43 6542 74438
 mobile+43 664 1445952
 fax
 email
 url
 zip5761
 cityMaria Alm am Steinernen Meer
 streetAberg 63
 countryAT
 region_area_id150
 remark
 geopoint_lat47.338303
 geopoint_long12.911309
 cancellation_period20
 tighter_cancellation_period(false)
 statusactive
 sublineStützpunkt in den Salzburger Schieferalpen
 height2.117
 video_url
 opening_hours1008
 premisesDas Statzerhaus ist eine kleine Schutzhütte in den Salzburger Schieferalpen. Das Haus steht auf dem höchsten Grasberg Europas, dem Hundstein. Die Umgebung der Hütte ist geprägt von einer wildromantischen Almenlandschaft. Hier finden sich herrliche Wege um zu Wandern oder im Winter mit Schneeschuhen unterwegs zu sein. Die Verpflegung ist hervorragend und gekocht werden traditionelle lokale Gerichte. Ein mal im Jahr treffen sich hier Einheimische um zu „Rangeln“. Eine Form des Ringens welche als eine der fairsten Sportarten in Österreich gilt. Von der Hütte aus hat man einen hervorragenden Blick auf das umliegende Salzburger Land und die dazugehörigen Gipfel. Unsere Wanderführer nutzen das Statzerhaus für die geführte Alpenüberquerung von Salzburg nach Triest | Teil 1.
 equipment13839
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id248
 url_booking_system(null)
 geopoint47.338303,12.911309
 AccomodationsTour(array)
 id687
 tour_id306
 accomodation_id381
 overnight_stay3
 number_participants8
 number_mountain_guides1
 reservation_type
 base_camp(false)
 Route(array)
 id4028
 hashdeafc1d7f5eb85a4ef54d785e5077895
 created2020-07-02 14:00:10
 updated2020-10-30 11:46:17
 modelAccomodation
 foreign_key381
 base/
 aliasstatzerhaus
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5323
 rght5324
 route/statzerhaus
 TeaserMedia(empty)
 382(array)
 id382
 hash809eaf3cccef5432f41ff7f2c7a1718c
 created2018-08-03 10:11:24
 updated2020-08-21 11:23:12
 number900382
 nameSchutzhaus Neubau
 typecabin
 ownersAnita Maier & Manfred Hinterstoisser
 phone_cabin+43 6544 8181
 phone_valley+43 650 53 30 168 (Manfred)
 mobile+43 664 94 62 937 (Anita)
 fax
 emailschutzhaus-neubau@sbg.at
 urlhttp://www.schutzhaus-neubau.at/kontakt.html
 zip5630
 cityBad Hofgastein
 streetTauernstrasse 33
 countryAT
 region_area_id11
 remark
 geopoint_lat47.056229
 geopoint_long12.987664
 cancellation_period20
 tighter_cancellation_period(false)
 statusactive
 sublineSchutzhütte in den Hohen Tauern
 height2.175
 video_url
 opening_hours504
 premisesDas Schutzhaus Neubau liegt in Salzburg im Herzen vom Nationalpark Hohe Tauern. Am Fuße des Hohen Sonnblick gelegen ist das Schutzhaus die ideale Basis für Wanderungen und Bergtouren. Auch im Winter kommen hier Skitourengeher und Schneeschuhgeher vorbei, allerdings gibt es im Winter keine Möglichkeit zu übernachten. In der Goldberggruppe wurde, wie der Name schon erahnen lässt, Gold abgebaut. Die Hüttenwirte bieten eine freundliche Bewirtung und hervorragende Speisen. Von selbstgemachten Mehlspeisen bis hin zu Schnäpsen aus der Region gibt es viele Schmankerl die das Wanderherz höher schlagen lassen. Von der Hütte aus erreicht man Gipfel wie Alteck, Neunerkogel, Herzog-Ernst-Spitze, Hoher Sonnblick und Schareck. Unsere Wanderführer nutzen das Schutzhaus Neubau für die geführte Wanderung Alpenüberquerung von Salzburg nach Triest | Teil 1.
 equipment13855
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id248
 url_booking_system(null)
 geopoint47.056229,12.987664
 AccomodationsTour(array)
 id688
 tour_id306
 accomodation_id382
 overnight_stay4
 number_participants8
 number_mountain_guides1
 reservation_type
 base_camp(false)
 Route(array)
 id4036
 hashb2fcf6047f22539bb42523fc957518e6
 created2020-07-03 10:42:18
 updated2020-08-21 11:23:12
 modelAccomodation
 foreign_key382
 base/
 aliasschutzhaus-neubau
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5337
 rght5338
 route/schutzhaus-neubau
 TeaserMedia(empty)
 383(array)
 id383
 hasheb7df63e7ed4994ea6f8a3dbe7bbde9f
 created2018-08-03 10:22:24
 updated2020-08-21 11:23:42
 number900383
 nameFraganter Schutzhaus
 typecabin
 ownersPeter & Elisabeth Gastinger
 phone_cabin+43 4785 396
 phone_valley
 mobile+43 676 9563 490
 fax
 emailinfo@fraganter-schutzhaus.at
 urlhttp://www.fraganter-schutzhaus.at/
 zip9831
 cityFlattach
 streetGroßfragant 32
 countryAT
 region_area_id11
 remark
 geopoint_lat46.950848
 geopoint_long13.027639
 cancellation_period20
 tighter_cancellation_period(false)
 statusactive
 sublineStützpunkt in der Goldberggruppe
 height1.810
 video_url
 opening_hours1007
 premisesDas Fraganter Schutzhaus ist eine Schutzhütte in der Goldberggruppe in Kärnten. Die moderne Hütte wird gerne als Stützpunkt für ausgedehnte Wanderungen, Bergtouren und Mountainbike Touren genutzt. Auch im Winter eignet sich die Hütte hervorragend für Skitouren und Schneeschuhtouren. Die Hütte wurde 2005 komplett renoviert und bietet nun rund 100 Bergsteigern ein Nachtlager. Die Verpflegung ist hervorragend und gekocht werden regionale Spezialitäten. Von der Hütte aus erreicht man Gipfel wie Großer Sadnig, Makerni, Hirtenkopf, Striedenkopf, Klenitzen, Zeneberg, Stellkopf, Schobertörl und Sadnigscharte. Unsere Bergwanderführer nutzen das Fraganter Schutzhaus für die geführte Alpenüberquerung von Salzburg nach Triest | Teil 1
 equipment13919
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id248
 url_booking_system(null)
 geopoint46.950848,13.027639
 AccomodationsTour(array)
 id689
 tour_id306
 accomodation_id383
 overnight_stay5
 number_participants8
 number_mountain_guides1
 reservation_type
 base_camp(false)
 Route(array)
 id4047
 hash036a8e8318e6e73f56b2d8efe6cad477
 created2020-07-07 13:56:43
 updated2020-08-21 11:23:42
 modelAccomodation
 foreign_key383
 base/
 aliasfraganter-schutzhaus
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5359
 rght5360
 route/fraganter-schutzhaus
 TeaserMedia(empty)
 384(array)
 id384
 hash1bee2c09f94fd0c4350fb2f7be9bfcb1
 created2018-08-03 10:31:02
 updated2020-11-02 11:59:30
 number900384
 nameFeldnerhütte
 typecabin
 ownersBruno Langkau
 phone_cabin0049 814 525 535 96 oder 0043 676 748 1172
 phone_valley+43/676 7481172
 mobile+43/676 7481172
 fax
 emailfeldnerhuette@gmx.eu
 urlhttps://www.alpenverein.at/feldnerhuette/
 zip9761
 cityGnoppnitz
 street945/2
 country
 region_area_id11
 remark17. Juni 2018 - 16. September 2018 Voll bewirtschaftet.
 geopoint_lat46.832176
 geopoint_long13.125142
 cancellation_period20
 tighter_cancellation_period(false)
 statusactive
 sublineStützpunkt in der Kreuzeckgruppe
 height2.182
 video_url
 opening_hours480
 premisesDie Feldnerhütte ist eine Schutzhütte im Oberdrautal in Kärnten. Gelegen in der Kreuzeckgruppe ist die Hütte ein idealer Ausgangspunkt für Wanderungen und Bergtouren. Auch im Winter eignet sich der Winterraum der Hütte, um Skitouren und Schneeschuhtouren zu unternehmen. Bekannt ist die Kreuzeckgruppe für lange und ausdauernde Wanderungen. Die gemütliche Hütte bietet 32 Personen Platz und ist somit eine beschauliche kleine Hütte. Die bodenständige Küche des Hüttenwirts bietet eine willkommene Stärkung nach einer langen Tour. Von der Hütte aus erreicht man Gipfel wie Dechant, Kreuzeck, Hochkreuz und Tristen. Unsere Wanderführer nutzen die Feldnerhütte für die geführte Alpenüberquerung von Salzburg nach Triest | Teil 1.
 equipment13833
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id248
 url_booking_system(null)
 geopoint46.832176,13.125142
 AccomodationsTour(array)
 id690
 tour_id306
 accomodation_id384
 overnight_stay6
 number_participants8
 number_mountain_guides1
 reservation_type
 base_camp(false)
 Route(array)
 id4051
 hash9faaabc3e4aec13322022b290e0150f3
 created2020-07-07 16:35:56
 updated2020-11-02 11:59:30
 modelAccomodation
 foreign_key384
 base/
 aliasfeldnerhuette
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5365
 rght5366
 route/feldnerhuette
 TeaserMedia(empty)
- firms(array)
 1Alpine Welten
 3Bergsteigerschule Watzmann
 2Bergsteigerschule Zugspitze
- row(array)
 Tour(array)
 id306
 hash8fe61d89530cf7ed82fe6ac16ff9703f
 created2018-08-01 09:49:28
 updated2021-11-09 10:48:27
 tour_number418000000306
 titleAlpenüberquerung Salzburg - Triest | Teil 1
 subtitleVon den Berchtesgadener Alpen in die Hohen Tauern
 participants_min6
 participants_max8
 duration_days6
 duration_typetour_week
 tour_price1090.00
 down_payment20
 country_of_servicegermany
 saisonsummer
 travel_insurance_certificate(true)
 out_of_alpine_tour(false)
 rating_condition4
 rating_technique4
 rating_experience2
 rating_difficulty_categorymedium
 rating_seriousness2
 rating_overall_score3.0
 start_zip83487
 start_cityMarkt Schellenberg
 start_street
 start_countryDE
 start_meeting_pointist der Wanderparkplatz zur Toni Lenz Hütte und der Schellenberger Eishöhle an der B305
 start_time10:00:00
 end_alternate_address(false)
 end_zip83487
 end_cityMarkt Schellenberg
 end_street
 end_countryDE
 end_time18:00:00
 flight(false)
 flight_details(null)
 consultation
 region_id9
 services_excluded
 mountain_guide_tour_info3. Tag: Kärlingerhaus -Riemannhaus -Maria Alm -Gasthof Christernreith –Statzerhaus Früher Start!!!! Min 7 Stunden Gehzeit!! Überquerung des Steinernen Meeres bis zum Riemannhaus. Hier kannst Du Mittag machen. Der Abstieg vom Riemannhaus ist steil und mit einem Drahtseilgeländer und Stufen gesichert. Du solltest das Taxi Pfeiffer bereits am VORTAG reservieren für die Abholung am Parkplatz Sanden. Du benötigst vom Riemannhaus zum Parkpatz 2,5 -3 Stunden. Wenn Du schneller bist, kannst Du ab der Seilbahnstation Materialseilbahn telefonieren -Du benötigst dann noch 45 min -1 Stunde. Taxi Pfeiffer: +436584201 Zustieg zum Statzerhaus: erfolgt vom Gasthof Christernreith am Aberg. Zu diesem malerisch gelegenen Berggasthof kann vom Ortsteil Unterberg in Maria Alm zugefahren werden. Nach einem Anstieg über die Schrambachalm und untere Lohningalm vereint sich dieser Weg nahe der Grießbachhütte mit jenem von der Bergstation der Schwarzeckalmbahn. Auf relativ flachem Weg wird dann von der Bergstation in Richtung Abergalm – Grießbachhütte – Hundstein gewandert. 
 video_url
 customer_tour_info
 firm_id1
 gmap_zoom13
 gmap_long13.038942
 gmap_marker(false)
 gmap_typeoa_topo
 gmap_lat47.708492
 callout_iconnone
 travel_information<h3>Details Anreise:</h3> Treffpunkt zur Tour ist am Wanderparkplatz zur Toni-Lenz-Hütte und der Schellenberger Eishöhle an der B305 hinter Marktschellenberg in Richtung Salzburg fahrend, nahe der Bushaltestelle "Abzweig Eishöhle". Der Parkplatz ist kostenfrei. <h3>Bahnanreise:</h3> Die Anreise ins Berchtesgadener Land ist auch mit öffentlichen Verkehrsmitteln recht gut möglich, von München aus in ca. 2,5 Stunden. Mit der Bahn geht es zunächst bis Salzburg und von dort mit dem Bus (Linie 840) weiter bis zur Haltestelle "Abzweig Eishöhle". Alternativ geht die Fahrt auch über Berchtesgaden, wenn Du bereits vorher ins Berchtesgadener Land reisen möchtest. Zum Treffpunkt kommst Du vom Hauptbahnhof Berchtesgaden in ca. 20 Minuten mit der Linie 840 Richtung Salzburg. <h3>Unterkunftsempfehlung:</h3> Wenn Du in Salzburg übernachten möchtest, empfehlen wir Dir, eine Unterkunft über <a href="http://booking.com" target="_blank">booking.com</a> zu suchen. Hier hast Du oft auch die Möglichkeit bis kurz vorher kostenfrei zu stornieren. Wenn Deine Reise über Berchtesgaden führt, ist eine gute Unterkunft in Berchtesgaden das Explorer Hotel. Das Hotel ist auf bergsportliche Gäste ausgerichtet und bietet saubere, moderne Zimmer, eine Bar und Lounge sowie einen Wellness- und Fitnessbereich. Wenn Du eine Übernachtungsmöglichkeit vor oder nach der Tour suchst, wende Dich bitte direkt an die Unterkunft. <h3>Explorer Hotel Berchtesgaden</h3> Hofreitstraße 7 83471 Schönau am Königssee Tel.: +49 8652 9771500 Fax: +49 8652 977150210 Email: <a href="mailto:berchtesgaden@explorer-hotels.com">berchtesgaden@explorer-hotels.com</a> <a href="http://www.explorer-hotels.com/berchtesgaden/" target="_blank">www.explorer-hotels.com/berchtesgaden/</a>
 meeting_point_map_lat47.705273
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_topo
 meeting_point_map_zoom10
 meeting_point_map_long13.038899
 previous_url
 packing_list_text_end<h2>Tipps zur Ausrüstung beim Wandern</h2> Du solltest Deinen Rucksack bereits zu Hause “Probepacken”, um zu sehen, ob alles in den Rucksack passt und wie das Gewicht ist. Gerade bei Mehrtagestouren solltest Du zwingend auf ein minimales Gewicht achten! Hier zählt tatsächlich jedes Gramm, welches zu viel ist! Für Wanderungen haben wir besondere Empfehlungen für Dich: Ein spezieller Packsack oder alternativ ein Müllsack sowie ein Regenschirm/Knirps halten Dich und Deine Bekleidung trocken. Nicht zwingend notwendig, aber hilfreich sind Wanderstöcke. Häufige Fragen zur Ausrüstung werden auch hier geklärt. <h2>Unser Shop-Partner</h2> Die Bergfreunde sind der richtige Ansprechpartner, wenn es um Bergsport-Ausrüstung geht! <figure class="figure-responsive" data-blank="1" data-url="https://www.bergfreunde.de/?pid=15321&wt_mc=de.affiliate.qc.15321.-.-&utm_source=sonstige-affiliates&utm_medium=cpo-variabel&utm_campaign=alpinewelten"> <div class="img-responsive" data-media-id="5141" data-media-thumbnail="ckeditor_md"> </div> <figcaption class="hidden"></figcaption> </figure> <h2>Das Alpine Welten Base Camp Duffle</h2> Das Duffle Bag ist ideal für alle Bergreisen und Kurse geeignet. Die Größe ist so dimensioniert, dass auch Skischuhe und Gepäck für eine längere Reise in die Tasche passen. Ideal ist die Tragefunktion - Rucksack für alle Skitouren-, Hochtouren- und Klettersteigkurse! <a href="https://www.alpinewelten.com/shop/base-camp-duffle" target="_blank">HIER Bestellen</a> <figure class="figure-responsive" data-blank="1" data-url="https://www.alpinewelten.com/shop/base-camp-duffle"> <div class="img-responsive" data-media-id="5397" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> 
 packing_list_text_start
 days_before_start_for_cancellation24
 execution_feasibilitylow
 days_before_start_for_last_notice24
 last_tour_date_number135
 tourstart_weekday32
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 callout_icon_multiple4
 microsite_id(null)
 is_archive(false)
 is_service(false)
 covid_note(true)
 gmap47.708492,13.038942
 meeting_point_map47.705273,13.038899
 price_excl_flight1090.00
 highlight0
 FirmsTour(array)
 id23403
 firm_id3
 tour_id306
 position2
 Microsite(array)
 id(null)
 hash(null)
 created(null)
 updated(null)
 status(null)
 title(null)
 url(null)
 position(null)
 Firm(array)
 titleAlpine Welten
 id1
 LogoMedia(array)
 0(array)
 id9556
 hash9d1dc5327ed06092d72f1b91c05629c3
 created2020-11-11 11:34:07
 updated2020-11-11 11:34:07
 titleLogo Alpine Welten Durchgeführt von Solo grau
 cross_reference_count1
 MediaEntity(array)
 id366036
 pos1
 media_id9556
 modelFirm
 fieldlogo
 foreign_key1
 FileUpload(array)
 0(array)
 id503138
 hash12aa8b8770a087d460c017b8047753d5
 created2020-11-11 11:33:39
 updated2020-11-11 11:34:07
 modelMedia
 fieldfile
 foreign_key9556
 aliasdurchgefuert-alpinewelten-solo-grau.svg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fabbe1fa263e.svg
 size6140
 ext.svg
 mimeimage/svg+xml
 width(null)
 height(null)
 LogoHorizontalMedia(array)
 0(array)
 id9419
 hasha1aea2a10ba9a7a51a5dc1caae2ead48
 created2020-10-28 09:05:20
 updated2020-10-28 10:48:03
 titleDurchgeführt von Alpine Welten solo long
 cross_reference_count1
 MediaEntity(array)
 id366037
 pos1
 media_id9419
 modelFirm
 fieldlogo_horizontal
 foreign_key1
 FileUpload(array)
 0(array)
 id488646
 hashc1c3200e74a46accb46c56242c609a57
 created2020-10-28 10:48:01
 updated2020-10-28 10:48:03
 modelMedia
 fieldfile
 foreign_key9419
 aliasdurchgefuert-alpinewelten-solo-long.svg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f993e530f359.svg
 size4932
 ext.svg
 mimeimage/svg+xml
 width(null)
 height(null)
 TourTexts(array)
 id296
 hashab0eeb8e5c74521ee36f49b02cf8f59c
 created2018-08-01 09:49:28
 updated2021-11-09 10:48:30
 tour_id306
 ws_text_short_descriptionAlpenüberquerung von Salzburg nach Greifenburg. Eine anspruchsvolle Wanderung abseits der bekannten Pfade. Ruhe, Einsamkeit und Erholung sind garantiert. Wir überqueren den Alpenhauptkamm und beenden die Tour vor den Toren Sloweniens. Im ersten Teil beginnt die Wanderung in den Berchtesgadener Alpen und führt uns durch die Hohen Tauern bis vor den Karnischen Hauptkamm. Von dort treten wir die Rückreise an.
 ws_text_requirementsMittelschwere & schwere Bergwege ROT & SCHWARZ. Für diese geführte Alpenüberquerung von Salzburg nach Greifenburg solltest Du als erfahrener Bergwanderer über eine sehr gute Kondition für Gehzeiten bis 7 Stunden verfügen. Die Aufstiege bei der Alpenüberquerung betragen maximal 1.500 Höhenmeter am Tag. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt beim Wandern ca. 300 Höhenmeter pro Stunde. Ausgesetzte, versicherte oder absturzgefährdete Stellen sind auf der Alpenüberquerung von Salzburg nach Triest sehr wenige zu erwarten. Es gibt eine Stelle dieser Kategorie ab dem Riemannhaus, welche Trittsicherheit und Schwindelfreiheit erfordert. <h3>Mäßige Alpine Erfahrung | Mittlere alpine Unternehmung</h3> <ul> <li>Mäßige Ernsthaftigkeit / Gefährdung</li> <li>Erfahrung Bergwandern</li> <li>Trittsicherheit und Schwindelfreiheit</li> <li>Teamfähigkeit für Alpenüberquerung in einer Gruppe</li> </ul> 1.500 Hm1.400 Hm800m7 hROT - SCHWARZFrühstück 
 ws_text_travel_program<h3>1. Tag: Über den Untersberg zum Stöhrhaus</h3> Treffpunkt am Vormittag am Wanderparkplatz in Markt Schellenberg. Nach einem kurzen Ausrüstungscheck begeben wir uns zur Talsation der Untersbergseilbahn, mit der wir uns den Aufstieg verkürzen. Die anschließende Wanderung über das Hochplateau des sagenumwobenen Untersbergs gibt einen Vorgeschmack auf die kommenden Wandertage. Als perfekter Stützpunkt dient uns das Stöhrhaus. Bei traditioneller Küche und einheimischen Spezialitäten lassen wir den Abend auf der Panoramaterrasse gemütlich ausklingen. Unser Blick schweift über den Berchtesgadener Talkessel und König Watzmann thront majestätisch vor uns. 600m700m 600 Hm 4 h sehr schwerHalbpension <h3>2. Tag: Über den Königssee in den Nationalpark Berchtesgaden</h3> Nach dem Früstück starten wir mit dem Abstieg vom Untersberg. Vorbei am Reißenkaser führt uns unser Weg nach Bischofswiesen. Von hier nehmen wir den Bus zum Königssee. Mit dem Schiff geht es über den See hinein ins Herz des Nationalparks Berchtesgaden. Der Blick schweift über die legendäre Watzmann Ostwand und die Wallfahrtskapelle St. Bartholomä könnte keinen besseren Kontrast dazu geben. Unser weiterer Weg führt uns über die vielen Serpentinen der Saugasse aufs Kärlingerhaus, unser heutiges Etappenziel. 1.300 Hm 1.200 Hm 800m 6 - 7 h sehr schwerHalbpension <h3>3. Tag: Durch das Steinerne Meer zum Riemannhaus</h3> Vor uns liegt das Steinerne Meer! Vorbei an Zirbelkiefern, die wir sicher auch in flüssiger Form verkosten werden, geht es mitten hinein in das schroffe Gelände. Am Riemannhaus angekommen machen wir eine kurze Rast und setzen unseren Weg auf den Spuren der Wallfahrer fort. Von Maria Alm verkürzen wir den Aufstieg zum Statzerhaus mit dem Taxi. Nach einem längeren Aufstieg erreichen wir das Statzerhaus, genießen die letzten Sonnenstrahlen und lassen den Tag ganz entspannt ausklingen. 1.500 Hm 1.100 Hm 800m 7 h sehr schwerHalbpension <h3>4. Tag: Von Taxenbach ins Rauriser Tal</h3> Vom Statzerhaus geht es heute hinab nach Taxenbach. Der Weg schlängelt sich durch die fantastische Landschaft, die von der Landwirtschaft stark geprägt wurde. Von Taxenbach aus verkürzen wir den Weg ins Rauriser Tal mit dem Taxi und treten den Weg zum Schutzhaus Neubau an. Vorbei am Naturfreundehaus und den Giganten den Rauriser Tals zu unserer Rechten, führt uns der Weg zu unserer gemütlichen Unterkunft. 800 Hm 1.400 Hm 800m 7 h sehr schwerHalbpension <h3>5. Tag: Vorbei am Hohen Sonnblick zur Fraganter Schutzhaus</h3> Nach dem Frühstück machen wir uns wieder auf den Weg, der uns vorbei am Hohen Sonnblick in Richtung Fraganter Schutzhaus führt. Die heutige Etappe ist unserer längste auf diesem Teil der Alpenüberquerung. Wir machen viele Höhenmeter im Auf- und Abstieg und am Ende dieser langen Etappe werden wir mit leckerem Essen auf unserer heutigen Berghütte begrüßt und für die Anstrengungen des Tages belohnt. 1.500 Hm 1.100 Hm 800m 6 - 7 h sehr schwerHalbpension <h3>6. Tag: Kreuzeckgruppe und Feldnerhütte</h3> Vom Fraganter Schutzhaus gehen wir hinunter nach Innerfragant. Hier bringt uns ein Taxi ins nächste Tal und wir steigen auf die Feldner Hütte auf. Der abwechslungsreiche Weg führt uns in Richtung Kreuzeck, den höchsten Berg der Kreuzeckgruppe. Nach dem Glenktörl erreichen wir nach einem kurzen Abstieg unser heutiges Ziel - die Feldnerhütte. Den letzten Abend lassen wir in gemütlicher Atmosphäre ausklingen und lassen das Erlebte noch einmal Revue passieren. 950 Hm 1.000 Hm 800m 6 h sehr schwerHalbpension <h3>7. Tag: Über den Höhenweg und Abstieg ins Tal</h3> Heute steht die letzte Etappe unserer Wanderung an. Über den Höhenweg vorbei am Stawipfel steigen wir immer weiter ins Tal ab. Immer näher kommen wir dem Ziel unseres letzten gemeinsamen Tages. Ein letztes mal bewundern wir die österreichische Bergwelt und lassen uns von den Eindrücken der letzten Tage verzaubern. Der lange Abstieg bietet die perfekte Gelegenheit, die erste Etappe unserer Wanderung abzuschließen. 300 Hm 1.900 Hm 800m 6 h sehr schwerFrühstück
 ws_text_services<ul> <li>Speisen und Getränke außerhalb der Halbpension</li> <li>Parkplatzgebühren bei PKW-Anreise</li> <li>Individuelle Trinkgelder</li> </ul>
 ws_text_information<h3>Mindestteilnehmerzahl</h3> Diese Reise kann nur ab der oben angegebenen Mindestteilnehmerzahl durchgeführt werden. Sollte diese 20 Tage vor Antritt der Reise nicht erreicht sein, so kann eine Absage durch den Veranstalter erfolgen. Im Falle einer Absage ist dieser bestrebt, Dir ein Alternativangebot zu unterbreiten. Bitte beachte hierzu unsere ergänzenden Hinweise in den Reisebedingungen. <h3>Reiseveranstalter</h3> Reiseveranstalter ist Alpine Welten Die Bergführer GmbH & Co. KG, Rauher Berg 8, 89180 Berghülen <h3>Versicherungen</h3> Wir empfehlen Dir dringend den Abschluss einer Reiserücktrittsversicherung sowie einer Versicherung zur Deckung der Rückführungskosten bei Unfall oder Krankheit. Bitte prüfe hierfür Deinen Versicherungsschutz. Im Verlauf der Buchung besteht entsprechende Möglichkeit diesen Versicherungsschutz herzustellen. Ebenso empfehlen wir für unsere Bergreisen den Abschluss einer Auslandsreisekrankenversicherung zur Deckung von ausländischen Selbstbehalten. Die Mitgliedschaft in einem alpinen Verein (z. B. Deutscher Alpenverein, Österreichischer Alpenverein) deckt bereits die Kosten einer eventuellen Hubschrauberrettung ab und wird von uns empfohlen. <h3>Weiterführende Informationen</h3> Bitte beachte folgenden Link Wichtige Hinweise zu Reisen mit besonderen Risiken
 ws_text_location_descriptionDer Untersberg ist das nördlichstes Massiv der Berchtesgadener Alpen und liegt in den Ländern Bayern und Salzburg. Hauptsächlich besteht der Berg aus einem ausgeprägten Gipfelplateau und verfügt über die Hauptgipfel Berchtesgadener Hochthron (1972 m) und Salzburger Hochthron (1853 m). Der Berg weist zahlreiche Höhlensysteme auf, darunter die als Schauhöhle erschlossene Schellenberger Eishöhle und die Riesending Schachthöhle. Mitunter bedingt durch die Höhlen ranken sich zahlreiche Sagen und Mythen um den Untersberg. Der Königssee ist ein langgestreckter Gebirgssee am östlichen Fuß des Watzmanns und wird im Wesentlichen durch den Saletbach gespeist. Durch die den See begrenzenden steilen Berghänge wird er als fjordartig beschrieben. Der Königssee hat Trinkwasserqualität und gilt als einer der saubersten Seen Deutschlands. Hauptsächlich liegt der Königssee im Nationalpark Berchtesgaden. Der Watzmann gipfelt in der 2.713 m hohen Watzmann-Mittelspitze, dem höchsten Punkt des Berchtesgadener Landes. Die Watzmannsage behandelt den Hauptgipfel und seine Nebengipfel (Watzmannfrau und Kinder). Die Watzmann Ostwand ist die höchste Wand der Ostalpen. Das Steinerne Meer ist eine verkarstete Hochfläche, die durch die Grenze Bayern zu Salzburg geteilt wird. Die höchsten Gipfel sind das Selbhorn (2.655 m) und die Schönfeldspitze (2.653 m). Die Salzburger Schieferalpen, auch Salzburger Grasberge, befinden sich in Österreich im Bundesland Salzburg, zu kleinem Teil in der Steiermark. Als Teil der Schieferalpen werden sie zur Grauwackenzone und entweder zu den Nord- oder den Zentralalpen gezählt. Die Kreuzeckgruppe ist eine Gebirgsgruppe in Österreich in den Bundesländern Tirol und Kärnten. Der Anteil Tirols beschränkt sich auf einen kleinen Teill im Westen. Die Kreuzeckgruppe besteht hauptsächlich aus Gneisen und Glimmerschiefern. Gemeinsam mit anderen Bergregionen bildet die Kreuzeckgruppe die Hohen Tauern. Die Kreuzeckgruppe wird haupsächlich zur Alm- und Forstwirtschaft genutzt und weist keine nennenswerten Siedlungen auf.
 ws_text_accomodationWährend der geführten Alpenüberquerung von Salzburg nach Greifenburg sind wir in gemütlichen und urigen Berghütten untergebracht. Die Hütten verfügen über Trocken und Waschräume, sowie über Duschmöglichkeiten. Wir sind im Zimmerlager mit Halbpension untergebracht. <h3>Informationen zur Unterkunft</h3> <ul> <li>Übernachtung in den Hütten mit Halbpension</li> <li>Übernachtung im Mehrbettzimmer / Zimmerlager</li> </ul> <ul> </ul> Fragen zur Unterkunft | Wir geben Antworten!
 ws_text_course_content
 ws_text_overview
 ws_text_advantages<ul> <li>NUR 8 Personen pro Gruppe! Nicht 10 - 12 Personen</li> <li>Wandern von Salzburg nach Triest</li> <li>Herausfordernde Tagesetappen</li> <li>Ruhiger unterwegs als auf dem E5</li> <li>Bequeme Bahnanreise nach Salzburg</li> </ul>
 ws_text_detail_description_new<h3>Alpenüberquerung von Salzburg nach Triest | Teil 1</h3> Die Alpenüberquerung der Extraklasse beginnt vor den Toren Salzburgs mit der Auffahrt auf den sagenumwobenen Untersberg. Weiter geht es über den Königssee vorbei an der imposanten Watzmann Ostwand ins Steinerne Meer. Der weitere Weg bringt uns ins Herz der Hohen Tauern, wo wir unsere erste Etappe des Fernwanderweges beenden.
 ws_text_information_new
 ws_text_accomodation_new
 Route(array)
 id2623
 hashb798412c39ab8033cd9fa3323c2a5b8f
 created2018-08-01 09:49:28
 updated2021-11-09 10:48:30
 modelTour
 foreign_key306
 base/
 aliasalpenueberquerung-salzburg-triest-teil-1
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft4187
 rght4188
 route/alpenueberquerung-salzburg-triest-teil-1
 TourDate(array)
 0(array)
 id14006
 hash

Alpenüberquerung Salzburg - Triest | Teil 1 Von den Berchtesgadener Alpen in die Hohen Tauern

Alpenüberquerung von Salzburg nach Triest | Teil 1

Bergsteigerschule Watzmann - Deine Vorteile Deshalb sind wir der richtige Partner für diese Tour.

Dein Vorteil & Deine Sicherheit

Reiseprogramm So ist der reguläre Ablauf dieser Reise. Abweichungen aufgrund von Wetter / Verhältnissen sind möglich!

1. Tag: Über den Untersberg zum Stöhrhaus

2. Tag: Über den Königssee in den Nationalpark Berchtesgaden

3. Tag: Durch das Steinerne Meer zum Riemannhaus

4. Tag: Von Taxenbach ins Rauriser Tal

5. Tag: Vorbei am Hohen Sonnblick zur Fraganter Schutzhaus

6. Tag: Kreuzeckgruppe und Feldnerhütte

7. Tag: Über den Höhenweg und Abstieg ins Tal

Anforderungen Das musst du können, um für diese Tour gerüstet zu sein.

Alpine Erfahrung

Anforderungen

Mäßige Alpine Erfahrung | Mittlere alpine Unternehmung

Leistungen Bei dieser Tour hast du folgende Inklusivleistungen, Exklusivleistungen und Reiseoptionen.

Leistungen inklusive

Reiseoptionen

Leistungen exklusive

Tourtermine Für diese Tour sind folgende Termine verfügbar

Unterkünfte während der Tour Hier findest du Informationen rund um die Unterkünfte dieser Tour

Stöhrhaus

Kärlingerhaus

Statzerhaus

Schutzhaus Neubau

Fraganter Schutzhaus

Feldnerhütte

Wichtige Hinweise und Infos zur Region Allgemeine Informationen und spezielle Hinweise.

Informationen zum Reiseland Hier findest Du detaillierte Angaben zum Reiseland. Von der Währung über die Einreisebestimmungen bis zu Gesundheitshinweisen..

Versicherungen

Covid Hinweis

Mindestteilnehmerzahl

Reiseveranstalter

Mobilitätshinweis

FAQ Häufig gestellte Fragen und Antworten zu dieser Tour

Sind meine Schuhe zum Bergwandern geeignet?

Das „geeignete“ Schuhwerk Kategorie B - max. C

Besonderheit Alpenüberquerung!

Kann ich für meine Alpenüberquerung einen Gepäcktransport buchen?

Wann endet die Tour?

Neuigkeiten Aktuelles zur Tour.

#deinabenteuerbeginnt Hier haben wir noch ein wenig Inspiration für dich.

Salzburg Triest | Alpenüberquerung auf stillen Wegen

#KENNSTDUSCHON ... die Alpenüberquerung von Salzburg nach Triest

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 42 ms Total Queries: 186 queries

Query Explain:

Memory

Timers

Logs

View Variables

Alpenüberquerung Salzburg - Triest | Teil 1
Von den Berchtesgadener Alpen in die Hohen Tauern

1. Tag:
Über den Untersberg zum Stöhrhaus

2. Tag:
Über den Königssee in den Nationalpark Berchtesgaden

3. Tag:
Durch das Steinerne Meer zum Riemannhaus

4. Tag:
Von Taxenbach ins Rauriser Tal

5. Tag:
Vorbei am Hohen Sonnblick zur Fraganter Schutzhaus

6. Tag:
Kreuzeckgruppe und Feldnerhütte

7. Tag:
Über den Höhenweg und Abstieg ins Tal

Total Time: 42 ms
Total Queries: 186 queries