Krimmler Tauernhaus
Hohe Tauern, 1.622 m
Gasthof im Zillertal

Das Krimmler Tauernhaus ist eine gemütliche Unterkunft im Krimmler Achental. Die gemütliche Unterkunft eignet sich hervorragend als Stützpunkt für Wanderungen, Bergtouren und Hochtouren. Auch im Winter finden sich hier zahlreiche Möglichkeiten für Skitouren und Schneeschuhtouren. Der Gasthof ist frisch renoviert und die Zimmer sind gemütlich eingerichtet. Die Verpflegung ist hervorragend und lässt keine Wünsche offen. Unsere Bergführer nutzen das Krimmler Tauernhaus für die geführte Wanderung Wandern im Zillertal | Dreiländertour.

Alle 12 Fotos ansehen

Öffnungszeiten

Jan

Feb

Mar

Apr

Mai

Jun

Jul

Aug

Sep

Okt

Nov

Dez

Ausstattung

Waschmöglichkeit

Duschmöglichkeit

Handyempfang

Sauna

Währung & Bezahlung

EUR

Währung: Euro

Standort der Unterkunft

Reisen mit der Unterkunft Krimmler Tauernhaus Diese Unterkunft besuchen wir auf folgenden Reisen

Wandern im Zillertal | Dreiländertour

Naturgewaltige Wanderung auf der Dreiländertour mit Gletscherblick in den Nationalpark Hohe Tauern. In 6 Tagen von Hütte zu Hütte durchs Hochgebirge, vom Zillertal in die Hohen Tauern.

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)
  userAgentbb9a308b4a34371b6683a620bd245ed7
  time1730348151
  countdown10
- _Token(array)
  key64f70b063aa22937b7c746ecd6064d3f9a59cb4bc6d779eb6b247642d574a66971f15c2289c4ff20b721e5f08ab70c2775e50342006a9638dafe1b581af2c217
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  ae15c4dd2d0213e81b4a2ff8007eced348ab8ea752a3cef89e2e36c410afd084b5571a49b7bcae8f424b453dc5ccc988516cac5842d5fa2439ab137ed1c10fbd1730335519
  5edc1591522d9ddd206534de5d8ba0aa23b8fb552c27dc5a40f22275f018326c892a3ec22fdb4e7c84b1ad830d256962a57eb936785f4534b64ba104840a60a01730335519
  a928c61dcda8443780018f57a3be17493fd787e1960e5dc2150da285b7758edabb62935f47552485e320969d1c3b5f5994a17ec63b34783d562e307160943f701730335520
  ee9e194a62367168db08ad3737d9cb6e747644800b5496e61379bad01aa940fb585e8f388c8d5a476eb9de3344d5564bba1a264bb5cb7bce9b65dc127b69d1e81730335520
  e37478d63b392357123781045a151179aa3cc24e323c1ed0d40aaa5a47ac45be216602ac5147c31e3e754062f69fc09472e9bc8b2df93d9d838ffb5b19428bd51730335520
  0650f0d103600a4c24e4e4912edf3b3aae9a6a254759e4e22d10d79547dbcf408b0969aafefe14536c6ea1abaa9ffc7fb4570f94f47b81092488017291bed0ca1730335521
  0374622aef53a1a38f323206a6f30252964ad57dd77665bd229daebe8e29f61650ea358224b9fedb272e5bf61d7e7e9458e882bc1479886dbecff60c7063332f1730335521
  c372346dc55dff266112b8797263d97658e1cbc9e7bf28073cc2f2e378b2285fd07676415a116c3d28c12972823585eaef958552f673394ae5d4f7abad99eb5f1730335522
  8f8a252d6d03848f1e3a3d382d1124a4c8f496fb85134c8179518f497b4cfc0ae97f38f7fe384478117d140d6e583e6dd5c8f33fe2b595e536febc422ed4927a1730335522
  75977fa70c655bf2ff5f49fbac4513369c18dc54bbb0fed20aace935eb43944e3c7b04b609769f326924df397b22712b4efcb61385238f24e000b8d25ef5d5d31730335523
  577894c96c25f9e3e5c464fcc2b813f4922c461291c9ac7bbd9ab95754ebddfb8a5fdeaa08a1ea4e9b61bae533cccd96aa28bd9bb7eab2eb3ec9e7ba07bf10be1730335523
  e460f748dea48ca547045ab2949b15a3f2900178bcd5223de7dc55c6f4ab2b6758789ba7693efdc45d020d0721ab8c81243d2b0150d337640d178e7ac98a98af1730335523
  a04b15bbdf5c1755a57165e88408a9d45838259e0469d8d749784384734709da27338db94afd67459de0436771e42d56de33f4eeafe35a2a61b565b6b54191b61730335524
  27a902fead9d640b7bc3239fca543344691346a5b7a26d4f16ab6f8be68f22e2e0da938ff23adb582e48876f47ac84e1f668957d678cabf67614425d0d7223d71730335525
  f38045eb6247ce5fcdbe586b6b875c6741ce651648ac8f0d0df2152a112a756170209665b59091b9d98064a3e4b39e6be5ce369c1ca4a56362c85f0517a92ef11730335525
  f3bf8e2137bd0ddad1d0ed880167f2a3e36706fd504153934b15f4276d65b161f432d859e54396408ebed0c0b0e6b21d5e52775820fe92e96a624cc640116d3e1730335526
  a62feaf0630209e2de7722d19f6d5ae64c300103ebda2799a2e4c920661825eb97999315995f95ebb798c16a5dd94e0af9635c2d32d5061447fe0cea4cc306de1730335526
  1528b6484afae435d90b8469f704ccd151f0eefd7672731a62ed9c55760b997a0880ca4dde9089aa6e15ba3a0a7717aae0159f38fabc6fde375851e23635718d1730335527
  ce4eb1ff89cf0c9850ce63d4885b6953cf7b11e196ebad856afaaaf0893f8b60be130ea998bed041da2f11c8ba685fddf8b9b0be680a31ae048045a2b800d2f21730335527
  4772e7d760f59609aefe0873ebbd9f9352277c7c460efafd91430c4247c6564337a54230db172e08fe76fe01f285f59122085f7ded4ce00995b062cb689308bb1730335528
  1e7c0432899e0cd2e1a64115f403aaf4dee26e67f0d4e79f5635f153bdc0e958f866494dc410542ca6bcf0650609b28c7bac0b8e4fab8ba0944e223f2e0443311730335528
  e268ea61c150dbf005be3338b11742a1cfdf466b633e927dd3837ed0179095f69813d3675c14ba8779c9053b272484540493bda07c92504d365c99cf4837c9561730335529
  cc69eab73ba33141b07bddd4712e8c2fe2831fb388777e0ea7809b08afa17960daba443f22ab171634f6d18a681b1e9dd586efbab3599ede9464cba110310a101730335529
  a548c5fd8d044ed868c74ba8a44a6c23d84ae49c9796908f11e7599eb80cc9520ed71b5fc220625b62b0b6c1c6b8d8105c9d63e74ad13887a99f19a98042094f1730335530
  0ca8a58303e9552a7c1ae58c0ff0b0b1eb1241ded94002e151beb4c1df64abc300996973d9874449da0af7fa50135a13771dc74f3b731328c555ecea7905c5941730335530
  e7fa369e4562b7240ed3753eeed7c8dc0483fac2b8d8051e3b2ec145a6d56e14f51213ef138363a281c84b462ba0f8bc47c625d480aa23db864037bbb03f08081730335530
  2dd79a201f35911173b04088b8d58f4d77145311b60d1e0c040f52acefb1bf1b07c2f79afb02b60a0ec90e88e0cf8fb500822d3f5a39d6b50f49de9bef54f0e61730335531
  74594c17829d41a721143c537360aa914eca29fa98e23a13ebbf93670c3c188b3cf7fc15babb3143b40ca8cb4cd5276502527cb446658c4e02bc82859ebe5a341730335531
  c7b2962372a28ab24a4c39e515515276b9aff026b9af2e7ac56d2bdf3738629f8f3c92756b5f17e285e7c45bac82210952ff3158f29b480ee6fd71b3067e33ea1730335532
  b109c8984220cd078ae1c9ae0cbb591708be950a9209dcd4e5dbb5cf2515708bffd20cc742eb9bde5d17f85bba996df11c1eafc74404c234508638c0b330daf91730335532
  b2bfec312655576dcc17e99946d438934bc26b40d03d4e2c7f574349afa7f1df826dfbbdb7c6399c61ce3e968531dcfa1a2579aedf2c6f4d241db5ec82cd42c31730335533
  fc577acb86812d2204385c3f8a585d126cb5df6a0b445069b771a79582f0a8097db49632781a2b7a4c74fe68ab5a6c77000f131bec349b0b1fc82001e162579a1730335533
  6d8b9722aca96c0f71e3fcd0f727258444bc3b13b1c7d9c737e3c015e7f2fc2f2e2d449c00b799822e4b937996ad4db2550e88ec7a33e541889a73792ec6afe01730335533
  562a5c30c655ec535a8ecc608772218b38c10a93df0b0191de345b3735bd7a517abcdce858f42d5c8bcbfdf01ed1da49da94bc88fbcd089cea6d0ea157fed5f61730335534
  9fd039d8a063311c7ab13421e483df6832c281ef926704231da76fb87036814bb1f87bb47ffe366af77c4cd4115763e1747549fbd76494618ea1369ce0ca896c1730335534
  dbd39e144f278a69054b981e8343d229ab7fb5e9184bf2a47306ac97be46681b6382511701129046de4b4eec99abc2b645941ed1daecf9e686a53bf3d20707901730335535
  7638aae2af66b16d9862e7a955ea4ee41387d14912c9fb747cc4fe62eae1df95a040d13b8d8a14e75010e5885d87b0f75b90f36c0416a9792d527f81ed2c7c521730335535
  f9e1224e03bd44bf5ecb87c01fd53b91c6a6e89311c83a6bded9ae96472b92ec71e08fe2338d0267a51f65e11fc314e001f04fd51d0348ed9ca1a9a7d3e269541730335536
  094c110b51c421aa0c73ebda89f347fdb2758d0d246a49775769da8348f0f5c16c207b888986170ed1a3f41137bab22bd52fa2a12f6b77857f0a1052dcc7ae481730335536
  2027a1d88d5132b67f5466fba9f910d43be67183e4c9f9537e81e24bccc44f8f866f0cddbf03051b4e22bbad318397ffdc5b2350e4e0722983a17670011beb311730335537
  5528eedb55370484ca647dc025b4c244e89f277f56054127e5a4f89e44e476ca41b50a6e1465c48cc2b6afab232cf8d28c4eafb96cbbec4bb2b091386e275c851730335537
  b82e5aa3d17a68a48874febae57e6ab64a505388d5d0a67a28c70d8a90e20634710463092a8ca7a95fe41b61150cde4a3811469890ef5dbb31857fc54aeb5f541730335538
  28d7d95674dc3c2338cfb8fc45b21bb39bd830c99db453e32ae54da9b944774fffb6d5f689b72636a83c6cf97262e7798806fac4eaf74f868bad4d7f991c787c1730335538
  4a5996612b4d6609ddf5e2843b45e718dcdf295f5275066de8442cd609f6fa2d2063b68f5e40545384f3d19326ac4b6e3d285184394aba9258c3203736ef6ba91730335539
  4e22b3fbd8e527c826201e032d3f49365e60fb7b284dd8624fb5ac6e7ad57908d595e91f927478f974e8632d02f9361808f8cdf3065b8f629a73ce8c7305b7eb1730335539
  0ebcaea3b81c0d2c7c70dd427664d11fd538ee4bebd889e63d09b41e6a675f8194cf6f03dfa36371419327877d2b1c4b0bcc1a2da713f260ab30f913a265d1bb1730335539
  cb2b636479275de103b88d7ff41009e94c796ca5b032eabb5f4b604b186794b860e5ab1ed5f08720b0f742adefc389d31a2b6804daf5165de74a57d53eb97c901730335540
  e4e911679930e5adb93dfdeeb4be17fcb727bfd790a8b36cda2ebd4b59e7e2f8ae5b8fe3c722acf03a0ec600ac230e239bc4734e5683a8c1f5afcfd5e3917a831730335540
  26bcafe93f22fbe0f30087bb60e429398c3199c1f8c5f1b1c705d6981d4e5ff374ca5af18a019dedb67acfb2926a1b5cec326ba31fc6697a09e9f407f81ef9601730335541
  2b5135c042dc985f723af9f63067a14254ecbba0fb4c448f533c88345a13bba56023777a37f473ff07d6a8cdecd076e9953cd71a93c0ef18fd97c35d736dd21e1730335542
  96c195f64faa6c02d50daafd9f14efe68533fb62658b8973e9c84fc11b7bbeda3a4c913a93f45bc7fe5a84ea5ff2e3424c7b92ed056d7c1896da43df0a014fd51730335542
  61473d404128629a909bf74ec5b5d78909badb4b2571c9d0fd847d1968d918f3cc714a6a12336c7ee6d6f8b65a2bc9b7cb9ca5ef068552ee6f6c6966251c56141730335543
  36cea27727fb179e277c038851da5f07bcb37b76cd19cb36e182a9bba4b47c8f160da791589e2a6f2bf8c85c205ddc537131f92073489496d0aaa91f5bced4251730335543
  dd470269bdaed50f9cb87186093b28a7acc5f5f9d66c83fac763dccd0e9668a8380b8959f6179fcfc0c89f99d5deab3a3e793ce42a6245cf7e6e91e8125c8ece1730335544
  ab59f5cc2cb77ec867f5b2d8c39798b6dc3295faecbd3556c1ef4dd5a0fe1b8eeea05e1b6b858716395ff2a9d7fe2f03042ca0e95e097b130e26690b0a76e78b1730335544
  a271b549900b9159144d85293aac0901c5cb385b43554fe97dcc6514b9581618bbbf198a8cbc9b4c69ea120ffc11326cb7348db3228a8198d30b8934da90c7b41730335545
  cefd30cba6291707f9cffb6f77810ed66f25c88ecaf9561ae0708870fd4eefa621d1adfc1c6a28c726d7d5b897a8d2955519a945972242e5894a524dd7389a6e1730335546
  a3ef2bc5b7a9a88b10da7a12cfcf115fd8e044844acfe3e3018661af7740f5d9dd9576fdd1666eb2dd4cadb9b201787fad11c33826f5bebe6dc4376770d4f1ac1730335546
  d658452477d203d37450b70ec0818ad07dca6f2be7efe4b1ebad164cfa5f680b60cf156fbc8c7252bc859e07147095be5650330143beb71e57611907a4bc6a5b1730335547
  3310c4862d037ee6080ff8904975546e6693c69908b0b96c2f798f9f243bde2333a74d26ab8658375dfcc45052495f01884dcf9fde666e063c3e04dad0789bd21730335547
  6547e1702d858f56ef414fc92bf323f2566abf74979bc4df84e81838d533b085d70d315f5ad01d410fbeb35a6f46f3ba031fadd09914be86e44a00533519e06e1730335548
  a8cff7995e57ad2a4c2ecb3956b3280f47a0589c03c97e792e8f6bb96d49f65c10d1e77a7667f864a5199636a86840b380a0f6ef574873a51cf3280f201732ed1730335548
  73fa6bde0a8ae56797ec142c8a7fe12b778d901c964553b3b8471862b10a6779140b464bab2437054d4ed2cf17079a000cf178c455e9afca574f3b1e03f47f1a1730335549
  c2a6497baf1a796ff058d361c964b933001bbeee4c441d42d3f9289a027bb6ba1324f5b3612f8cb94b407c283bd325dc0eb08eec300927d80807e5edb2f0209d1730335549
  c42a1661b029e3abbe4fe2ebe8e46cab58120a7e782a571b18599f883dabc12b7b614bcaac41f99ff5972327b9bd48926e52517518c48c1500dd7f682f9bfc801730335549
  2c7605beadf31074de8770905b090bff475dec75a9e6a44c9fa4a2457c0882ba6f398c5004902f4a458e81e01421ffc7750d5c09a06aac33968d9a3aa2522fbc1730335550
  a365bc19b41cff43865e5c7dbba50b900c915d7e40deedcfaa8134cb4746b4e35240ed0025e7e215414ba91223da91e42f4d7c304f112cad480ae94ddfc0b3991730335550
  7b89b284609562811b52e0cfd346d818764f65a5e25b7bf5395a2dd03f794760f7cd1d154137f739d364b970d537248f1a3a4e90607bee8fc74cc910e435bb361730335551
  9149a897eda68d6f108dc5423b5cbaee0f5d8165748af35aa4761e9942226a0e34f0dfbaf1b79866b554c638ad591c0470d9727f3338adf8882d6f984c0c887f1730335551
  64f70b063aa22937b7c746ecd6064d3f9a59cb4bc6d779eb6b247642d574a66971f15c2289c4ff20b721e5f08ab70c2775e50342006a9638dafe1b581af2c2171730335552
====
Request
+
Request

Cake Params
- pluginFrontendAccomodations
- controllerFrontendAccomodations
- actionaccomodation
- named(empty)
- pass(array)
  0485
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Accomodation485
- route(array)
  id3085
  hash6abfc2aa0eac361677e144fa2c8a4bfb
  created2020-01-24 15:30:41
  updated2024-07-18 16:15:16
  modelAccomodation
  foreign_key485
  base/
  aliaskrimmler-tauernhaus
  controllerFrontendAccomodations.FrontendAccomodations
  actionaccomodation
  parent_id(null)
  lft5185
  rght5186
  route/krimmler-tauernhaus
- isAjax(false)
- _Token(array)
  key64f70b063aa22937b7c746ecd6064d3f9a59cb4bc6d779eb6b247642d574a66971f15c2289c4ff20b721e5f08ab70c2775e50342006a9638dafe1b581af2c217
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

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: 21 ms
Total Queries: 142 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`))) = '/krimmler-tauernhaus' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 5185 AND `Route`.`rght` >= 5186 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`	52	52	2
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, 58, 59, 60, 61, 62, 63) 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.alpinewelten.com' 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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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` > 89 AND `Menu`.`rght` < 90 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 `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` = 16 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags'	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` = 'default' AND `EmailTemplate`.`status_value` = 'warning' LIMIT 1	1	1	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` = 26 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `Accomodation`.`id`, `Accomodation`.`hash`, `Accomodation`.`created`, `Accomodation`.`updated`, `Accomodation`.`number`, `Accomodation`.`name`, `Accomodation`.`type`, `Accomodation`.`owners`, `Accomodation`.`phone_cabin`, `Accomodation`.`phone_valley`, `Accomodation`.`mobile`, `Accomodation`.`fax`, `Accomodation`.`email`, `Accomodation`.`url`, `Accomodation`.`zip`, `Accomodation`.`city`, `Accomodation`.`street`, `Accomodation`.`country`, `Accomodation`.`region_area_id`, `Accomodation`.`remark`, `Accomodation`.`geopoint_lat`, `Accomodation`.`geopoint_long`, `Accomodation`.`cancellation_period`, `Accomodation`.`tighter_cancellation_period`, `Accomodation`.`status`, `Accomodation`.`subline`, `Accomodation`.`height`, `Accomodation`.`video_url`, `Accomodation`.`opening_hours`, `Accomodation`.`premises`, `Accomodation`.`equipment`, `Accomodation`.`currency`, `Accomodation`.`detail_description`, `Accomodation`.`days_before_to_send_participant_list`, `Accomodation`.`country_id`, `Accomodation`.`url_booking_system`, `Accomodation`.`importance`, `Accomodation`.`participant_list_necessary`, `Accomodation`.`reservation_through_agency`, `Accomodation`.`reduction_not_necessary`, (CONCAT_WS (',',`Accomodation`.`geopoint_lat`,`Accomodation`.`geopoint_long`)) AS `Accomodation__geopoint`, `RegionArea`.`id`, `RegionArea`.`hash`, `RegionArea`.`created`, `RegionArea`.`updated`, `RegionArea`.`title`, `RegionArea`.`region_id`, `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`abbreviation`, `Country`.`subtitle`, `Country`.`link_embassy_german`, `Country`.`link_embassy_austrian`, `Country`.`link_embassy_swiss`, `Country`.`link_embassy_italian`, `Country`.`best_travel_season`, `Country`.`general`, `Country`.`security`, `Country`.`nature_climate`, `Country`.`travel_info`, `Country`.`entry_customs`, `Country`.`visa`, `Country`.`health`, `Country`.`tours_summer`, `Country`.`tours_winter`, `Country`.`microsite_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` FROM `alpinewelten`.`accomodations` AS `Accomodation` LEFT JOIN `alpinewelten`.`region_areas` AS `RegionArea` ON (`Accomodation`.`region_area_id` = `RegionArea`.`id`) LEFT JOIN `alpinewelten`.`countries` AS `Country` ON (`Accomodation`.`country_id` = `Country`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Accomodation`.`id` AND `Route`.`model` = 'Accomodation') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Accomodation`.`id` AND `Seo`.`model` = 'Accomodation') WHERE `Accomodation`.`id` = 485 LIMIT 1	1	1	5	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` = 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` = (248) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	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` = 485 AND `MediaEntity`.`media_id` = `TeaserMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'teaser' 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` = (10822) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `GalleryMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 485 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	12	12	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 (10822, 10820, 10821, 9265, 9267, 9266, 9259, 9263, 9258, 9260, 9261, 9264) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	93	93	2
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` = 485 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Accomodation' AND `TagEntity`.`field` = 'tags'	0	0	0
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`, `TravelReport`.`category`, `TravelReport`.`external_url`, `TravelReport`.`hide_publication`, (NOW() BETWEEN COALESCE(`TravelReport`.`release`, NOW()) AND COALESCE(`TravelReport`.`hide`, NOW())) AS `TravelReport__published`, `AccomodationsTravelReport`.`id`, `AccomodationsTravelReport`.`accomodation_id`, `AccomodationsTravelReport`.`travel_report_id`, `AccomodationsTravelReport`.`position` FROM `alpinewelten`.`travel_reports` AS `TravelReport` JOIN `alpinewelten`.`accomodations_travel_reports` AS `AccomodationsTravelReport` ON (`AccomodationsTravelReport`.`accomodation_id` = 485 AND `AccomodationsTravelReport`.`travel_report_id` = `TravelReport`.`id`) ORDER BY `TravelReport`.`publishing_date` DESC	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`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, (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`, (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`, (`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`, `TourTexts`.`ws_text_arrival`, `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`.`tours` AS `Tour` 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') JOIN `alpinewelten`.`accomodations_tours` AS `AccomodationTours` ON (`AccomodationTours`.`accomodation_id` = '485' AND `AccomodationTours`.`tour_id` = `Tour`.`id`) WHERE 1 = 1 GROUP BY `Tour`.`id` ORDER BY (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) DESC	1	1	3	maybe slow
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` = 344 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	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 `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 `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` = 344 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` = (11125) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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` > 254 AND `Menu`.`rght` < 313 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	29	29	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 (6, 649, 652, 656, 127, 701, 106, 655, 648, 966, 91, 884, 885, 663, 670, 669, 668, 667, 666, 664, 750, 752, 751, 761, 847, 848, 849, 851, 972) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	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` = 'footer_more' AND `Language`.`langid` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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` > 314 AND `Menu`.`rght` < 327 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 (34, 35, 36, 37, 38, 94) 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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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	4	4	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, 4) 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` = 'Accomodation' AND `Seo`.`foreign_key` = 485 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` = 3695 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` = 1 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` = 204 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` = (3217) 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` = 3 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` = (2312) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	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` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`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` = 1 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` = 1 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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` = 7 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` = 210 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` = 9 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` 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` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`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` = 7 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` = 7 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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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` > 40 AND `Menu`.`rght` < 169 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	40	40	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 (690, 774, 775, 864, 842, 843, 853, 854, 855, 856, 857, 858, 844, 867, 845, 875, 861, 776, 797, 795, 796, 801, 802, 803, 777, 872, 869, 873, 874, 778, 779, 859, 781, 780, 783, 881, 882, 608, 607, 606) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	5	5	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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` > 170 AND `Menu`.`rght` < 253 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	41	41	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 (8, 9, 20, 637, 19, 27, 10, 559, 580, 753, 968, 12, 13, 14, 21, 22, 30, 29, 521, 31, 53, 72, 588, 73, 23, 75, 76, 484, 15, 16, 17, 18, 49, 50, 51, 841, 68, 63, 58, 57, 600) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	37	37	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`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, (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`, (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`, (`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` = 1 ORDER BY `position` ASC	10	10	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` = 25 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` = 25 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` = (65) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	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` = 217 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` = 217 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` = (12264) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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` = 544 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` = 544 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` = (14258) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	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` = 219 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` = 219 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` = (841) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	15	15	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` = 73 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` = 73 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` = (4175) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	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` = 253 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` = 253 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` = (4120) 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` = 204 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` = 204 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` = (4804) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	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` = 213 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` = 213 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` = (12889) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	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` = 470 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` = 470 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` = (3964) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	19	19	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` = 28 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` = 28 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` = (612) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	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	604	604	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`, `Teaser`.`subtitle` 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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` = 774 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` = 5685 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` = 4208 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` = (774) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (774) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`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` = 774 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` = 774 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` = 'about_landingpage' AND `Language`.`langid` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` > 91 AND `Menu`.`rght` < 168 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	38	38	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 (775, 864, 842, 843, 853, 854, 855, 856, 857, 858, 844, 867, 845, 875, 861, 776, 797, 795, 796, 801, 802, 803, 777, 872, 869, 873, 874, 778, 779, 859, 781, 780, 783, 881, 882, 608, 607, 606) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	4	4	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_mountainguides' AND `Language`.`langid` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` = 796 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` = 5712 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` = 4235 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` = (796) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (796) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`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` = 796 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` = 796 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` = 'footer_partner' AND `Language`.`langid` = 'aw' LIMIT 1	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` = 'aw' 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`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`subtitle` 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` = 11 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` = 218 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` = (471) 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` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` 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` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`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` = 11 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` = 11 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` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'accomodations_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` = 'aw' 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` = 'aw' 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` = 'aw' 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` = 'aw' 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 19.06 MB

Message	Memory use
Component initialization	2.21 MB
Controller action start	3.30 MB
Controller render start	7.63 MB
View render complete	11.51 MB

Timers

Total Request Time: 755 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	473.12
Event: Controller.initialize	13.35
Event: Controller.startup	0.80
Controller action	69.69
Event: Controller.beforeRender	67.96
» Processing toolbar data	15.88
Rendering View	50.58
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendAccomodations/View/FrontendAccomodations/accomodation.php	12.60
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php	0.94
» » Rendering APP/View/Elements/icon.php	1.23
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_mosaic.php	0.78
» » Rendering APP/View/Elements/icon.php #2	0.97
» » Rendering APP/View/Elements/icon.php #3	0.90
» » Rendering APP/View/Elements/icon.php #4	0.87
» » Rendering APP/View/Elements/icon.php #5	0.92
» » Rendering APP/Plugin/FrontendTours/View/Elements/teaser_slider.php	3.62
» » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php	1.16
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.20
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php	0.31
» » » Rendering APP/View/Elements/icon.php #6	0.92
» » » Rendering APP/View/Elements/icon.php #7	0.22
» » » Rendering APP/View/Elements/icon.php #8	0.87
» Event: View.afterRender	0.07
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/1.php	36.36
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.47
» » Rendering APP/View/Elements/header/header.php	18.68
» » » Rendering APP/View/Elements/header/header_navbar.php	18.52
» » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.08
» » » » Rendering APP/View/Elements/navigation_secondary.php	3.85
» » » » » Rendering APP/View/Elements/icon.php #9	1.10
» » » » » Rendering APP/View/Elements/icon.php #10	0.25
» » » » » Rendering APP/View/Elements/icon.php #11	0.22
» » » » » Rendering APP/View/Elements/icon.php #12	0.97
» » » » Rendering APP/View/Elements/navigation.php	13.41
» » » » » Rendering APP/View/Elements/icon.php #13	0.23
» » » » » Rendering APP/View/Elements/icon.php #14	0.20
» » » » » Rendering APP/View/Elements/icon.php #15	0.20
» » » » » Rendering APP/View/Elements/icon.php #16	0.25
» » » » » Rendering APP/View/Elements/icon.php #17	0.20
» » » » » Rendering APP/View/Elements/icon.php #18	0.19
» » » » » Rendering APP/View/Elements/icon.php #19	0.25
» » » » » Rendering APP/View/Elements/icon.php #20	0.20
» » » » » Rendering APP/View/Elements/icon.php #21	0.19
» » » » » Rendering APP/View/Elements/icon.php #22	0.22
» » » » » Rendering APP/View/Elements/icon.php #23	0.20
» » » » » Rendering APP/View/Elements/icon.php #24	0.20
» » » » » Rendering APP/View/Elements/icon.php #25	0.20
» » » » » Rendering APP/View/Elements/icon.php #26	0.20
» » » » » Rendering APP/View/Elements/icon.php #27	0.20
» » » » » Rendering APP/View/Elements/icon.php #28	0.20
» » » » » Rendering APP/View/Elements/icon.php #29	0.20
» » » » » Rendering APP/View/Elements/icon.php #30	0.20
» » » » » Rendering APP/View/Elements/icon.php #31	0.21
» » » » » Rendering APP/View/Elements/icon.php #32	0.26
» » » » » Rendering APP/View/Elements/icon.php #33	0.20
» » » » » Rendering APP/View/Elements/icon.php #34	0.20
» » » » » Rendering APP/View/Elements/icon.php #35	0.24
» » » » » Rendering APP/View/Elements/icon.php #36	0.26
» » » » » Rendering APP/View/Elements/icon.php #37	0.22
» » » » » Rendering APP/View/Elements/icon.php #38	0.27
» » » » » Rendering APP/View/Elements/icon.php #39	0.21
» » » » » Rendering APP/View/Elements/icon.php #40	0.21
» » » » » Rendering APP/View/Elements/icon.php #41	0.25
» » » » » Rendering APP/View/Elements/icon.php #42	0.20
» » » » » Rendering APP/View/Elements/icon.php #43	0.21
» » » » » Rendering APP/View/Elements/icon.php #44	0.25
» » » » » Rendering APP/View/Elements/icon.php #45	0.21
» » » » » Rendering APP/View/Elements/icon.php #46	0.21
» » » » » Rendering APP/View/Elements/icon.php #47	0.26
» » » » » Rendering APP/View/Elements/icon.php #48	0.24
» » » » » Rendering APP/View/Elements/icon.php #49	0.22
» » » » » Rendering APP/View/Elements/icon.php #50	0.25
» » » » » Rendering APP/View/Elements/icon.php #51	0.21
» » » » » Rendering APP/View/Elements/icon.php #52	0.21
» » » » » Rendering APP/View/Elements/icon.php #53	0.24
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php #2	0.57
» » Rendering APP/View/Elements/footer/footer.php	8.21
» » » Rendering APP/View/Elements/icon.php #54	1.00
» » » Rendering APP/View/Elements/icon.php #55	0.93
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.08
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.07
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.07
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php #2	0.11
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.07
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.07
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.26
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.14
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.09
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.07
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.07
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.07
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.09
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.07
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.07
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.07
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.07
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.07
» » Rendering APP/View/Elements/contact_widget.php	5.70
» » » Rendering APP/View/Elements/icon.php #56	1.03
» » » Rendering APP/View/Elements/icon.php #57	0.93
» » » Rendering APP/View/Elements/icon.php #58	0.89
» » » Rendering APP/View/Elements/icon.php #59	0.95
» » » Rendering APP/View/Elements/icon.php #60	1.18
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- accomodation(array)
 Accomodation(array)
 id485
 hash7f22d8f32687a68046b6a87541cb6ba1
 created2020-01-24 15:30:41
 updated2024-07-18 16:15:16
 number900485
 nameKrimmler Tauernhaus
 typecabin
 owners
 phone_cabin +43 664 2612174
 phone_valleyA
 mobile
 fax
 emailinfo@krimmler-tauernhaus.at
 urlhttps://www.krimmler-tauernhaus.at/winter/
 zip5743
 cityKrimml
 streetKrimmler Achental
 countryAT
 region_area_id11
 remarkinfo@krimmler-tauernhaus.at
 geopoint_lat47.138889
 geopoint_long12.191111
 cancellation_period21
 tighter_cancellation_period(false)
 statusactive
 sublineGasthof im Zillertal
 height1.622
 video_url
 opening_hours1023
 premisesDas Krimmler Tauernhaus ist eine gemütliche Unterkunft im Krimmler Achental. Die gemütliche Unterkunft eignet sich hervorragend als Stützpunkt für Wanderungen, Bergtouren und Hochtouren. Auch im Winter finden sich hier zahlreiche Möglichkeiten für Skitouren und Schneeschuhtouren. Der Gasthof ist frisch renoviert und die Zimmer sind gemütlich eingerichtet. Die Verpflegung ist hervorragend und lässt keine Wünsche offen. Unsere Bergführer nutzen das Krimmler Tauernhaus für die geführte Wanderung Wandern im Zillertal | Dreiländertour.
 equipment39
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id248
 url_booking_system
 importancegold
 participant_list_necessary(false)
 reservation_through_agency(false)
 reduction_not_necessary(false)
 geopoint47.138889,12.191111
 RegionArea(array)
 id11
 hashb85127b4b79563b4d2e1ab2847b6377d
 created2015-11-06 08:07:26
 updated2015-11-06 08:07:26
 titleHohe Tauern
 region_id2
 Country(array)
 id248
 hashec13321fe78006ccd14b331c8b021751
 created2016-06-01 17:35:19
 updated2024-08-15 14:03:20
 titleÖsterreich
 abbreviationAT
 subtitleDie Alpenrepublik - hohe Berge, saftige Almen und tiefblaue Seen
 link_embassy_germanhttps://www.auswaertiges-amt.de/de/aussenpolitik/laender/oesterreich-node/oesterreichsicherheit/210962
 link_embassy_austrianhttps://www.bmeia.gv.at/reise-aufenthalt/einreise-und-aufenthalt-in-oesterreich/
 link_embassy_swisshttps://www.eda.admin.ch/eda/de/home/vertretungen-und-reisehinweise/oesterreich.html
 link_embassy_italianhttp://www.viaggiaresicuri.mae.aci.it/country/AUT
 best_travel_season3071
 generalStand: 12.08.2020 <h2 style="text-align:center">Allgemeines</h2> Die Republik Österreich ist ein Binnenland und liegt im Herzen Europas. Sie ist eingerahmt von Deutschland und Tschechien im Norden, die Schweiz und Liechtenstein im Westen, Italien und Slowenien im Süden sowie Ungarn und die Slowakei im Osten. Der Alpenhauptkamm zieht sich quer von West nach Ost durch das Land. Sage und schreibe über 60 Prozent der gesamten Landesfläche zählen zum alpinen Hochgebirge. Aus diesem Grund hat Österreich auch den Spitznamen "Alpenrepublik". Fast 1.000 Dreitausender gibt es in Österreichs Ostalpen, der höchste Gipfel Österreichs ist der 3.798 m hohe Großglockner im Nationalpark Hohe Tauern. Dass die Liste von bedeutenden österreichischen Pionieren, die den alpinen Bergsport nachhaltig geprägt haben, lang ist, versteht sich daher fast von selbst. Die Landessprache der Republik Österreich ist Deutsch. Die Hauptstadt ist Wien im äußersten Osten des Landes. Knapp 8,9 Millionen Menschen leben in Österreich. Etwa 1,9 Millionen Einwohner zählt allein die Hauptstadt Wien - fast ein Fünftel der gesamten Bevölkerung Österreichs. Der Großteil der österreichischen Bevölkerung bekennt sich zum katholischen Glauben. Die meisten Feiertage sind daher religiös geprägt und werden ähnlich begangen wie bei uns in Deutschland. Auch der 01.05. ist wie bei uns Tag der Arbeit und somit Staatsfeiertag. Der Nationalfeiertag Österreichs ist am 26.10. <h3 style="text-align:center">Währung & Bezahlung</h3> Österreich gehört zur EU und daher ist die Landeswährung der Euro. Normalerweise kann man fast überall mit einer EC-Karte am Geldautomaten Bargeld abheben oder elektronisch mit EC-Karte oder Kreditkarte bezahlen. Auf Berghütten gilt dies jedoch meist nicht und es ist nur Barzahlung möglich. Daher sollte auf Bergtouren in Österreich immer genügend Bargeld in der Tasche sein.
 security<h2 style="text-align:center">Sicherheit</h2> Generell ist Österreich ein sehr sicheres Reiseland in der Europäischen Union (EU). Die Kriminalität ist als GERING einzustufen. Insbesondere in Großstädten und Touristenzentren sind Straßen- und Kleinkriminalität sowie Trickdiebe zu beobachten. Da Österreich sich im Kampf gegen den internationalen islamistischen Terrorismus beteiligt, sind terroristische Anschläge in Österreich nicht auszuschließen, aber dennoch als gering einzustufen.
 nature_climate<h2 style="text-align:center">Natur & Klima</h2> Österreichs Natur ist aufgrund ihrer Topografie so vielfältig und artenreich, dass in den letzten Jahrzehnten viele Naturparks und Nationalparks geschaffen wurden, um diese einzigartigen Regionen weiterhin zu schützen und zu erhalten. Der mit über 1.800 Quadratkilometern größte und seit 1981 bestehende und somit älteste Nationalpark ist der Nationalpark Hohe Tauern. Österreich gehört generell zwar zur gemäßigten Klimazone, durch seine Lage am Alpenhauptkamm und die großen Höhenunterschiede vom Hochgebirge bis in die tiefen Flusstäler treffen jedoch verschiedene klimatische Bedingungen auf relativ engem Raum zusammen. So liegt z. B. die jährliche Durchschnittstemperatur in Innsbruck im Inntal bei +9 Grad und am Gipfel des Großglockners bei -9 Grad. Oft bestehen aber auch regional große klimatische Unterschiede. Die Gebirgsregionen sind durch alpines Klima geprägt. Das heißt, dass die Bergsommer kurz und feucht sind und häufig Gewitter mit sich bringen. Der Föhn, der warme Fallwinde und milde Temperaturen bringt, kann das ganze Jahr über auftreten. Die Winter sind sehr kalt und schneereich und dauern etwa von November bis April. Auf den meisten 3.000er Gipfeln liegt ganzjährig Schnee. Verschiedene Wetterdienste geben einen ganz guten Überblick über das aktuelle Bergwetter in Österreich. Sie können Dir dabei helfen, Dich auf Deine Bergtour in Österreich entsprechend vorzubereiten: <ul> <li style="text-align:justify"><a href="https://www.zamg.ac.at/cms/de/wetter/wetter-oesterreich" target="_blank">ZAMG (Zentralanstalt für Meteorologie und Geodynamik)</a></li> <li style="text-align:justify"><a href="https://www.alpenverein.de/DAV-Services/Bergwetter/#2020-07-20|weatherLayer" target="_blank">DAV Bergwetter</a></li> <li style="text-align:justify"><a href="https://www.bergfex.at/oesterreich/wetter/prognose/" target="_blank">Bergfex Bergwetter</a></li> </ul>
 travel_info
 entry_customs<h2 style="text-align:center">Einreise & Zoll</h2> Bei Grenzübertritten sind stichprobenartige Personen- und Fahrzeugkontrollen möglich. An der österreichisch-ungarischen und der österreichisch-slowenischen Grenze kann dies zu Wartezeiten führen. Ansonsten sind Einschränkungen bei der Einreise generell als gering einzustufen. Auf österreichischen Autobahnen und Schnellstraßen gilt Vignettenpflicht! Kontrollen werden oft automatisiert durchgeführt und bei Verstößen mit hohen Strafen belegt. Für einzelne Straßen im Alpenraum (z. B. Passstraßen oder Tunnel) wird eine zusätzliche Maut verlangt. Vom 01.11. bis 15.04. müssen Fahrzeuge bei winterlichen Straßenverhältnissen mit Winterreifen oder Schneeketten ausgerüstet sein. Auskunft zu Verkehr, Maut und Vignetten sowie Grenzwartezeiten gibt die <a href="https://www.asfinag.at/" target="_blank">Österreichische Bundesgesellschaft ASFiNAG.</a> Der öffentliche Personenfern- und -nahverkehr ist sehr gut ausgebaut. Da Österreich zur EU gehört, unterliegt die Warenein- und -ausfuhr den <a href="https://europa.eu/youreurope/citizens/travel/carry/alcohol-tobacco-cash/index_de.htm" target="_blank">Bestimmungen der Europäischen Union</a>. <ul> <li style="text-align:justify">Tipp: <a href="https://www.bundesfinanzministerium.de/Web/DE/Service/Apps_Rechner/Zoll-Reise-App/zoll-reise-app.html" target="_blank">App „Zoll und Reise“</a></li> </ul> <h3 style="text-align:center">Reisedokumente</h3> Die Einreise ist für Staatsangehörige D | CH | I mit folgenden Dokumenten möglich. <ul> <li style="text-align:justify">Personalausweis</li> <li style="text-align:justify">Reisepass</li> </ul> (!) Reisedokumente müssen für die gesamte Dauer des Aufenthalts gültig sein!
 visa<h2 style="text-align:center">Visum</h2> Staatsangehörige D | CH | I können ohne Visum nach Österreich einreisen. Staatsangehörige mit anderen Nationalitäten Detaillierte Informationen zu den jeweiligen Einreise- und Visabestimmungen stellen wir zur Verfügung, sobald uns Deine Nationalität bekannt ist. 
 health<h2 style="text-align:center">Gesundheit</h2> Die medizinische Versorgung ist in Österreich generell sehr gut. Die zentrale Notrufnummer in Österreich lautet 112. Die Bergrettung ist über die Notrufnummer 140 erreichbar. <h3 style="text-align:center">Impfungen</h3> Für die Einreise nach Österreich gibt es keine Pflichtimpfungen! Grundsätzlich empfehlen sich für weltweite Bergreisen eine Immunisierung gegen Polio, Diphtherie, Keuchhusten und Tetanus. Für weiterführende Informationen zur Reisemedizin empfehlen wir das <a href="https://www.crm.de/aktuell/" target="_blank">Centrum für Reisemedizin (CRM)</a>.
 tours_summer<h2 style="text-align:center">Tourenmöglichkeiten im Sommer</h2> Im Sommer bieten sich in Österreich nahezu alle Bergsportarten an! Das Wegenetz für <a href="https://www.alpinewelten.com/alpinschule/bergwanderungen" target="_blank">Bergwanderungen</a> ist meist sehr gut ausgebaut und gut gekennzeichnet. Dabei ist es egal, ob Du auf eine Wanderung von Hütte zu Hütte, eine hotelbasierte Wanderung mit mehr Komfort, eine Einsteigertour auf überwiegend einfachen Bergwegen oder auf eine sehr anspruchsvolle Bergwanderungen, die Kondition und Technik voraussetzt, gehen willst - in den Bergen Österreichs ist alles möglich! Da sich der Alpenhauptkamm mitten durch Österreich zieht, führen auch alle <a href="https://www.alpinewelten.com/alpinschule/alpenueberquerung" target="_blank">Alpenüberquerungen</a> durch Österreich. Wer höher hinaus möchte, für den findet sich eine Fülle an <a href="https://www.alpinewelten.com/alpinschule/hochtouren" target="_blank">Hochtouren</a> aller Schwierigkeitsgrade in den österreichischen Alpen, allen voran der <a href="https://www.alpinewelten.com/hochtour-grossglockner?step=tour" target="_blank">Großglockner</a> und der <a href="https://www.alpinewelten.com/einsteiger-hochtour-auf-den-grossvenediger?step=tour" target="_blank">Großvenediger</a>. Und wer dies noch nie gemacht hat, sich aber an das Bergsteigenlernen wagen möchte, der ist in unseren <a href="https://www.alpinewelten.com/bergsteigerschule/gletscherkurse-hochtourenkurse" target="_blank">Hochtouren- und Gletscherkursen</a> und <a href="https://www.alpinewelten.com/bergsteigen-lernen-silvretta?step=tour" target="_blank">Bergsteiger-Kombikurse</a>n bestens aufgehoben, um dort die Basics zu erlernen und erste Erfahrungen zu sammeln. Wen die Vertikale mehr interessiert, der findet in Österreich zahlreiche Klettergebiete und Klettersteige. Ob ein <a href="https://www.alpinewelten.com/klettersteigkurs-erfurter-huette-am-achensee?step=tour" target="_blank">Einsteiger-Klettersteigkurs hoch über dem wunderschön gelegenen Achensee</a>, herausforderndere <a href="https://www.alpinewelten.com/klettersteige-stubaital?step=tour" target="_blank">Klettersteige in den hochalpinen Stubaier Alpen</a> oder <a href="https://www.alpinewelten.com/alpinklettern-allgaeu?step=tour" target="_blank">anspruchsvolles Alpinklettern</a> - hier ist für jeden etwas dabei!
 tours_winter<h2 style="text-align:center">Tourenmöglichkeiten im Winter</h2> Auch im Winter präsentiert sich Österreich als große Spielwiese für alle Wintersportarten. Die Gletscherskigebiete bieten bereits ab Ende November sehr gute Bedingungen für <a href="https://www.alpinewelten.com/bergsteigerschule/tiefschneekurse" target="_blank">Tiefschneekurse</a> zur Verbesserung Deiner Skitechnik abseits der Pisten. <a href="https://www.alpinewelten.com/lawinenkurs-wochenende-rofan?step=tour" target="_blank">Lawinencamps</a> sowie Einsteiger-Skitourenkurse am <a href="https://www.alpinewelten.com/skitourenkurs-rofan?step=tour" target="_blank">Achensee</a> und in der <a href="https://www.alpinewelten.com/skitourenkurs-anfaenger?step=tour" target="_blank">Silvretta</a> bereiten Dich im Verlauf des Winters auf die große Bandbreite der Skitourenmöglichkeiten Österreichs vor. Sehr beliebt ist dabei auch die <a href="https://www.alpinewelten.com/tiefschneekurs-und-skitourenwoche?step=tour" target="_blank">Tiefschnee- und Skitourenwoche auf der Heidelberger Hütte</a>, insbesondere auch über Silvester. Fortgeschrittene Skitourengeher, die es auf die vergletscherten Gipfel zieht, lernen die Basics dafür in Skihochtturenkursen in der <a href="https://www.alpinewelten.com/skihochtourenkurs?step=tour" target="_blank">Silvretta</a> und im <a href="https://www.alpinewelten.com/skihochtourenkurs-franz-senn-huette?step=tour" target="_blank">Stubai</a>. Ansonsten lassen Skitouren im gesamten österreichischen Alpenraum, wie z. B. im <a href="https://www.alpinewelten.com/skitouren-sellrain?step=tour" target="_blank">Sellrain</a>, <a href="https://www.alpinewelten.com/leichte-skitouren-lechtaler-alpen?step=tour" target="_blank">Lechtal</a> oder <a href="https://www.alpinewelten.com/skitouren-mit-genuss-im-raurisertal?step=tour" target="_blank">Raurisertal</a>, aber auch in den <a href="https://www.alpinewelten.com/skitouren-wochenende-in-kitzbuehel?step=tour" target="_blank">Kitzbüheler Alpen</a>, in der <a href="https://www.alpinewelten.com/skitouren-rund-um-die-essener-rostocker-huette?step=tour" target="_blank">Venedigergruppe</a>, Silvretta und am Piz Buin sowie am <a href="https://www.alpinewelten.com/skitour-grossglockner?step=tour" target="_blank">Großglockner</a> und an der <a href="https://www.alpinewelten.com/skitour-top-of-tirol-wildspitze?step=tour" target="_blank">Wildspitze</a> jedes Tourengeherherz höher schlagen. Und schließlich locken große Skidurchquerungen wie die <a href="https://www.alpinewelten.com/ski-transalp-vom-alpennordrand-nach-suedtirol?step=tour" target="_blank">Ski Transalp vom Alpennordrand nach Südtirol</a>, der Skitouren Klassiker Venter Runde - auch als Haute Route der Ostalpen bekannt, und die "Königin der Ostalpen" - die legendäre <a href="https://www.alpinewelten.com/skitour-hoch-tirol?step=tour" target="_blank">Hoch Tirol</a>. Im Winter, wenn die hohen Wasserfälle Österreichs gefroren sind und eine einzigartige Kulisse bilden, beginnt außerdem die Zeit der Eiskletterer. Vom <a href="https://www.alpinewelten.com/bergsteigerschule/eiskletterkurse" target="_blank">Eiskletterkurs für Einsteiger und für Fortgeschrittene</a> bis hin zu <a href="https://www.alpinewelten.com/gefuehrte-reisen/eisklettern" target="_blank">Eiskletterwochenenden</a> mit anspruchsvollen Ein- und Mehrseillängenrouten sind auch hier keine Grenzen gesetzt. Wer es etwas gemütlicher mag und die wunderbare Winterlandschaft sowie die Stille und Abgeschiedenheit abseits der Pistenskigebiete genießen möchte, ist auf Schneeschuhen in Österreichs Bergen unterwegs. <a href="https://www.alpinewelten.com/gefuehrte-reisen/schneeschuhwandern" target="_blank">Schneeschuhwandern</a> erfreut sich einer immer größer werdenden Beliebtheit. Die entschleunigende, fast meditative Fortbewegung durch die tief verschneite Winterlandschaft verspricht ein besonderes Wintererlebnis - Vorkenntnisse sind praktisch nicht notwendig und es funktioniert fast genauso wie das Bergwandern im Sommer. So wird auch Nichtskifahrern ermöglicht, im Winter ins Gebirge und Hochgebirge vorzudringen.
 microsite_id(null)
 Route(array)
 id4090
 hash3fecd0b1ce82b5e3b3172566462a7a2e
 created2020-07-20 11:16:41
 updated2024-08-15 14:03:22
 modelCountry
 foreign_key248
 base/
 aliasreisen-oesterreich
 controllerFrontendCountries.FrontendCountries
 actioncountry
 parent_id(null)
 lft6125
 rght6126
 route/reisen-oesterreich
 FlagUpload(array)
 0(array)
 id397089
 hash29cff9e2ae3e604680c2e5ec62922bf4
 created2020-09-14 08:53:28
 updated2020-09-14 08:53:38
 modelCountry
 fieldflag
 foreign_key248
 aliasflagge-oesterreich.png
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Country/Flag/5f5f137287ac6.png
 size1719
 ext.png
 mimeimage/png
 width550
 height550
 Route(array)
 id3085
 hash6abfc2aa0eac361677e144fa2c8a4bfb
 created2020-01-24 15:30:41
 updated2024-07-18 16:15:16
 modelAccomodation
 foreign_key485
 base/
 aliaskrimmler-tauernhaus
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5185
 rght5186
 route/krimmler-tauernhaus
 Seo(array)
 id3695
 hash181de6abb6aec14f8cd7a284c3249c18
 created2020-06-25 13:46:35
 updated2024-04-24 13:26:51
 modelAccomodation
 foreign_key485
 titleKrimmler Tauernhaus | Krimmler Achental
 descriptionDas Krimmler Tauernhaus ist eine gemütliche Unterkunft im Krimmler Achental. Die gemütliche Unterkunft eignet sich hervorragend als Stützpunkt für Wanderungen, Bergtouren und Hochtouren. Auch im Winter finden sich hier zahlreiche Möglichkeiten für Skitouren und Schneeschuhtouren. Der Gasthof ist frisch renoviert.
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 sitemap_priority0.5
 TeaserMedia(array)
 0(array)
 id10822
 hashf63769617b362bd4bdee5b861424046f
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 titleKrimmler Tauernhaus
 cross_reference_count3
 MediaEntity(array)
 id567097
 pos1
 media_id10822
 modelAccomodation
 fieldteaser
 foreign_key485
 FileUpload(array)
 0(array)
 id572264
 hash30dbee25f000cf04d8aab21b4abe3c2d
 created2021-09-14 10:47:54
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/614061bd427b2.jpg
 size231119
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id764252
 hashb7b9103a29a298135e0852a843992c79
 created2024-04-24 13:26:49
 updated2024-04-24 13:26:49
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id572264
 filewebroot/files/Media/File/ThAccomodationTeaserImage/6628ec78db4f9.jpg
 size77503
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id764253
 hasha1ea984857ded27d471bebc141155aa7
 created2024-04-24 13:26:49
 updated2024-04-24 13:26:49
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id572264
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec79254b1.jpg
 size192845
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id764265
 hashe8af49a0a42661f500304cbbf1112c74
 created2024-04-24 13:26:51
 updated2024-04-24 13:26:51
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id572264
 filewebroot/files/Media/File/ThSeoImageFacebook/6628ec7b7e676.png
 size565001
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id572265
 hash27ba42f8185889a1c68654e4f6eca10c
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id572264
 filewebroot/files/Media/File/ThMediaFileIndex/614061bd43a6d.jpg
 size14574
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id764266
 hash7f2d8e9ce0dcb39beda72fa05a51319a
 created2024-04-24 13:26:52
 updated2024-04-24 13:26:52
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id572264
 filewebroot/files/Media/File/ThSeoImageGoogle/6628ec7bbe6e7.png
 size565001
 ext.png
 mimeimage/png
 width720
 height405
 6(array)
 id572266
 hashcb1a4a521533e8a75fdede702819293d
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id572264
 filewebroot/files/Media/File/CkeditorXs/614061bd74ca4.jpg
 size4474
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 7(array)
 id764267
 hash3af6a957d06ea16f340b8578a5c8058b
 created2024-04-24 13:26:52
 updated2024-04-24 13:26:52
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id572264
 filewebroot/files/Media/File/ThSeoImageTwitter/6628ec7c0b299.png
 size161132
 ext.png
 mimeimage/png
 width375
 height210
 8(array)
 id572267
 hash8db6cfe4e0ca1889e32df0a9f71c6208
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id572264
 filewebroot/files/Media/File/CkeditorSm/614061bdae3bd.jpg
 size14574
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 9(array)
 id572268
 hash3dce679cce23d3a8c5e8c14cffe7194a
 created2021-09-14 10:47:58
 updated2021-09-14 10:47:58
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id572264
 filewebroot/files/Media/File/CkeditorMd/614061bdd3b59.jpg
 size23691
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 10(array)
 id572269
 hash7f12e325e05caa80fa15fe1314a9e947
 created2021-09-14 10:47:58
 updated2021-09-14 10:47:58
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id572264
 filewebroot/files/Media/File/CkeditorLg/614061be0df11.jpg
 size52180
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 GalleryMedia(array)
 0(array)
 id10822
 hashf63769617b362bd4bdee5b861424046f
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 titleKrimmler Tauernhaus
 cross_reference_count3
 MediaEntity(array)
 id567098
 pos1
 media_id10822
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id572264
 hash30dbee25f000cf04d8aab21b4abe3c2d
 created2021-09-14 10:47:54
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/614061bd427b2.jpg
 size231119
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id764252
 hashb7b9103a29a298135e0852a843992c79
 created2024-04-24 13:26:49
 updated2024-04-24 13:26:49
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id572264
 filewebroot/files/Media/File/ThAccomodationTeaserImage/6628ec78db4f9.jpg
 size77503
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id764253
 hasha1ea984857ded27d471bebc141155aa7
 created2024-04-24 13:26:49
 updated2024-04-24 13:26:49
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id572264
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec79254b1.jpg
 size192845
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id764265
 hashe8af49a0a42661f500304cbbf1112c74
 created2024-04-24 13:26:51
 updated2024-04-24 13:26:51
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id572264
 filewebroot/files/Media/File/ThSeoImageFacebook/6628ec7b7e676.png
 size565001
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id572265
 hash27ba42f8185889a1c68654e4f6eca10c
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id572264
 filewebroot/files/Media/File/ThMediaFileIndex/614061bd43a6d.jpg
 size14574
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id764266
 hash7f2d8e9ce0dcb39beda72fa05a51319a
 created2024-04-24 13:26:52
 updated2024-04-24 13:26:52
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id572264
 filewebroot/files/Media/File/ThSeoImageGoogle/6628ec7bbe6e7.png
 size565001
 ext.png
 mimeimage/png
 width720
 height405
 6(array)
 id572266
 hashcb1a4a521533e8a75fdede702819293d
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id572264
 filewebroot/files/Media/File/CkeditorXs/614061bd74ca4.jpg
 size4474
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 7(array)
 id764267
 hash3af6a957d06ea16f340b8578a5c8058b
 created2024-04-24 13:26:52
 updated2024-04-24 13:26:52
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id572264
 filewebroot/files/Media/File/ThSeoImageTwitter/6628ec7c0b299.png
 size161132
 ext.png
 mimeimage/png
 width375
 height210
 8(array)
 id572267
 hash8db6cfe4e0ca1889e32df0a9f71c6208
 created2021-09-14 10:47:57
 updated2021-09-14 10:47:57
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id572264
 filewebroot/files/Media/File/CkeditorSm/614061bdae3bd.jpg
 size14574
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 9(array)
 id572268
 hash3dce679cce23d3a8c5e8c14cffe7194a
 created2021-09-14 10:47:58
 updated2021-09-14 10:47:58
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id572264
 filewebroot/files/Media/File/CkeditorMd/614061bdd3b59.jpg
 size23691
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 10(array)
 id572269
 hash7f12e325e05caa80fa15fe1314a9e947
 created2021-09-14 10:47:58
 updated2021-09-14 10:47:58
 modelMedia
 fieldfile
 foreign_key10822
 aliaskrimmler-tauernhaus-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id572264
 filewebroot/files/Media/File/CkeditorLg/614061be0df11.jpg
 size52180
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 1(array)
 id10820
 hash337a9be25d663a56c2b0d56ca7943d2a
 created2021-09-14 10:46:48
 updated2021-09-14 10:46:48
 titleKrimmler Tauernhaus im Zillertal
 cross_reference_count1
 MediaEntity(array)
 id567099
 pos2
 media_id10820
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id572252
 hash1e988ea3e9ee15028e311629693f8c6d
 created2021-09-14 10:46:47
 updated2021-09-14 10:46:48
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6140617857321.jpg
 size306349
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id572253
 hash387be666c56ecea6a14b491551f9b1e8
 created2021-09-14 10:46:48
 updated2021-09-14 10:46:48
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id572252
 filewebroot/files/Media/File/ThMediaFileIndex/6140617857ed4.jpg
 size14566
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id764254
 hashc310b589b8127f112d894a35a83e08e2
 created2024-04-24 13:26:49
 updated2024-04-24 13:26:49
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id572252
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7960fe4.jpg
 size183722
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id572254
 hash0e7584a28272360e0ec8329ee26d12f9
 created2021-09-14 10:46:48
 updated2021-09-14 10:46:48
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id572252
 filewebroot/files/Media/File/CkeditorXs/614061788306f.jpg
 size4498
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id572255
 hashbe8b561884be3e84cf05a4ae54b4bc0f
 created2021-09-14 10:46:48
 updated2021-09-14 10:46:48
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id572252
 filewebroot/files/Media/File/CkeditorSm/61406178b9fce.jpg
 size14566
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id572256
 hash290b3c1d1a5e25d574dd0c9d5c719323
 created2021-09-14 10:46:49
 updated2021-09-14 10:46:49
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id572252
 filewebroot/files/Media/File/CkeditorMd/61406178e0fa0.jpg
 size23410
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id572257
 hash45c2b5301ea26a78fb95cd1d02311a54
 created2021-09-14 10:46:49
 updated2021-09-14 10:46:49
 modelMedia
 fieldfile
 foreign_key10820
 aliaskrimmler-tauernhaus-im-zillertal-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id572252
 filewebroot/files/Media/File/CkeditorLg/614061790ec69.jpg
 size51798
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 2(array)
 id10821
 hash7699e1172695dafe576663303eb319ac
 created2021-09-14 10:47:20
 updated2021-09-14 10:47:20
 titleKrimmler Tauernhaus Wandern im Zillertal
 cross_reference_count1
 MediaEntity(array)
 id567100
 pos3
 media_id10821
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id572258
 hash0d2568a0e37d1503138b5119928fd103
 created2021-09-14 10:47:19
 updated2021-09-14 10:47:20
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/61406198b009e.jpg
 size227037
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id764255
 hash2764b7fea039b6c0b5faccdcdbcc24fc
 created2024-04-24 13:26:49
 updated2024-04-24 13:26:49
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id572258
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec79b7bdc.jpg
 size203605
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id572259
 hash1e7bc40f49258d2f4ab89ac702f55c24
 created2021-09-14 10:47:20
 updated2021-09-14 10:47:20
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id572258
 filewebroot/files/Media/File/ThMediaFileIndex/61406198b0d4c.jpg
 size14607
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id572260
 hash68c322b8e080751827fecd45a8820143
 created2021-09-14 10:47:21
 updated2021-09-14 10:47:21
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id572258
 filewebroot/files/Media/File/CkeditorXs/61406198dbf8a.jpg
 size4355
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id572261
 hash8b23ea117411660b92be7a4bbfb6e4ae
 created2021-09-14 10:47:21
 updated2021-09-14 10:47:21
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id572258
 filewebroot/files/Media/File/CkeditorSm/614061991f10f.jpg
 size14607
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id572262
 hash5426be1104fc33acd8575fb91383417b
 created2021-09-14 10:47:21
 updated2021-09-14 10:47:21
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id572258
 filewebroot/files/Media/File/CkeditorMd/6140619945e2f.jpg
 size23615
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id572263
 hash9565d60767e5316a345d3c50c8f4435e
 created2021-09-14 10:47:21
 updated2021-09-14 10:47:21
 modelMedia
 fieldfile
 foreign_key10821
 aliaskrimmler-tauernhaus-wandern-im-zillertal-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id572258
 filewebroot/files/Media/File/CkeditorLg/6140619968a4b.jpg
 size53130
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 3(array)
 id9265
 hashd3a2bb0bcc45c171db36379c38384ea6
 created2020-10-15 10:31:01
 updated2020-10-15 10:31:01
 titlekrimmler-tauernhaus-uebersicht
 cross_reference_count1
 MediaEntity(array)
 id567101
 pos4
 media_id9265
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414323
 hash66eced5ef44b9f4442fcd91bdade7f8e
 created2020-10-15 10:30:52
 updated2020-10-15 10:31:01
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f8808c5b698c.jpg
 size298193
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487462
 hash5aa8d6cc2aa8d5a19ca391db37c77a05
 created2020-10-28 02:47:11
 updated2020-10-28 02:47:11
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414323
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd9f54646.jpg
 size13445
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487463
 hashbe79a42e7fc55bedc70e234f621d5aee
 created2020-10-28 02:47:11
 updated2020-10-28 02:47:11
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414323
 filewebroot/files/Media/File/CkeditorXs/5f98cd9f8a160.jpg
 size4195
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487464
 hash678c9afe36ae740a40abbad5d18aa4e6
 created2020-10-28 02:47:12
 updated2020-10-28 02:47:12
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414323
 filewebroot/files/Media/File/CkeditorSm/5f98cd9fcd06e.jpg
 size13445
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487465
 hashc1bb0126b5d6f44bf68a6788684768b0
 created2020-10-28 02:47:12
 updated2020-10-28 02:47:12
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414323
 filewebroot/files/Media/File/CkeditorMd/5f98cda011025.jpg
 size21455
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487466
 hashde470dd2cbec4714b3e4b6c632824f1f
 created2020-10-28 02:47:12
 updated2020-10-28 02:47:12
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414323
 filewebroot/files/Media/File/CkeditorLg/5f98cda043e1c.jpg
 size47573
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764256
 hash981aeb57f0b6a9240ad24e49f4fa966e
 created2024-04-24 13:26:50
 updated2024-04-24 13:26:50
 modelMedia
 fieldfile
 foreign_key9265
 aliaskrimmler-tauernhaus-uebersicht-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414323
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec79e86b2.jpg
 size165596
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 4(array)
 id9267
 hashedf5fc196fcf2543610f0325aad649ad
 created2020-10-15 10:31:47
 updated2020-10-15 10:31:47
 titlekrimmler-tauernhaus-zimmer
 cross_reference_count1
 MediaEntity(array)
 id567102
 pos5
 media_id9267
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414336
 hash9cb625bdcd1a2001ad60e409bc1c49fc
 created2020-10-15 10:31:38
 updated2020-10-15 10:31:47
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f8808f39018d.jpg
 size344680
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487472
 hash44b661d6931c35454371766be4f151ef
 created2020-10-28 02:47:13
 updated2020-10-28 02:47:13
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414336
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cda1917f2.jpg
 size19853
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487473
 hash4f47f713469f9b9f432f0b42d806b396
 created2020-10-28 02:47:14
 updated2020-10-28 02:47:14
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414336
 filewebroot/files/Media/File/CkeditorXs/5f98cda1c757c.jpg
 size6595
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487474
 hash9a25d317c02bd18a40315f91beb3a235
 created2020-10-28 02:47:14
 updated2020-10-28 02:47:14
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414336
 filewebroot/files/Media/File/CkeditorSm/5f98cda217978.jpg
 size19853
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487475
 hash87ea8387a980923bb10751656bbebbc7
 created2020-10-28 02:47:14
 updated2020-10-28 02:47:14
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414336
 filewebroot/files/Media/File/CkeditorMd/5f98cda24b546.jpg
 size31781
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487476
 hashd7c941d2afb3322ee9d9798bdcb6e7f9
 created2020-10-28 02:47:14
 updated2020-10-28 02:47:14
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414336
 filewebroot/files/Media/File/CkeditorLg/5f98cda27b345.jpg
 size64657
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764257
 hash1a023feeb37c3391e08f7481f04b4fce
 created2024-04-24 13:26:50
 updated2024-04-24 13:26:50
 modelMedia
 fieldfile
 foreign_key9267
 aliaskrimmler-tauernhaus-zimmer-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414336
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7a1b33d.jpg
 size102442
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 5(array)
 id9266
 hashb78d7a908cc7c53c99f171fe2ca28ffb
 created2020-10-15 10:31:20
 updated2020-10-15 10:31:20
 titlekrimmler-tauernhaus-waschraum
 cross_reference_count1
 MediaEntity(array)
 id567103
 pos6
 media_id9266
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414329
 hash962f2c3109b6bbdc3de80dbbf3eea61a
 created2020-10-15 10:31:10
 updated2020-10-15 10:31:20
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f8808d8b42e3.jpg
 size320377
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487467
 hashde7d2172e0ea03f1bed678125d154d26
 created2020-10-28 02:47:12
 updated2020-10-28 02:47:12
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414329
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cda078bea.jpg
 size17130
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487468
 hash6933219de9cb852e18911200bb179ca0
 created2020-10-28 02:47:13
 updated2020-10-28 02:47:13
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414329
 filewebroot/files/Media/File/CkeditorXs/5f98cda0b823e.jpg
 size6057
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487469
 hash2ad50eafd932c027d1722f8e4d0906fa
 created2020-10-28 02:47:13
 updated2020-10-28 02:47:13
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414329
 filewebroot/files/Media/File/CkeditorSm/5f98cda1075c8.jpg
 size17130
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487470
 hashbea15cba6b361cc26c22ea436301d4b9
 created2020-10-28 02:47:13
 updated2020-10-28 02:47:13
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414329
 filewebroot/files/Media/File/CkeditorMd/5f98cda13b443.jpg
 size26704
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487471
 hash741fdd56b366967a04de8dd46af3c79a
 created2020-10-28 02:47:13
 updated2020-10-28 02:47:13
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414329
 filewebroot/files/Media/File/CkeditorLg/5f98cda168b12.jpg
 size54177
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764258
 hash502bb66fc02e794fd4c2f7057d893375
 created2024-04-24 13:26:50
 updated2024-04-24 13:26:50
 modelMedia
 fieldfile
 foreign_key9266
 aliaskrimmler-tauernhaus-waschraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414329
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7a435e1.jpg
 size93612
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 6(array)
 id9259
 hashba5f373d933ef2fd0f45153eca0852d2
 created2020-10-15 10:29:00
 updated2020-10-15 10:29:00
 titlekrimmler-tauernhaus-gang
 cross_reference_count1
 MediaEntity(array)
 id567104
 pos7
 media_id9259
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414286
 hash0fab9c5b6e3b956dbc8041889194ec55
 created2020-10-15 10:28:51
 updated2020-10-15 10:29:00
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f88084cdc1b5.jpg
 size311273
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487432
 hash4024d71deb81459d0520a412c3d1b1b2
 created2020-10-28 02:47:04
 updated2020-10-28 02:47:04
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414286
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd97eeb02.jpg
 size9021
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487433
 hashba4541f1c04e68ae83915d6c97de0867
 created2020-10-28 02:47:04
 updated2020-10-28 02:47:04
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414286
 filewebroot/files/Media/File/CkeditorXs/5f98cd983783e.jpg
 size3127
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487434
 hash178c30ce04526d21dc7de7d40a888b0e
 created2020-10-28 02:47:04
 updated2020-10-28 02:47:04
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414286
 filewebroot/files/Media/File/CkeditorSm/5f98cd987ccac.jpg
 size9021
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487435
 hash4f0d5f1e93da914ca5155217d8e44edd
 created2020-10-28 02:47:04
 updated2020-10-28 02:47:04
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414286
 filewebroot/files/Media/File/CkeditorMd/5f98cd98ae147.jpg
 size14096
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487436
 hashb5022161bd868005a615d0f49f49f93e
 created2020-10-28 02:47:05
 updated2020-10-28 02:47:05
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414286
 filewebroot/files/Media/File/CkeditorLg/5f98cd98dc1df.jpg
 size30296
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764259
 hashfe863217138e4fe387800fbd5db9e000
 created2024-04-24 13:26:50
 updated2024-04-24 13:26:50
 modelMedia
 fieldfile
 foreign_key9259
 aliaskrimmler-tauernhaus-gang-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414286
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7a68828.jpg
 size92208
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 7(array)
 id9263
 hash79e63c3291f18eefe38666e21e7bf472
 created2020-10-15 10:30:15
 updated2020-10-15 10:30:15
 titlekrimmler-tauernhaus-lager
 cross_reference_count1
 MediaEntity(array)
 id567105
 pos8
 media_id9263
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414310
 hash788e76a8742c4c3dc4f37e55edae91b2
 created2020-10-15 10:30:04
 updated2020-10-15 10:30:15
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f880897cf558.jpg
 size282766
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487452
 hash54b80af57308567ea263a8f67b454d30
 created2020-10-28 02:47:08
 updated2020-10-28 02:47:08
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414310
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd9c7c62e.jpg
 size19269
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487453
 hashabd4cb1ae9d348ea10a2470ce310451a
 created2020-10-28 02:47:09
 updated2020-10-28 02:47:09
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414310
 filewebroot/files/Media/File/CkeditorXs/5f98cd9cbac33.jpg
 size6655
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487454
 hash3d6150de482714488532f2c7eb1c9e0a
 created2020-10-28 02:47:09
 updated2020-10-28 02:47:09
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414310
 filewebroot/files/Media/File/CkeditorSm/5f98cd9d098b2.jpg
 size19269
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487455
 hash6a4488cd9a8bf0e6731d5acfb47f5dff
 created2020-10-28 02:47:09
 updated2020-10-28 02:47:09
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414310
 filewebroot/files/Media/File/CkeditorMd/5f98cd9d3c9bd.jpg
 size30190
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487456
 hash266b5f5825a4f985fdfd2f4d53e8d8e4
 created2020-10-28 02:47:09
 updated2020-10-28 02:47:09
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414310
 filewebroot/files/Media/File/CkeditorLg/5f98cd9d6af65.jpg
 size60692
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764260
 hashb22d738861d6ed431e2320d508c67561
 created2024-04-24 13:26:50
 updated2024-04-24 13:26:50
 modelMedia
 fieldfile
 foreign_key9263
 aliaskrimmler-tauernhaus-lager-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414310
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7a8d481.jpg
 size84714
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 8(array)
 id9258
 hashb191cfa33e51b16d4d7406149e4b66b2
 created2020-10-15 10:28:44
 updated2020-10-15 10:28:44
 titlekrimmler-tauernhaus-aussen
 cross_reference_count1
 MediaEntity(array)
 id567106
 pos9
 media_id9258
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414280
 hash64153d5f3d77ddc13577a3c25747a67f
 created2020-10-15 10:28:35
 updated2020-10-15 10:28:44
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f88083c0a309.jpg
 size316288
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487427
 hash14848b42302a1a97f5bc9b1da83c9b46
 created2020-10-28 02:47:02
 updated2020-10-28 02:47:02
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414280
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd964998d.jpg
 size14510
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487428
 hash8fb2621efc397e143b235bb927d71088
 created2020-10-28 02:47:02
 updated2020-10-28 02:47:02
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414280
 filewebroot/files/Media/File/CkeditorXs/5f98cd9681b7c.jpg
 size4441
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487429
 hashee9bfc38b2f394631535c846a6c5417a
 created2020-10-28 02:47:03
 updated2020-10-28 02:47:03
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414280
 filewebroot/files/Media/File/CkeditorSm/5f98cd96c75d7.jpg
 size14510
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487430
 hash9118d1425c6dca79ef61a17b684d5f75
 created2020-10-28 02:47:03
 updated2020-10-28 02:47:03
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414280
 filewebroot/files/Media/File/CkeditorMd/5f98cd970ac15.jpg
 size23306
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487431
 hash63b5894b256288ab5e091433f48814bd
 created2020-10-28 02:47:03
 updated2020-10-28 02:47:03
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414280
 filewebroot/files/Media/File/CkeditorLg/5f98cd97372fd.jpg
 size51514
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764261
 hash9c1f2816e232acea61517d06dad241d5
 created2024-04-24 13:26:50
 updated2024-04-24 13:26:50
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414280
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7ab706c.jpg
 size196703
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 7(array)
 id493764
 hash8f5b7ae71f37cc2ab90ba0a67c4fa091
 created2020-11-02 14:16:29
 updated2020-11-02 14:16:29
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id414280
 filewebroot/files/Media/File/ThAccomodationTeaserImage/5fa006ad5b1a1.jpg
 size76763
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 8(array)
 id493775
 hash62d70507b84bedc90fdf5df0363667ca
 created2020-11-02 14:16:33
 updated2020-11-02 14:16:33
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id414280
 filewebroot/files/Media/File/ThSeoImageFacebook/5fa006b05c5ad.png
 size2214985
 ext.png
 mimeimage/png
 width1500
 height843
 9(array)
 id493776
 hash39bdc0c2e548cafb71aebc59cb3f4a65
 created2020-11-02 14:16:34
 updated2020-11-02 14:16:34
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id414280
 filewebroot/files/Media/File/ThSeoImageGoogle/5fa006b13d97d.png
 size2214985
 ext.png
 mimeimage/png
 width1500
 height843
 10(array)
 id493777
 hash0d97366e5d8ca9d294f1b5d2c4e5ab94
 created2020-11-02 14:16:34
 updated2020-11-02 14:16:34
 modelMedia
 fieldfile
 foreign_key9258
 aliaskrimmler-tauernhaus-aussen-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id414280
 filewebroot/files/Media/File/ThSeoImageTwitter/5fa006b2182a2.png
 size157411
 ext.png
 mimeimage/png
 width375
 height210
 9(array)
 id9260
 hashe25e3c5878604ceb670ab3689311856a
 created2020-10-15 10:29:19
 updated2020-10-15 10:29:19
 titlekrimmler-tauernhaus-gastraum
 cross_reference_count1
 MediaEntity(array)
 id567107
 pos10
 media_id9260
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414292
 hash54a674629c902dccc82ed9e70410d113
 created2020-10-15 10:29:08
 updated2020-10-15 10:29:19
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f88085f057ff.jpg
 size337587
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487437
 hash75e716981c5ce09c701af8a268c7b80c
 created2020-10-28 02:47:05
 updated2020-10-28 02:47:05
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414292
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd99101d9.jpg
 size24562
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487438
 hashe4ea9240e8456069d86e0c2e7ce1c3b3
 created2020-10-28 02:47:05
 updated2020-10-28 02:47:05
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414292
 filewebroot/files/Media/File/CkeditorXs/5f98cd99584a9.jpg
 size7721
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487439
 hashd9d696e936c2e38df5e9c0c4083e01cb
 created2020-10-28 02:47:05
 updated2020-10-28 02:47:05
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414292
 filewebroot/files/Media/File/CkeditorSm/5f98cd999d3b4.jpg
 size24562
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487440
 hashac17fda1e6892717e2c50b448caa5d28
 created2020-10-28 02:47:06
 updated2020-10-28 02:47:06
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414292
 filewebroot/files/Media/File/CkeditorMd/5f98cd99d5d6e.jpg
 size40086
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487441
 hashef2858f2301540c182602c1eedbc6d1a
 created2020-10-28 02:47:06
 updated2020-10-28 02:47:06
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414292
 filewebroot/files/Media/File/CkeditorLg/5f98cd9a17e89.jpg
 size85201
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764262
 hashdab8666b668f95ebb0864890b331c76a
 created2024-04-24 13:26:51
 updated2024-04-24 13:26:51
 modelMedia
 fieldfile
 foreign_key9260
 aliaskrimmler-tauernhaus-gastraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414292
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7ae78c7.jpg
 size177839
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 10(array)
 id9261
 hashb31c9fc9066454d0a7d9a60cae1eed7e
 created2020-10-15 10:29:37
 updated2020-10-15 10:29:37
 titlekrimmler-tauernhaus-impression
 cross_reference_count1
 MediaEntity(array)
 id567108
 pos11
 media_id9261
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414298
 hash82b865a36547a0deddffe6efa8d33bba
 created2020-10-15 10:29:29
 updated2020-10-15 10:29:37
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f88087184c62.jpg
 size323874
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487442
 hash32c22b90ebd4a7a8a33206c107a24856
 created2020-10-28 02:47:06
 updated2020-10-28 02:47:06
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414298
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd9a4a81c.jpg
 size24197
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487443
 hash2543284338c7e0d317c5211b52830d6e
 created2020-10-28 02:47:06
 updated2020-10-28 02:47:06
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414298
 filewebroot/files/Media/File/CkeditorXs/5f98cd9a8bf5a.jpg
 size7677
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487444
 hash0b436f042067623fcfa1849e81a2f2c4
 created2020-10-28 02:47:07
 updated2020-10-28 02:47:07
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414298
 filewebroot/files/Media/File/CkeditorSm/5f98cd9acdf4a.jpg
 size24197
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487445
 hashc06eb910cb53ca13e277736038192878
 created2020-10-28 02:47:07
 updated2020-10-28 02:47:07
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414298
 filewebroot/files/Media/File/CkeditorMd/5f98cd9b0decd.jpg
 size38555
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487446
 hash9edfff56feb012c036f3afd250e7317a
 created2020-10-28 02:47:07
 updated2020-10-28 02:47:07
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414298
 filewebroot/files/Media/File/CkeditorLg/5f98cd9b3ac5b.jpg
 size80946
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id590914
 hashc532fcb09cfdea8a206d69746559a513
 created2021-11-09 10:55:45
 updated2021-11-09 10:55:45
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id414298
 filewebroot/files/Media/File/ThTourHeaderImage/618a45a197b70.jpg
 size94996
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 7(array)
 id764263
 hash743822b6c8be612f17229b1a69d4cf8c
 created2024-04-24 13:26:51
 updated2024-04-24 13:26:51
 modelMedia
 fieldfile
 foreign_key9261
 aliaskrimmler-tauernhaus-impression-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414298
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7b24270.jpg
 size173766
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 11(array)
 id9264
 hashc27f3d6f52597243922a5ced7d98d862
 created2020-10-15 10:30:36
 updated2020-10-15 10:30:36
 titlekrimmler-tauernhaus-terrasse
 cross_reference_count1
 MediaEntity(array)
 id567109
 pos12
 media_id9264
 modelAccomodation
 fieldgallery
 foreign_key485
 FileUpload(array)
 0(array)
 id414316
 hash43099a0a84859ebe910e569388ad2c22
 created2020-10-15 10:30:27
 updated2020-10-15 10:30:36
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f8808ac5d304.jpg
 size291830
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id487457
 hash3a13f76bce6a5c89aae312476409cb84
 created2020-10-28 02:47:10
 updated2020-10-28 02:47:10
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id414316
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd9e182c8.jpg
 size20410
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id487458
 hash14136e78890710125bd87784b6550893
 created2020-10-28 02:47:10
 updated2020-10-28 02:47:10
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id414316
 filewebroot/files/Media/File/CkeditorXs/5f98cd9e78021.jpg
 size6599
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id487459
 hashe36e2cdf4256bc8fecb3d65dee8b0d3f
 created2020-10-28 02:47:10
 updated2020-10-28 02:47:10
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id414316
 filewebroot/files/Media/File/CkeditorSm/5f98cd9eba5f3.jpg
 size20410
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id487460
 hash999b730648673641637c680a5da2602f
 created2020-10-28 02:47:11
 updated2020-10-28 02:47:11
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id414316
 filewebroot/files/Media/File/CkeditorMd/5f98cd9eee650.jpg
 size32887
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id487461
 hasha9d3f32909b08aad03464ebebe7363af
 created2020-10-28 02:47:11
 updated2020-10-28 02:47:11
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id414316
 filewebroot/files/Media/File/CkeditorLg/5f98cd9f29ed6.jpg
 size68838
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id764264
 hash83b0a878828e7ed22f3dfe5807644a9d
 created2024-04-24 13:26:51
 updated2024-04-24 13:26:51
 modelMedia
 fieldfile
 foreign_key9264
 aliaskrimmler-tauernhaus-terrasse-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id414316
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6628ec7b4f0bb.jpg
 size140909
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 TagsTag(empty)
 TravelReport(empty)
- accomodationTours(array)
 0(array)
 Tour(array)
 id344
 hashee22f470b8e85dac5702cded25194310
 created2020-01-14 16:44:27
 updated2024-10-02 15:38:16
 tour_number420000000344
 titleWandern im Zillertal | Dreiländertour
 subtitleHochalpine Bergwanderung auf dem Fernwanderweg
 participants_min5
 participants_max8
 duration_days5
 duration_typetour_week
 tour_price969.00
 down_payment20
 country_of_serviceeu
 saisonsummer
 travel_insurance_certificate(true)
 out_of_alpine_tour(false)
 rating_condition3
 rating_technique3
 rating_experience2
 rating_difficulty_categorymedium
 rating_seriousness2
 rating_overall_score2.5
 start_zip6290
 start_cityBrandberg
 start_streetZillergrund 78
 start_countryAT
 start_meeting_pointam Parkplatz Bärenbadalm - am Eingang der Alm
 start_time11:15:00
 end_alternate_address(false)
 end_time17:00:00
 flight(false)
 flight_details(null)
 consultation
 region_id9
 services_excluded
 mountain_guide_tour_info
 video_url
 customer_tour_info
 firm_id1
 gmap_zoom13
 gmap_long12.038604
 gmap_marker(false)
 gmap_typeoa_topo
 gmap_lat47.121719
 callout_iconnew
 travel_information<h3>Unterkunftsempfehlung:</h3> Eine gute Unterkunft direkt in Mayrhofen ist die Pension "Das Monika". Wenn Du eine Übernachtungsmöglichkeit vor oder nach der Tour suchst, wende Dich bitte direkt an die Unterkunft. <h3>Das Monika</h3> Fischerstraße 503 A-6290 Mayrhofen Tel.: +43 528562178 Email: <a href="mailto:andrea@baerenbad-alm.at">i</a><a href="mailto:info@das-monika.at">nfo@das-monika.at</a> <a href="https://www.baerenbad-alm.at/" target="_blank">https://www.d</a><a href="https://www.das-monika.at" target="_blank">as-monika.at</a>
 meeting_point_map_lat47.121719
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_topo
 meeting_point_map_zoom12
 meeting_point_map_long12.038604
 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> </h2> <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 ins Gepäck 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_cancellation11
 execution_feasibilitylow
 days_before_start_for_last_notice11
 last_tour_date_number176
 tourstart_weekday1
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 callout_icon_multiple264
 microsite_id(null)
 is_archive(false)
 is_service(false)
 covid_note(false)
 importancegold
 internal_marknone
 responsible_user_id(null)
 is_service_event(false)
 partner_title
 pay_later_hint(false)
 event_duration
 distance
 ascent
 descent
 destination_menu_id(null)
 gmap47.121719,12.038604
 meeting_point_map47.121719,12.038604
 end_zip6290
 end_cityBrandberg
 end_streetZillergrund 78
 end_countryAT
 price_excl_flight969.00
 highlight1
 TourTexts(array)
 id334
 hash94415b5cf3c7c729461772b0313642ac
 created2020-01-14 16:44:27
 updated2024-10-02 15:38:30
 tour_id344
 ws_text_short_descriptionNaturgewaltige Wanderung auf der Dreiländertour mit Gletscherblick in den Nationalpark Hohe Tauern. In 6 Tagen von Hütte zu Hütte durchs Hochgebirge, vom Zillertal in die Hohen Tauern. 
 ws_text_requirementsMittelschwere & schwere Bergwege ROT & SCHWARZ. Für die geführte Wanderung auf der Dreiländertour in den Hohen Tauern solltest Du als erfahrener Bergwanderer über eine gute Kondition für Gehzeiten bis 7 Stunden verfügen. Die Aufstiege auf dem Fernwanderweg Hohe Tauern betragen maximal 1.050 Höhenmeter am Tag. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt beim Wandern ca. 300 Höhenmeter pro Stunde. Anstrengende Abstiege bis 1.350 Höhenmeter sind zu meistern. Es sind auf dem Weg der Dreiländertour einige schwarze Passagen, die zu meistern sind, jedoch ohne Absturzgefahr und im Blockgelände. Die Passagen erfordern dennoch Trittsicherheit und Schwindelfreiheit. <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> </ul> 1.050 Hm1.350 Hm800m 7 hROT & SCHWARZFrühstück
 ws_text_travel_program<h3>1. Tag: Anstieg zur Plauener Hütte</h3> Treffpunkt ist am späten Vormittag im Zillertal oberhalb des Inntals am Parkplatz Bärenbadalm auf 1.450 Metern Höhe. Der Aufstieg zur Plauener Hütte und zum Fernwanderweg Dreiländertour führt über Almwiesen bis an den Rand der Staumauer des Speichers Zillergründl. Von hier wandern wir über den „alten Weg“ zur Plauener Hütte, wo wir eine grandiose Aussicht genießen. Auf 2.363 m Höhe verbringen wir die erste Nacht unserer geführten Bergwanderung. 950 Hm50 Hm800m 3 - 4 hsehr schwerHalbpension <h3>2. Tag: Über die Zillerplattenscharte zur Richterhütte</h3> Früh starten wir auf diese atemberaubende und lange Etappe, die auf dem Hannemannweg über die Zillerplattenscharte führt. Zu Beginn geht es gemütlich los, bis sich zum Schluss der Weg aufsteilt und durch Blockgelände bis in die Scharte auf 2.874 m Höhe führt. Die Aussicht auf die umliegenden Gipfel und hinunter auf den Eissee ist grandios und belohnen alle Anstrengungen des Aufstiegs! Über alpines Gelände geht es unterhalb der Zillerplattenspitze weiter zum nächsten Übergang, der Windbachscharte. Die Richterhütte ist jetzt nicht mehr weit und damit das Ziel unserer zweiten Etappe auf der Dreiländertour. 600m700m 900 Hm 6 hsehr schwerHalbpension <h3>3. Tag: Wandern im Nationalpark Hohe Tauern</h3> Der Tag beginnt mit einem kurzen Abstieg in Richtung Keesboden, bevor wir die Querung unterhalb des Gabler auf 2.200 m beginnen. Der Weg führt auf dem Peter-Obholzer-Weg vorbei an kleinen Gletscherseen, die Höhe haltend in Richtung der Roßkarscharte. Je näher die Scharte rückt, desto steiler führt der Weg schließlich bergan. Auf 2.689 Metern wird der höchste Punkt des heutigen Tages erreicht. Eine Möglichkeit bei gutem Wetter ist die Gipfelbesteigung des Roßkopf (2.845 m), der ein gigantisches Panorama bietet. Der Umweg von knapp einer Stunde lohnt sich auf jeden Fall! Nach einer Brotzeit geht es über Gletscherschliffe bis zur wunderschön am Wildgerlossee gelegenen Zittauer Hütte (2.328 m), wo wir heute übernachten. 700 Hm750 Hm800m 5 hsehr schwerHalbpension <h3>4. Tag: Abstieg zum Krimmler Tauernhaus</h3> Ein kurzes Wegstück geht es auf bekanntem Weg zurück und hinauf zum Oberen Gerlossee, der auf knapp 2.500 m liegt. Die Rainbachscharte wird über einige kurze Serpentinen erreicht und ist mit 2.700 m der höchste Punkt für heute. Der erste Teil des Abstiegs führt steil nach unten bis zum Rainbachsee. Ab hier wird es flacher und die Wanderwege führen durch große Latschenfelder und später durch einen schönen Zirbenwald ins Krimmler Achental zurück in die Vegetation. Das heutige Ziel ist das idyllisch gelegene Krimmler Tauernhaus auf 1.631 m Höhe. Hier lassen wir den Tag ausklingen und verbringen eine weitere Nacht im Nationalpark Hohe Tauern. 400 Hm1.100 Hm800m 5 hsehr schwerHalbpension <h3>5. Tag: Durch das Krimmler Achental zur Birnlückenhütte</h3> Die heutige Wanderung im Nationalpark Hohe Tauern beginnt zunächst sehr gemütlich mit dem idyllischen Weg durch das Krimmler Achental. Immer weiter in Richtung Talschluss haben wir die Dreitausender Simonyspitze und Maurerkees im Blick. Schließlich biegen wir ab hinauf bis zur Birnlücke auf 2.666m. Dieser Übergang ist die Grenze zwischen Österreich und Italien und oben angekommen eröffnet sich der Blick zurück auf die hohen 3.000er Gletscherberge der Hohen Tauern. Die gleichnamige Birnlückenhütte liegt auf 2.441 m am Fuße der Dreiherrnspitze und ist bereits von der Birnlücke aus zu sehen. Hier verbringen wir die Nacht weit über dem bekannten Südtiroler Ahrntal. 1.050 Hm250 Hm800m 6 hsehr schwerHalbpension <h3>6. Tag: Abschluss auf der Dreiländertour</h3> Der letzte Tag auf dem Fernwanderweg hat es noch einmal in sich und wird der längste unserer 6 Tagetour werden. So starten wir früh auf der italienischen Seite auf dem Lausitzer Weg bis zur Neugersdorfer Hütte und dann weiter zum Heilig-Geist-Jöchl auf knapp 2.700 m Höhe. Von hier geht es in Richtung Plauener Hütte und dann hinab ins Zillergründl. Der Weg führt entlang des Stausees bis zur Staumauer und der Bushaltestelle, an der wir den letzten Abstieg bis zum Parkplatz mit dem Bus verkürzen können. Hier endet die eindrucksvolle und naturgewaltige Wanderung von Hütte zu Hütte in den Hohen Tauern. 750 Hm1.350 Hm800m 8 hsehr schwerFrühstück
 ws_text_services<ul> <li>Speisen und Getränke außerhalb der Halbpension</li> <li>Maut in den Zillergrund 10 €/PKW (Mit dem Linienbus ist es günstiger!)</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 7 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, Schweizer Alpenclub SAC, Ö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_description<h3>Wandern auf der Dreiländertour in den hohen Tauern</h3> Die Hohen Tauern beherbergen mit 5 Schutzgebieten den größten Schutzgebietsverbund Mitteleuropas. Am Rande dieses Gebietes führt der Fernwanderweg durch die Zillertaler Alpen und die Hohen Tauern bis nach Südtirol. Auf einer Fläche von rund 2.750 Quadratkilometern ist es ein großes länderübergreifendes Schutzgebiet mit dem Ziel das Natur- und Kulturerbe der Alpen weiterzugeben. Die Geologie im Urgestein ist genauso interessant wie die Gletscherflächen im Hochgebirge der Tauern. Die Dreiländertour bietet zudem noch Historie, denn die Höhenwege und Übergänge waren bereits in der Steinzeit Pässe, die den Norden und Süden auf Handelswegen miteinander verbunden haben.
 ws_text_accomodationWährend der geführten Wanderung auf der Dreiländertour | Wanderung in den Hohen Tauern sind die folgenden wunderschön gelegenen Hütten unser Ziel. Wir schlafen im Bergsteiger-Lager mit Halbpension. Die Hütten verfügen über Waschräume. Aufgrund der eingeschränkten Wasserversorgung im Hochsommer ist das Duschen nicht immer möglich. Die Lage der Hütten ist außerordenlich schön und die Verpflegung hervorragend. <h3>Informationen zur Unterkunft</h3> <ul> <li>Übernachtung in Hütten mit Halbpension im Lager</li> <li>Plauener Hütte, Richterhütte, Zittauer Hütte, Krimmler Tauerhaus, Brinlückenhütte</li> </ul> Fragen zur Unterkunft | Wir geben Antworten!
 ws_text_course_content
 ws_text_overview
 ws_text_advantages<ul> <li>Wandern im Nationalpark Hohe Tauern</li> <li>Abseits vielbegangener Routen</li> <li>Naturgewalten, Gletscherberge</li> <li>Kleingruppen - wie gewohnt bei Alpine Welten</li> <li>Sehr gut mit dem ÖPNV erreichbar</li> </ul>
 ws_text_detail_description_new<h3>Wandern am Alpenhauptkamm | "Dreiländertour"</h3> Die eindrucksvolle und abwechslungsreiche Wanderung führt Dich vom Zillertal ins größte Schutzgebiet der Alpen, den Nationalpark Hohe Tauern. Die Landesgrenzen auf dem hochalpinen Fernwanderweg bilden Tirol, Salzburg und Südtirol. Wir wandern tief hinein in den Nationalpark Hohe Tauern mit seinen wildromantischen Bergseen, tiefen Tälern, majestätischen und vergletscherten Bergen, phantastischen Ausblicken sowie idyllischen Berghütten. Die geführte Wanderung in den Hohen Tauern ist nicht so viel begangen, so dass es hier noch sehr viele "ruhige Plätze" abseits der bekannten Routen zu finden gibt.
 ws_text_information_new
 ws_text_accomodation_new
 ws_text_arrival(null)
 Route(array)
 id3071
 hashcf5faaab2acf106710db09d6cc7fcced
 created2020-01-14 16:44:27
 updated2024-10-02 15:38:30
 modelTour
 foreign_key344
 base/
 aliaswandern-im-zillertal-dreilaendertour
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft5165
 rght5166
 route/wandern-im-zillertal-dreilaendertour
 Types(array)
 0(array)
 id5
 hashcce9afa6074d7a7edee83520b6a3bc54
 created2015-09-18 13:15:59
 updated2019-01-10 15:51:02
 titleBergwanderungen
 oa_categoriesofferHiking
 use_for_mountain_guide_tour_search(false)
 tour_main_type_id3
 tour_count72
 TourTypesTour(array)
 id37208
 tour_id344
 tour_type_id5
 TourMainType(array)
 id3
 hash2fb0a759edb324800d3f4c36dad9501b
 created2019-01-10 15:41:38
 updated2024-01-23 08:15:39
 titleBergwandern
 position3
 packing_list_text_start<h3>Ausrüstungsliste für Bergwanderungen</h3> <ul> <li>Detailliert mit nützlichen Ausrüstungstipps (?)</li> <li>Kurz vor Tourbeginn Wetter- & Ausrüstungscheck - ggf. Ergänzung</li> <li>Achte auf Deine Schuhwahl! - <a href="https://akademie.alpinewelten.com/bergwandern/bergschuhe">Hier findest Du viele Infos zum Thema. </a></li> </ul>
 packing_list_text_end<h3>Tipps zur Ausrüstung beim Wandern</h3> <ul> <li style="text-align:justify">Packe Deinen Rucksack bereits zu Hause zur Probe. </li> <li style="text-align:justify">Jedes Gramm zählt!</li> <li style="text-align:justify">Es könnte regnen! - Ein großer Packsack (Alternativ Müllsack) & ein Regenschirm halten Dich trocken!!! Regenponchos werden auf Tour nicht toleriert (Stolper/Sturzgefahr)</li> <li style="text-align:justify">Wanderstöcke sind NICHT zwingend notwendig - Machen aber Sinn</li> <li style="text-align:justify">Antworten auf häufige Fragen zur Ausrüstung & Schuhen findest Du in den FAQ.</li> <li style="text-align:justify">Extra für Dich: Bereite Dich vor mit Tipps und Videos in der <a href="https://akademie.alpinewelten.com/bergwandern">Alpine Welten Akademie</a>. </li> </ul> <figure class="img-center" 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="13679"> </div> <figcaption class="hidden"></figcaption> </figure> *Bedingungen
 IconUpload(array)
 0(array)
 id384634
 hash11fc38d30fdd83efa61db88da9e4c400
 created2020-08-18 08:59:02
 updated2020-08-18 08:59:04
 modelTourMainType
 fieldicon
 foreign_key3
 aliasic-bergwandern.svg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/TourMainType/Icon/5f3b7c3855aeb.svg
 size1308
 ext.svg
 mimeimage/svg+xml
 width(null)
 height(null)
 TeaserImageMedia(array)
 0(array)
 id11125
 hash191d15ff8a3be6587026d5f3a62b0db0
 created2021-11-22 13:28:23
 updated2021-11-22 13:28:23
 titleNeuschnee Berge Hohe Tauern auf der Dreilaender Wanderung Panorama
 cross_reference_count3
 MediaEntity(array)
 id607705
 pos1
 media_id11125
 modelTour
 fieldteaser_image
 foreign_key344
 FileUpload(array)
 0(array)
 id596215
 hash7f0c1c772afadbca233d1097758269bd
 created2021-11-22 13:28:22
 updated2021-11-22 13:28:23
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/619b8ce7b3ec9.jpg
 size255635
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id815106
 hashbb226f603cf626cbf921f2a0717e112b
 created2024-10-02 15:38:31
 updated2024-10-02 15:38:31
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id596215
 filewebroot/files/Media/File/ThSeoImageFacebook/66fd4cd6c9dbd.png
 size486980
 ext.png
 mimeimage/png
 width720
 height405
 2(array)
 id815107
 hashf4579b937503f02ec9096031e65ce12a
 created2024-10-02 15:38:31
 updated2024-10-02 15:38:31
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id596215
 filewebroot/files/Media/File/ThSeoImageGoogle/66fd4cd7077c6.png
 size486980
 ext.png
 mimeimage/png
 width720
 height405
 3(array)
 id815108
 hash593decfa6f510d83514b304b24007ce6
 created2024-10-02 15:38:31
 updated2024-10-02 15:38:31
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id596215
 filewebroot/files/Media/File/ThSeoImageTwitter/66fd4cd736eb7.png
 size145728
 ext.png
 mimeimage/png
 width375
 height210
 4(array)
 id815067
 hashaa91fe86bca15b7685567420ce27d0f3
 created2024-10-02 15:38:27
 updated2024-10-02 15:38:27
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id596215
 filewebroot/files/Media/File/ThTourTeaserImage/66fd4cd3cf3ea.jpg
 size63727
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 5(array)
 id815068
 hashe9aef8eccbaef498917eb700212f0927
 created2024-10-02 15:38:28
 updated2024-10-02 15:38:28
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id596215
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/66fd4cd3e8956.jpg
 size57767
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 6(array)
 id815069
 hashe82ec895771eb0eed14bab3d519f3e95
 created2024-10-02 15:38:28
 updated2024-10-02 15:38:28
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thtourteaserimagefullscreen.jpg
 thumbnailth-tour-teaser-image-fullscreen
 parent_id596215
 filewebroot/files/Media/File/ThTourTeaserImageFullscreen/66fd4cd40b924.jpg
 size274835
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 7(array)
 id815070
 hashc35cdcfaa450a5506f905f661d55ea85
 created2024-10-02 15:38:28
 updated2024-10-02 15:38:28
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id596215
 filewebroot/files/Media/File/ThTourHeaderImage/66fd4cd43cccd.jpg
 size80658
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 8(array)
 id596216
 hashb0fb3aa629b9d17d2bba38aed9768779
 created2021-11-22 13:28:23
 updated2021-11-22 13:28:23
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id596215
 filewebroot/files/Media/File/ThMediaFileIndex/619b8ce7b54db.jpg
 size14354
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 9(array)
 id596217
 hashb1febbe0c90771c33790e5fbcdfb2404
 created2021-11-22 13:28:24
 updated2021-11-22 13:28:24
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id596215
 filewebroot/files/Media/File/CkeditorXs/619b8ce7e0d86.jpg
 size4459
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 10(array)
 id596218
 hash39082dcb475c641777ee005546912f51
 created2021-11-22 13:28:24
 updated2021-11-22 13:28:24
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id596215
 filewebroot/files/Media/File/CkeditorSm/619b8ce823c36.jpg
 size14354
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 11(array)
 id596219
 hash0ae304f6f9647467362e926aa5c601b7
 created2021-11-22 13:28:24
 updated2021-11-22 13:28:24
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id596215
 filewebroot/files/Media/File/CkeditorMd/619b8ce847ee5.jpg
 size22835
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 12(array)
 id596220
 hashd4778716dda3c8f21e2be6bb7ab00c1f
 created2021-11-22 13:28:24
 updated2021-11-22 13:28:24
 modelMedia
 fieldfile
 foreign_key11125
 aliasneuschnee-berge-hohe-tauern-auf-der-dreilaender-wanderung-panorama-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id596215
 filewebroot/files/Media/File/CkeditorLg/619b8ce86e7ce.jpg
 size49050
 ext.jpg
 mimeimage/jpeg
 width300
 height168
- months(array)
 1Januar
 2Februar
 4March
 8April
 16Mai
 32Juni
 64Juli
 128August
 256September
 512Oktober
 1024November
 2048Dezember
- accomodationTourMainTypes(array)
 3(array)
 id3
 hash2fb0a759edb324800d3f4c36dad9501b
 created2019-01-10 15:41:38
 updated2024-01-23 08:15:39
 titleBergwandern
 position3
 packing_list_text_start<h3>Ausrüstungsliste für Bergwanderungen</h3> <ul> <li>Detailliert mit nützlichen Ausrüstungstipps (?)</li> <li>Kurz vor Tourbeginn Wetter- & Ausrüstungscheck - ggf. Ergänzung</li> <li>Achte auf Deine Schuhwahl! - <a href="https://akademie.alpinewelten.com/bergwandern/bergschuhe">Hier findest Du viele Infos zum Thema. </a></li> </ul>
 packing_list_text_end<h3>Tipps zur Ausrüstung beim Wandern</h3> <ul> <li style="text-align:justify">Packe Deinen Rucksack bereits zu Hause zur Probe. </li> <li style="text-align:justify">Jedes Gramm zählt!</li> <li style="text-align:justify">Es könnte regnen! - Ein großer Packsack (Alternativ Müllsack) & ein Regenschirm halten Dich trocken!!! Regenponchos werden auf Tour nicht toleriert (Stolper/Sturzgefahr)</li> <li style="text-align:justify">Wanderstöcke sind NICHT zwingend notwendig - Machen aber Sinn</li> <li style="text-align:justify">Antworten auf häufige Fragen zur Ausrüstung & Schuhen findest Du in den FAQ.</li> <li style="text-align:justify">Extra für Dich: Bereite Dich vor mit Tipps und Videos in der <a href="https://akademie.alpinewelten.com/bergwandern">Alpine Welten Akademie</a>. </li> </ul> <figure class="img-center" 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="13679"> </div> <figcaption class="hidden"></figcaption> </figure> *Bedingungen
 IconUpload(array)
 0(array)
 id384634
 hash11fc38d30fdd83efa61db88da9e4c400
 created2020-08-18 08:59:02
 updated2020-08-18 08:59:04
 modelTourMainType
 fieldicon
 foreign_key3
 aliasic-bergwandern.svg
 filewebroot/files/TourMainType/Icon/5f3b7c3855aeb.svg
 size1308
 ext.svg
 mimeimage/svg+xml
- faq(empty)
- minimalLayoutForLayout(false)
- $request->data(empty)
- $this->validationErrors(array)
 Route(empty)
 MountPoint(empty)
 Redirect(empty)
 Language(empty)
 Setting(empty)
 ValueUpload(empty)
 Menu(empty)
 MemberGroup(empty)
 Member(empty)
 Parent(empty)
 HeaderImagesMedia(empty)
 MediaEntity(empty)
 Seo(empty)
 ImageMedia(empty)
 Teaser(empty)
 Advantage(empty)
 IconUpload(empty)
 Accomodation(empty)
 TeaserMedia(empty)
 GalleryMedia(empty)
 VideoThumbnailMedia(empty)
 TravelReport(empty)
 Firm(empty)
 Tours(empty)
 Types(empty)
 Tour(empty)
 Services(empty)
 TourDate(empty)
 TravelOptions(empty)
 Booking(empty)
 TourServices(empty)
 FellowTraveller(empty)
 Invoice(empty)
 EmailTemplate(empty)
 TagsTag(empty)
 TagEntity(empty)
 MountainGuides(empty)
 TeaserImageMedia(empty)
 OutputChannel(empty)
 LogoMedia(empty)
 LogoHorizontalMedia(empty)
 MountainGuideQualification(empty)
 MountainGuide(empty)
 MountainGuideQualifications(empty)
 IconMedia(empty)
 MountainGuideDailyRate(empty)
 Region(empty)
 Accomodations(empty)
 AccomodationAlternatives(empty)
 Countries(empty)
 News(empty)
 FileMedia(empty)
 Country(empty)
 TourMainType(empty)
 RegionAreas(empty)
 PackingListItems(empty)
 PackingList(empty)
 Transfers(empty)
 Co2Items(empty)
 SimilarTours(empty)
 AccomodationImagesMedia(empty)
 EmailHeadMedia(empty)
 EventIconMedia(empty)
 PartnerLogoMedia(empty)
 FaqItem(empty)
 FaqSet(empty)
 FaqItems(empty)
 Content(empty)
 TourType(empty)
 ArticleContentMedia(empty)
 MosaicGalleryMedia(empty)
 BackgroundImageMedia(empty)
 PlaceholderImageMedia(empty)
 User(empty)
 Aro(empty)
 Aco(empty)
 Users(empty)
 Tag(empty)
 Tags(empty)
 ExclusionTags(empty)
 TourFaqItemsForCustomer(empty)
 TourFaqItemsForMountainGuide(empty)
 Job(empty)
 TourMainTypes(empty)
 Microsite(empty)
 Microsites(empty)
 DisturberMedia(empty)
 FileUpload(empty)
 FlagUpload(empty)
 RegionArea(empty)
 AccomodationsTravelReport(empty)
 TourTexts(empty)
 TourTypesTour(empty)
 Highlight(empty)
 HeaderVideoUpload(empty)
 AdvantagesMenu(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8LeafletJs
 9Leaflet
 10GMap
 11Embed
 12Layout
 13Recaptcha
 14ThirdPartyCookies
 15RequestContent
 16BitMask
 17Number
 18SimpleGraph
 19DebugTimer
 20Toolbar
 21LeafletEngine
 22Js
 23HtmlToolbar
====

Environment

App Constants

Constant	Value
MH
MH_IP
BACKEND_APP_DIR	contrance
UPLOADS_APP	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/
UPLOAD_TMP_DIR	tmp/uploads/

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/alpinewelten.com/httpdocs/
APP_DIR	httpdocs
APPLIBS	/var/www/vhosts/alpinewelten.com/httpdocs/Lib/
CACHE	/var/www/vhosts/alpinewelten.com/httpdocs/tmp/cache/
CAKE	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib
CORE_PATH	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/
CAKE_VERSION	2.9.0
CSS	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.alpinewelten.com
IMAGES	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/alpinewelten.com/httpdocs/tmp/logs/
ROOT	/var/www/vhosts/alpinewelten.com
TESTS	/var/www/vhosts/alpinewelten.com/httpdocs/Test/
TMP	/var/www/vhosts/alpinewelten.com/httpdocs/tmp/
VENDORS	/var/www/vhosts/alpinewelten.com/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.2.34
User	u3939483948
Home	/var/www/vhosts/alpinewelten.com
Script Name	/webroot/index.php
Request Uri	/krimmler-tauernhaus
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/krimmler-tauernhaus
Remote Port	37048
Script Filename	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/alpinewelten.com/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/alpinewelten.com/httpdocs
Remote Addr	3.138.102.181
Server Port	443
Server Addr	85.236.49.170
Server Name	www.alpinewelten.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Cookie	frontend=l844g35nvla0p89leaa19lv5po
Http Referer	https://alpinewelten.com/krimmler-tauernhaus
Http Accept Encoding	gzip, br, zstd, deflate
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	3.138.102.181
Http Host	www.alpinewelten.com
Proxy-nokeepalive	1
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Http Authorization
Script Uri	https://www.alpinewelten.com/krimmler-tauernhaus
Script Url	/krimmler-tauernhaus
Unique Id	ZyLMN9yFXmqTYOuAkp4IdwAAApA
Redirect Status	200
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Http Authorization
Redirect Script Uri	https://www.alpinewelten.com/krimmler-tauernhaus
Redirect Script Url	/krimmler-tauernhaus
Redirect Unique Id	ZyLMN9yFXmqTYOuAkp4IdwAAApA
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Passenger Download Native Support Binary	0
Redirect Redirect Passenger Compile Native Support Binary	0
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Script Uri	https://www.alpinewelten.com/krimmler-tauernhaus
Redirect Redirect Script Url	/krimmler-tauernhaus
Redirect Redirect Unique Id	ZyLMN9yFXmqTYOuAkp4IdwAAApA
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1730333751.7926
Request Time	1730333751

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.2/share/pear
- 2-> /var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/AclBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/AuthComponent.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SecurityComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/language_country.php
  3APP/Config/routes.php
  4APP/Config/database.php
  5APP/contrance/Config/database.php
  6APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  5APP/contrance/Vendor/Cake/lib/Cake/Model/Aro.php
  6APP/contrance/Vendor/Cake/lib/Cake/Model/AclNode.php
  7APP/contrance/Vendor/Cake/lib/Cake/Model/Aco.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  10APP/Lib/Util/LanguageUtil.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeNumber.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  6APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  7APP/contrance/Vendor/Cake/lib/Cake/Utility/Security.php
  8APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeTime.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Accomodations(array)
  Config(array)
  0Accomodations/Config/bootstrap.php
  Model(array)
  0Accomodations/Model/Accomodation.php
  1Accomodations/Model/AccomodationsAppModel.php
  Advantages(array)
  Model(array)
  0Advantages/Model/Advantage.php
  1Advantages/Model/AdvantagesAppModel.php
  ApiLogging(array)
  Config(array)
  0ApiLogging/Config/routes.php
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/HabtmBehavior.php
  11BaseData/Model/Behavior/BarcodeNumberBehavior.php
  12BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Bookings(array)
  Config(array)
  0Bookings/Config/bootstrap.php
  Model(array)
  0Bookings/Model/Booking.php
  1Bookings/Model/BookingsAppModel.php
  Contents(array)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  Countries(array)
  Model(array)
  0Countries/Model/Country.php
  1Countries/Model/CountriesAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Emails(array)
  Model(array)
  0Emails/Model/EmailTemplate.php
  1Emails/Model/EmailsAppModel.php
  Faqs(array)
  Model(array)
  0Faqs/Model/FaqItem.php
  1Faqs/Model/FaqsAppModel.php
  2Faqs/Model/FaqSet.php
  FellowTravellers(array)
  Model(array)
  0FellowTravellers/Model/FellowTraveller.php
  1FellowTravellers/Model/FellowTravellersAppModel.php
  Firms(array)
  Model(array)
  0Firms/Model/Firm.php
  1Firms/Model/FirmsAppModel.php
  FrontendAccomodations(array)
  Controller(array)
  0FrontendAccomodations/Controller/FrontendAccomodationsController.php
  1FrontendAccomodations/Controller/FrontendAccomodationsAppController.php
  FrontendApi(array)
  Config(array)
  0FrontendApi/Config/routes.php
  FrontendContents(array)
  Config(array)
  0FrontendContents/Config/bootstrap.php
  FrontendMembers(array)
  Config(array)
  0FrontendMembers/Config/routes.php
  FrontendTours(array)
  Config(array)
  0FrontendTours/Config/bootstrap.php
  1FrontendTours/Config/routes.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Component(array)
  0FrontendUtils/Controller/Component/RecaptchaComponent.php
  Invoices(array)
  Model(array)
  0Invoices/Model/Invoice.php
  1Invoices/Model/InvoicesAppModel.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Members(array)
  Model(array)
  0Members/Model/MemberGroup.php
  1Members/Model/MembersAppModel.php
  2Members/Model/Member.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  Microsites(array)
  Model(array)
  0Microsites/Model/Microsite.php
  1Microsites/Model/MicrositesAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  MountainGuides(array)
  Model(array)
  0MountainGuides/Model/MountainGuide.php
  1MountainGuides/Model/MountainGuidesAppModel.php
  2MountainGuides/Model/MountainGuideQualification.php
  3MountainGuides/Model/MountainGuideDailyRate.php
  News(array)
  Model(array)
  0News/Model/News.php
  1News/Model/NewsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  1Outdooractive/Model/Behavior/CMSInterfaceBehavior.php
  Model(array)
  0Outdooractive/Model/Job.php
  1Outdooractive/Model/JobsAppModel.php
  PackingLists(array)
  Model(array)
  0PackingLists/Model/PackingListItem.php
  1PackingLists/Model/PackingListsAppModel.php
  2PackingLists/Model/PackingList.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Regions(array)
  Model(array)
  0Regions/Model/Region.php
  1Regions/Model/RegionsAppModel.php
  2Regions/Model/RegionArea.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Model(array)
  0Tags/Model/Tag.php
  1Tags/Model/TagsAppModel.php
  Tasks(array)
  Behavior(array)
  0Tasks/Model/Behavior/TaskBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  TourDates(array)
  Model(array)
  0TourDates/Model/TourDate.php
  1TourDates/Model/TourDatesAppModel.php
  Tours(array)
  Model(array)
  0Tours/Model/Tour.php
  1Tours/Model/ToursAppModel.php
  2Tours/Model/TourType.php
  3Tours/Model/TourService.php
  4Tours/Model/TourTravelOption.php
  5Tours/Model/TourMainType.php
  6Tours/Model/TourCo2Item.php
  7Tours/Model/TourTexts.php
  Transfers(array)
  Model(array)
  0Transfers/Model/Transfer.php
  1Transfers/Model/TransfersAppModel.php
  TravelReports(array)
  Model(array)
  0TravelReports/Model/TravelReport.php
  1TravelReports/Model/TravelReportsAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
  Users(array)
  Model(array)
  0Users/Model/User.php
  1Users/Model/UsersAppModel.php
  Behavior(array)
  0Users/Model/Behavior/PasswordBehavior.php
  1Users/Model/Behavior/ActivityBehavior.php
====

Krimmler Tauernhaus Hohe Tauern, 1.622 m Gasthof im Zillertal

Öffnungszeiten

Ausstattung

Währung & Bezahlung

Standort der Unterkunft

Reisen mit der Unterkunft Krimmler Tauernhaus Diese Unterkunft besuchen wir auf folgenden Reisen

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 21 ms Total Queries: 142 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Krimmler Tauernhaus
Hohe Tauern, 1.622 m
Gasthof im Zillertal

Total Time: 21 ms
Total Queries: 142 queries