Nürnberger Hütte
Stubaier Alpen, 2.278 m
Hütte am Stubaier Hauptkamm

Die Nürnberger Hütte liegt in den Stubaier Alpen am Fuße des Wilden Freigers (3.418 m) und ist Ausgangspunkt für hochalpine Touren. Es gibt eine Boulderwand, einen Klettergarten sowie einen Flying Fox in der nahen Hüttenumgebung.

Alle 6 Fotos ansehen

Öffnungszeiten

Jan

Feb

Mar

Apr

Mai

Jun

Jul

Aug

Sep

Okt

Nov

Dez

Ausstattung

Waschmöglichkeit

Duschmöglichkeit

Handyempfang

Mehrbettzimmer

Matratzenlager

Doppelzimmer

Trockenraum

Währung & Bezahlung

Barzahlung

EUR

Währung: Euro

Standort der Unterkunft

Reisen mit der Unterkunft Nürnberger Hütte Diese Unterkunft besuchen wir auf folgenden Reisen

Alpenüberquerung von Innsbruck nach Meran

Die Alpenüberquerung auf historischen Wegen unterwegs von Innsbruck nach Meran.

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
  time1730348147
  countdown10
- _Token(array)
  keyc2a6497baf1a796ff058d361c964b933001bbeee4c441d42d3f9289a027bb6ba1324f5b3612f8cb94b407c283bd325dc0eb08eec300927d80807e5edb2f0209d
  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
====
Request
+
Request

Cake Params
- pluginFrontendAccomodations
- controllerFrontendAccomodations
- actionaccomodation
- named(empty)
- pass(array)
  0720
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Accomodation720
- route(array)
  id6194
  hashe4b5452da6cf2d87397a0a5e889ba713
  created2022-11-07 16:00:13
  updated2024-07-18 16:15:27
  modelAccomodation
  foreign_key720
  base/
  aliasnuernberger-huette
  controllerFrontendAccomodations.FrontendAccomodations
  actionaccomodation
  parent_id(null)
  lft7413
  rght7414
  route/nuernberger-huette
- isAjax(false)
- _Token(array)
  keyc2a6497baf1a796ff058d361c964b933001bbeee4c441d42d3f9289a027bb6ba1324f5b3612f8cb94b407c283bd325dc0eb08eec300927d80807e5edb2f0209d
  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`))) = '/nuernberger-huette' LIMIT 1	1	1	4	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 7413 AND `Route`.`rght` >= 7414 ORDER BY `Route`.`lft` asc	1	1	4	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	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `alpinewelten`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 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` = 720 LIMIT 1	1	1	4	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` = 720 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` = (12086) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	1	maybe slow
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` = 720 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	6	6	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 (12086, 12089, 12084, 12085, 12087, 12088) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	46	46	1
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` = 720 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` = 720 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` = '720' 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	2	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` = 452 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	2	2	0
SELECT `TourMainType`.`id`, `TourMainType`.`hash`, `TourMainType`.`created`, `TourMainType`.`updated`, `TourMainType`.`title`, `TourMainType`.`position`, `TourMainType`.`packing_list_text_start`, `TourMainType`.`packing_list_text_end` FROM `alpinewelten`.`tour_main_types` AS `TourMainType` WHERE `TourMainType`.`id` = 3	1	1	0
SELECT `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` = 452 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` = (1914) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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` = 720 LIMIT 1	1	1	3	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` = 6033 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
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 22.13 MB

Message	Memory use
Component initialization	2.25 MB
Controller action start	3.32 MB
Controller render start	7.53 MB
View render complete	11.45 MB

Timers

Total Request Time: 1909 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	1582.20
Event: Controller.initialize	11.07
Event: Controller.startup	0.61
Controller action	58.92
Event: Controller.beforeRender	101.94
» Processing toolbar data	53.53
Rendering View	49.15
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendAccomodations/View/FrontendAccomodations/accomodation.php	15.79
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php	0.98
» » Rendering APP/View/Elements/icon.php	1.27
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_mosaic.php	0.49
» » Rendering APP/View/Elements/icon.php #2	0.97
» » Rendering APP/View/Elements/icon.php #3	0.94
» » Rendering APP/View/Elements/icon.php #4	0.90
» » Rendering APP/View/Elements/icon.php #5	0.87
» » Rendering APP/View/Elements/icon.php #6	0.87
» » Rendering APP/View/Elements/icon.php #7	0.86
» » Rendering APP/View/Elements/icon.php #8	0.91
» » Rendering APP/View/Elements/icon.php #9	0.88
» » Rendering APP/Plugin/FrontendTours/View/Elements/teaser_slider.php	3.05
» » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php	0.62
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.16
» » » Rendering APP/View/Elements/icon.php #10	0.91
» » » Rendering APP/View/Elements/icon.php #11	0.22
» » » Rendering APP/View/Elements/icon.php #12	0.86
» Event: View.afterRender	0.07
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/1.php	31.72
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.51
» » Rendering APP/View/Elements/header/header.php	16.79
» » » Rendering APP/View/Elements/header/header_navbar.php	16.63
» » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.08
» » » » Rendering APP/View/Elements/navigation_secondary.php	3.29
» » » » » Rendering APP/View/Elements/icon.php #13	0.90
» » » » » Rendering APP/View/Elements/icon.php #14	0.22
» » » » » Rendering APP/View/Elements/icon.php #15	0.20
» » » » » Rendering APP/View/Elements/icon.php #16	0.89
» » » » Rendering APP/View/Elements/navigation.php	12.16
» » » » » Rendering APP/View/Elements/icon.php #17	0.21
» » » » » Rendering APP/View/Elements/icon.php #18	0.20
» » » » » Rendering APP/View/Elements/icon.php #19	0.19
» » » » » Rendering APP/View/Elements/icon.php #20	0.19
» » » » » Rendering APP/View/Elements/icon.php #21	0.19
» » » » » Rendering APP/View/Elements/icon.php #22	0.19
» » » » » Rendering APP/View/Elements/icon.php #23	0.19
» » » » » Rendering APP/View/Elements/icon.php #24	0.19
» » » » » Rendering APP/View/Elements/icon.php #25	0.19
» » » » » Rendering APP/View/Elements/icon.php #26	0.18
» » » » » Rendering APP/View/Elements/icon.php #27	0.19
» » » » » Rendering APP/View/Elements/icon.php #28	0.19
» » » » » Rendering APP/View/Elements/icon.php #29	0.19
» » » » » Rendering APP/View/Elements/icon.php #30	0.19
» » » » » Rendering APP/View/Elements/icon.php #31	0.19
» » » » » Rendering APP/View/Elements/icon.php #32	0.19
» » » » » Rendering APP/View/Elements/icon.php #33	0.19
» » » » » Rendering APP/View/Elements/icon.php #34	0.19
» » » » » Rendering APP/View/Elements/icon.php #35	0.20
» » » » » Rendering APP/View/Elements/icon.php #36	0.20
» » » » » Rendering APP/View/Elements/icon.php #37	0.19
» » » » » Rendering APP/View/Elements/icon.php #38	0.19
» » » » » Rendering APP/View/Elements/icon.php #39	0.19
» » » » » Rendering APP/View/Elements/icon.php #40	0.19
» » » » » Rendering APP/View/Elements/icon.php #41	0.20
» » » » » Rendering APP/View/Elements/icon.php #42	0.19
» » » » » Rendering APP/View/Elements/icon.php #43	0.20
» » » » » Rendering APP/View/Elements/icon.php #44	0.19
» » » » » Rendering APP/View/Elements/icon.php #45	0.19
» » » » » Rendering APP/View/Elements/icon.php #46	0.19
» » » » » Rendering APP/View/Elements/icon.php #47	0.26
» » » » » Rendering APP/View/Elements/icon.php #48	0.20
» » » » » Rendering APP/View/Elements/icon.php #49	0.20
» » » » » Rendering APP/View/Elements/icon.php #50	0.19
» » » » » Rendering APP/View/Elements/icon.php #51	0.19
» » » » » Rendering APP/View/Elements/icon.php #52	0.20
» » » » » Rendering APP/View/Elements/icon.php #53	0.19
» » » » » Rendering APP/View/Elements/icon.php #54	0.20
» » » » » Rendering APP/View/Elements/icon.php #55	0.20
» » » » » Rendering APP/View/Elements/icon.php #56	0.20
» » » » » Rendering APP/View/Elements/icon.php #57	0.19
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php #2	0.50
» » Rendering APP/View/Elements/footer/footer.php	6.42
» » » Rendering APP/View/Elements/icon.php #58	0.96
» » » Rendering APP/View/Elements/icon.php #59	0.92
» » » 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.07
» » » 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.10
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.09
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.07
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.07
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.06
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.06
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.07
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.07
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.06
» » » 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.13
» » » Rendering APP/View/Elements/icon.php #60	0.93
» » » Rendering APP/View/Elements/icon.php #61	0.94
» » » Rendering APP/View/Elements/icon.php #62	0.89
» » » Rendering APP/View/Elements/icon.php #63	0.89
» » » Rendering APP/View/Elements/icon.php #64	0.86
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- accomodation(array)
 Accomodation(array)
 id720
 hash7943c20a8555ceb3df0073d2477be3e0
 created2022-11-07 16:00:13
 updated2024-07-18 16:15:27
 number900720
 nameNürnberger Hütte
 typecabin
 ownersFamilie Martina und Leonhard Siller
 phone_cabin+436641657461
 phone_valley+436644032188
 mobile+436641657461
 fax
 emailinfo@nuernbergerhuette.at
 urlhttps://dav-nuernberg.de/services/unsere-huetten/nuernberger-huette/
 zip6167
 cityNeustift im Stubai
 streetSchulweg 28
 country
 region_area_id28
 remarkinfo@nuernbergerhuette.at
 geopoint_lat46.993725
 geopoint_long11.217930
 cancellation_period5
 tighter_cancellation_period(false)
 statusactive
 sublineHütte am Stubaier Hauptkamm
 height2.278
 video_url
 opening_hours480
 premisesDie Nürnberger Hütte liegt in den Stubaier Alpen am Fuße des Wilden Freigers (3.418 m) und ist Ausgangspunkt für hochalpine Touren. Es gibt eine Boulderwand, einen Klettergarten sowie einen Flying Fox in der nahen Hüttenumgebung.
 equipment15879
 currency1
 detail_description
 days_before_to_send_participant_list(null)
 country_id248
 url_booking_systemhttps://www.alpsonline.org/reservation/calendar?hut_id=124&lang=de_DE
 importancenone
 participant_list_necessary(false)
 reservation_through_agency(false)
 reduction_not_necessary(false)
 geopoint46.993725,11.217930
 RegionArea(array)
 id28
 hash79be4893ff719f1da1454b3e4d6b042e
 created2015-12-01 11:07:21
 updated2015-12-01 11:25:48
 titleStubaier Alpen
 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)
 id6194
 hashe4b5452da6cf2d87397a0a5e889ba713
 created2022-11-07 16:00:13
 updated2024-07-18 16:15:27
 modelAccomodation
 foreign_key720
 base/
 aliasnuernberger-huette
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft7413
 rght7414
 route/nuernberger-huette
 Seo(array)
 id6033
 hash9adcdb6a85d0d4375c51adcb3cda32db
 created2022-11-07 16:00:13
 updated2023-05-17 12:03:27
 modelAccomodation
 foreign_key720
 titleNürnberger Hütte | Stubaier Alpen
 descriptionDie Nürnberger Hütte liegt in den Stubaier Alpen am Fuße des Wilden Freigers (3.418 m) und ist Ausgangspunkt für Hochalpine Touren. Es gibt eine Boulderwand einen Klettergarten sowie einen Flying Fox in der Hüttenumgebung.
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 sitemap_priority0.5
 TeaserMedia(array)
 0(array)
 id12086
 hash5a566033d5640bd54ac2a200c198623a
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 titleNuernberger Huette im Stubaital
 cross_reference_count3
 MediaEntity(array)
 id516638
 pos1
 media_id12086
 modelAccomodation
 fieldteaser
 foreign_key720
 FileUpload(array)
 0(array)
 id663314
 hash234e56d2ecc303f4a71c8ffe8f790bb0
 created2022-12-02 13:24:08
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389ee6a56490.jpg
 size400399
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663315
 hashba6b48ad2f11539448ed655bc54f7e22
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663314
 filewebroot/files/Media/File/ThMediaFileIndex/6389ee6a5787a.jpg
 size15020
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663316
 hash3f6cba4d2c614aa1e22e2fd277ed0f48
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663314
 filewebroot/files/Media/File/CkeditorXs/6389ee6a80b27.jpg
 size4640
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663317
 hash60e2c24ad1d13ac0d403a40498e9643f
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663314
 filewebroot/files/Media/File/CkeditorSm/6389ee6ab6e93.jpg
 size15020
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663318
 hash7e02a9017f987e06f049503d4924e229
 created2022-12-02 13:24:11
 updated2022-12-02 13:24:11
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663314
 filewebroot/files/Media/File/CkeditorMd/6389ee6ad95d2.jpg
 size24000
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663319
 hash2cfae6f7f18f417b1d59b484f4364726
 created2022-12-02 13:24:11
 updated2022-12-02 13:24:11
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663314
 filewebroot/files/Media/File/CkeditorLg/6389ee6b03307.jpg
 size52247
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695235
 hash71d41e1fba79b045de6e8872fce3791b
 created2023-05-17 12:03:26
 updated2023-05-17 12:03:26
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id663314
 filewebroot/files/Media/File/ThAccomodationTeaserImage/6464a66e5119c.jpg
 size69004
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id695236
 hash8512d695d73278fae27bef342d14fe7c
 created2023-05-17 12:03:26
 updated2023-05-17 12:03:26
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663314
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66e83f33.jpg
 size166144
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 8(array)
 id695242
 hash02edfe26ef94208d0d7d0252a49d6689
 created2023-05-17 12:03:27
 updated2023-05-17 12:03:27
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id663314
 filewebroot/files/Media/File/ThSeoImageFacebook/6464a66f84426.png
 size534916
 ext.png
 mimeimage/png
 width720
 height405
 9(array)
 id695243
 hash88b8dbbcc33ab070c35ed582235caf69
 created2023-05-17 12:03:28
 updated2023-05-17 12:03:28
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id663314
 filewebroot/files/Media/File/ThSeoImageGoogle/6464a66fc202c.png
 size534916
 ext.png
 mimeimage/png
 width720
 height405
 10(array)
 id695244
 hash2baa9dec4bc1c91ffdec854e32ba3bf0
 created2023-05-17 12:03:28
 updated2023-05-17 12:03:28
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id663314
 filewebroot/files/Media/File/ThSeoImageTwitter/6464a6700a5fd.png
 size157001
 ext.png
 mimeimage/png
 width375
 height210
 GalleryMedia(array)
 0(array)
 id12086
 hash5a566033d5640bd54ac2a200c198623a
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 titleNuernberger Huette im Stubaital
 cross_reference_count3
 MediaEntity(array)
 id516639
 pos1
 media_id12086
 modelAccomodation
 fieldgallery
 foreign_key720
 FileUpload(array)
 0(array)
 id663314
 hash234e56d2ecc303f4a71c8ffe8f790bb0
 created2022-12-02 13:24:08
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389ee6a56490.jpg
 size400399
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663315
 hashba6b48ad2f11539448ed655bc54f7e22
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663314
 filewebroot/files/Media/File/ThMediaFileIndex/6389ee6a5787a.jpg
 size15020
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663316
 hash3f6cba4d2c614aa1e22e2fd277ed0f48
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663314
 filewebroot/files/Media/File/CkeditorXs/6389ee6a80b27.jpg
 size4640
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663317
 hash60e2c24ad1d13ac0d403a40498e9643f
 created2022-12-02 13:24:10
 updated2022-12-02 13:24:10
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663314
 filewebroot/files/Media/File/CkeditorSm/6389ee6ab6e93.jpg
 size15020
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663318
 hash7e02a9017f987e06f049503d4924e229
 created2022-12-02 13:24:11
 updated2022-12-02 13:24:11
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663314
 filewebroot/files/Media/File/CkeditorMd/6389ee6ad95d2.jpg
 size24000
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663319
 hash2cfae6f7f18f417b1d59b484f4364726
 created2022-12-02 13:24:11
 updated2022-12-02 13:24:11
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663314
 filewebroot/files/Media/File/CkeditorLg/6389ee6b03307.jpg
 size52247
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695235
 hash71d41e1fba79b045de6e8872fce3791b
 created2023-05-17 12:03:26
 updated2023-05-17 12:03:26
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id663314
 filewebroot/files/Media/File/ThAccomodationTeaserImage/6464a66e5119c.jpg
 size69004
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id695236
 hash8512d695d73278fae27bef342d14fe7c
 created2023-05-17 12:03:26
 updated2023-05-17 12:03:26
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663314
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66e83f33.jpg
 size166144
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 8(array)
 id695242
 hash02edfe26ef94208d0d7d0252a49d6689
 created2023-05-17 12:03:27
 updated2023-05-17 12:03:27
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id663314
 filewebroot/files/Media/File/ThSeoImageFacebook/6464a66f84426.png
 size534916
 ext.png
 mimeimage/png
 width720
 height405
 9(array)
 id695243
 hash88b8dbbcc33ab070c35ed582235caf69
 created2023-05-17 12:03:28
 updated2023-05-17 12:03:28
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id663314
 filewebroot/files/Media/File/ThSeoImageGoogle/6464a66fc202c.png
 size534916
 ext.png
 mimeimage/png
 width720
 height405
 10(array)
 id695244
 hash2baa9dec4bc1c91ffdec854e32ba3bf0
 created2023-05-17 12:03:28
 updated2023-05-17 12:03:28
 modelMedia
 fieldfile
 foreign_key12086
 aliasnuernberger-huette-im-stubaital-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id663314
 filewebroot/files/Media/File/ThSeoImageTwitter/6464a6700a5fd.png
 size157001
 ext.png
 mimeimage/png
 width375
 height210
 1(array)
 id12089
 hash68799073ffd7b49dc355a2db32feec80
 created2022-12-02 13:26:53
 updated2022-12-02 13:26:53
 titleNuernberger Huette Stubai Sonnenterasse
 cross_reference_count1
 MediaEntity(array)
 id516640
 pos2
 media_id12089
 modelAccomodation
 fieldgallery
 foreign_key720
 FileUpload(array)
 0(array)
 id663332
 hashe52a9930cfbd5b1eea2bfbc695821b47
 created2022-12-02 13:26:52
 updated2022-12-02 13:26:53
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389ef0df05a6.jpg
 size335221
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663333
 hash7dc58563fa8baf3d511091f02872d123
 created2022-12-02 13:26:54
 updated2022-12-02 13:26:54
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663332
 filewebroot/files/Media/File/ThMediaFileIndex/6389ef0df1183.jpg
 size22990
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663334
 hashc456133ed3a12b4e66a27d074c076785
 created2022-12-02 13:26:54
 updated2022-12-02 13:26:54
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663332
 filewebroot/files/Media/File/CkeditorXs/6389ef0e28c1b.jpg
 size7479
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663335
 hash42f2fbebb16c8a0dfc3105ffacefa078
 created2022-12-02 13:26:54
 updated2022-12-02 13:26:54
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663332
 filewebroot/files/Media/File/CkeditorSm/6389ef0e5f4fb.jpg
 size22990
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663336
 hash68d3ed32fd65200e713447ecba499c24
 created2022-12-02 13:26:54
 updated2022-12-02 13:26:54
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663332
 filewebroot/files/Media/File/CkeditorMd/6389ef0e830ef.jpg
 size37440
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663337
 hash2728e476af81ac435d77c933d45fcacf
 created2022-12-02 13:26:54
 updated2022-12-02 13:26:54
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663332
 filewebroot/files/Media/File/CkeditorLg/6389ef0ea1629.jpg
 size77349
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695237
 hashf360f7ab2f3ac1f7e06eca67f897ab14
 created2023-05-17 12:03:26
 updated2023-05-17 12:03:26
 modelMedia
 fieldfile
 foreign_key12089
 aliasnuernberger-huette-stubai-sonnenterasse-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663332
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66eafbb7.jpg
 size159495
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id12084
 hashc60abf7863cbc88cbaeb3294c036fbde
 created2022-12-02 13:22:56
 updated2022-12-02 13:22:56
 titleNuernberger Huette bei Nacht
 cross_reference_count1
 MediaEntity(array)
 id516641
 pos3
 media_id12084
 modelAccomodation
 fieldgallery
 foreign_key720
 FileUpload(array)
 0(array)
 id663302
 hash87dc34d74cbc18cb59da48d74caf3ef8
 created2022-12-02 13:22:54
 updated2022-12-02 13:22:56
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389ee2018cf0.jpg
 size394549
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663303
 hashbaadf215ab8ade27ea4dd424110f1910
 created2022-12-02 13:22:56
 updated2022-12-02 13:22:56
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663302
 filewebroot/files/Media/File/ThMediaFileIndex/6389ee2019893.jpg
 size22127
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663304
 hashc2280a6094e1e73351525a979ea7ebf1
 created2022-12-02 13:22:56
 updated2022-12-02 13:22:56
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663302
 filewebroot/files/Media/File/CkeditorXs/6389ee2044c5c.jpg
 size7125
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663305
 hashe6b0382674030d8bd3f09639f198ff46
 created2022-12-02 13:22:56
 updated2022-12-02 13:22:56
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663302
 filewebroot/files/Media/File/CkeditorSm/6389ee207c963.jpg
 size22127
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663306
 hasha57e4f2a7c8992ed56455fbbb1aa8268
 created2022-12-02 13:22:56
 updated2022-12-02 13:22:56
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663302
 filewebroot/files/Media/File/CkeditorMd/6389ee20a12ef.jpg
 size35289
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663307
 hashb329fc3c76c41b109cc8610990750c1b
 created2022-12-02 13:22:56
 updated2022-12-02 13:22:56
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663302
 filewebroot/files/Media/File/CkeditorLg/6389ee20c018b.jpg
 size73353
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695238
 hash6fb1b7f054156be8114907aa303aed22
 created2023-05-17 12:03:27
 updated2023-05-17 12:03:27
 modelMedia
 fieldfile
 foreign_key12084
 aliasnuernberger-huette-bei-nacht-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663302
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66ed86e1.jpg
 size132817
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id12085
 hash373b73ad99f459236e64dd1d2bae6f59
 created2022-12-02 13:23:28
 updated2022-12-02 13:23:28
 titleNuernberger Huette Gastraum
 cross_reference_count1
 MediaEntity(array)
 id516642
 pos4
 media_id12085
 modelAccomodation
 fieldgallery
 foreign_key720
 FileUpload(array)
 0(array)
 id663308
 hash456c70467505992b6f4dc29fcfc1d08e
 created2022-12-02 13:23:23
 updated2022-12-02 13:23:28
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389ee4079740.jpg
 size315079
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663309
 hashb3db3f2a587980938f8b2ebde08e0dc9
 created2022-12-02 13:23:28
 updated2022-12-02 13:23:28
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663308
 filewebroot/files/Media/File/ThMediaFileIndex/6389ee407a496.jpg
 size23374
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663310
 hash3d40dda394e8a5d6b016b5a1d1d0a89d
 created2022-12-02 13:23:28
 updated2022-12-02 13:23:28
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663308
 filewebroot/files/Media/File/CkeditorXs/6389ee40a4efc.jpg
 size7680
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663311
 hashbcaf39b489a833aaf09470e6872bbdd6
 created2022-12-02 13:23:29
 updated2022-12-02 13:23:29
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663308
 filewebroot/files/Media/File/CkeditorSm/6389ee40dd2ad.jpg
 size23374
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663312
 hashca009a49544d9324dda6949b80d62056
 created2022-12-02 13:23:29
 updated2022-12-02 13:23:29
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663308
 filewebroot/files/Media/File/CkeditorMd/6389ee410e239.jpg
 size37504
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663313
 hash07b61ebd338b5a5d9482c9c38437e54c
 created2022-12-02 13:23:29
 updated2022-12-02 13:23:29
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663308
 filewebroot/files/Media/File/CkeditorLg/6389ee412c65d.jpg
 size77607
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695239
 hash325d6168c07297fe5c49592fc2199d8c
 created2023-05-17 12:03:27
 updated2023-05-17 12:03:27
 modelMedia
 fieldfile
 foreign_key12085
 aliasnuernberger-huette-gastraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663308
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66f0ca6f.jpg
 size151156
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 4(array)
 id12087
 hash52c2847b48cd5fa8e6dd1a4806e8d410
 created2022-12-02 13:24:51
 updated2022-12-02 13:24:51
 titleNuernberger Huette Stubai Sonnenterasse
 cross_reference_count1
 MediaEntity(array)
 id516643
 pos5
 media_id12087
 modelAccomodation
 fieldgallery
 foreign_key720
 FileUpload(array)
 0(array)
 id663320
 hash44b2cc7fc66dd7e39254223e819282ac
 created2022-12-02 13:24:49
 updated2022-12-02 13:24:51
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389ee9383b10.jpg
 size325974
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663321
 hashec1d2ad708e3d19b73f0b0a9761165e1
 created2022-12-02 13:24:51
 updated2022-12-02 13:24:51
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663320
 filewebroot/files/Media/File/ThMediaFileIndex/6389ee93854e3.jpg
 size13135
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663322
 hashbe0252c566e34e0ded337721c91d5c78
 created2022-12-02 13:24:51
 updated2022-12-02 13:24:51
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663320
 filewebroot/files/Media/File/CkeditorXs/6389ee93b0fc9.jpg
 size4084
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663323
 hashbe4957e0dac9d4ae3a6f49ba2c27e79b
 created2022-12-02 13:24:52
 updated2022-12-02 13:24:52
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663320
 filewebroot/files/Media/File/CkeditorSm/6389ee93e94e0.jpg
 size13135
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663324
 hashb63a8e2c9ff5990b4b59d3fe1878031c
 created2022-12-02 13:24:52
 updated2022-12-02 13:24:52
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663320
 filewebroot/files/Media/File/CkeditorMd/6389ee94192e9.jpg
 size20932
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663325
 hash89d6e65f0d4d8c3cee6d56118b882467
 created2022-12-02 13:24:52
 updated2022-12-02 13:24:52
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663320
 filewebroot/files/Media/File/CkeditorLg/6389ee9439257.jpg
 size45971
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695240
 hash922fddd5d2469f99ce46615eebedc2a0
 created2023-05-17 12:03:27
 updated2023-05-17 12:03:27
 modelMedia
 fieldfile
 foreign_key12087
 aliasnuernberger-huette-stubaital-alpenvereinshuette-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663320
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66f34bc6.jpg
 size136682
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 5(array)
 id12088
 hash8bd0bb93690d2e7fe995556bf070a444
 created2022-12-02 13:25:50
 updated2022-12-02 13:25:50
 titleNuernberger Huette Wandern im Stubaital
 cross_reference_count1
 MediaEntity(array)
 id516644
 pos6
 media_id12088
 modelAccomodation
 fieldgallery
 foreign_key720
 FileUpload(array)
 0(array)
 id663326
 hash3221ed12cad5dac2feb740c352c40bb9
 created2022-12-02 13:25:49
 updated2022-12-02 13:25:50
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/6389eecec76ec.jpg
 size373317
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id663327
 hash47b51c050e059013209ddc2b4a73f80b
 created2022-12-02 13:25:51
 updated2022-12-02 13:25:51
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id663326
 filewebroot/files/Media/File/ThMediaFileIndex/6389eecec882f.jpg
 size13631
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id663328
 hashcaffd9dfb37911f6b0bc68decf3be335
 created2022-12-02 13:25:51
 updated2022-12-02 13:25:51
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id663326
 filewebroot/files/Media/File/CkeditorXs/6389eecf01cc6.jpg
 size4238
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id663329
 hash6291a28c8fdaf318f9a0cb0de7cbb598
 created2022-12-02 13:25:51
 updated2022-12-02 13:25:51
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id663326
 filewebroot/files/Media/File/CkeditorSm/6389eecf39ec3.jpg
 size13631
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id663330
 hash70e456e8c0010d737762918ed83804de
 created2022-12-02 13:25:51
 updated2022-12-02 13:25:51
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id663326
 filewebroot/files/Media/File/CkeditorMd/6389eecf5f76f.jpg
 size21911
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id663331
 hash8d8de49e2c967b83b404a6170ad977b6
 created2022-12-02 13:25:51
 updated2022-12-02 13:25:51
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id663326
 filewebroot/files/Media/File/CkeditorLg/6389eecf7c9b3.jpg
 size48495
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id695241
 hashf391356d7658c7f7a10504bcd9441d8a
 created2023-05-17 12:03:27
 updated2023-05-17 12:03:27
 modelMedia
 fieldfile
 foreign_key12088
 aliasnuernberger-huette-wandern-im-stubaital-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id663326
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6464a66f59851.jpg
 size190672
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 TagsTag(empty)
 TravelReport(empty)
- accomodationTours(array)
 0(array)
 Tour(array)
 id452
 hashf054fa90d77fec83c2c0a17bdaf2fef2
 created2022-10-17 10:10:32
 updated2024-10-02 15:05:51
 tour_number422000000452
 titleAlpenüberquerung von Innsbruck nach Meran
 subtitleVon den südlichen Stubaier Alpen über die Texelgruppe nach Meran
 participants_min6
 participants_max10
 duration_days6
 duration_typetour_week
 tour_price1199.00
 down_payment20
 country_of_serviceeu
 saisonsummer
 travel_insurance_certificate(true)
 out_of_alpine_tour(false)
 rating_condition3
 rating_technique4
 rating_experience2
 rating_difficulty_categorymedium
 rating_seriousness2
 rating_overall_score2.8
 start_zip6020
 start_cityInnsbruck
 start_streetSüdtiroler Platz 7
 start_countryAT
 start_meeting_pointist am Eingang vom Hauptbahnhof in Innsbruck
 start_time10:00:00
 end_alternate_address(false)
 end_time13: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_long11.401829
 gmap_marker(true)
 gmap_typeoa_map
 gmap_lat47.264275
 callout_iconnone
 travel_information<h3>Bahnanreise:</h3> Die Anreise nach Innsbruck ist mit öffentlichen Verkehrsmitteln recht gut möglich. Vom Münchner Hauptbahnhof sind es mit dem Zug ca. 2 Stunden bis zum Hauptbahnhof in Innsbruck. <h3>Unterkunftsempfehlung:</h3> Wir können <a href="http://www.booking.com" target="_blank">www.booking.com</a> empfehlen, wo auch kostenlose Stornierungen bis kurz vor Reisedatum angeboten werden. Wenn in Innsbruck nichts verfügbar ist, dann gibt es viele kostengünstige Möglichkeiten etwas außerhalb.
 meeting_point_map_lat47.261246
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_map
 meeting_point_map_zoom10
 meeting_point_map_long11.400112
 previous_url
 packing_list_text_end
 packing_list_text_start
 days_before_start_for_cancellation24
 execution_feasibilitymedium
 days_before_start_for_last_notice24
 last_tour_date_number128
 tourstart_weekday64
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 callout_icon_multiple(null)
 microsite_id(null)
 is_archive(false)
 is_service(false)
 covid_note(false)
 importancenone
 internal_markpotential
 responsible_user_id25
 is_service_event(false)
 partner_title
 pay_later_hint(false)
 event_duration
 distance
 ascent
 descent
 destination_menu_id(null)
 gmap47.264275,11.401829
 meeting_point_map47.261246,11.400112
 end_zip6020
 end_cityInnsbruck
 end_streetSüdtiroler Platz 7
 end_countryAT
 price_excl_flight1199.00
 highlight0
 TourTexts(array)
 id443
 hash65eed3451135cdc9a315ce8af03b441c
 created2022-10-17 10:10:33
 updated2024-10-02 15:06:05
 tour_id452
 ws_text_short_descriptionDie Alpenüberquerung auf historischen Wegen unterwegs von Innsbruck nach Meran.
 ws_text_requirementsMittelschwere & schwere Bergwege ROT & SCHWARZ. Für diese geführte Alpenüberquerung von Innsbruck nach Meran solltest Du als erfahrener Bergwanderer über eine gute Kondition für Gehzeiten bis 7 Stunden verfügen. Die Aufstiege bei der Alpenüberquerung betragen maximal 1.000 Höhenmeter am Tag. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt beim Wandern ca. 300 Höhenmeter pro Stunde. Im Aufstieg zum Hochwart müssen kurze ausgesetzte Passagen überwunden werden, welche jedoch teilweise versichert sind. Insgesamt birgt die Alpenüberquerung von Innsbruck nach Meran jedoch nur wenige absturzgefährdete Stellen. <h3>Mäßige Alpine Erfahrung | Mittlere alpine Unternehmung</h3> <ul> <li>Mäßige Ernsthaftigkeit / Gefährdung</li> <li>Erfahrung Bergwandern</li> <li>Trittsicherheit und Schwindelfreiheit</li> <li>Teamfähigkeit für Alpenüberquerung in einer Gruppe</li> </ul> 1.000 Hm 1.550 Hm800m 7 hROT - SCHWARZFrühstück 
 ws_text_travel_program<h3>1. Tag: Willkommen in Innsbruck, der Landeshauptstadt von Tirol</h3> Treffpunkt für unsere Alpenüberquerung ist am Hauptbahnhof mitten in Innsbruck. Nach einem kurzen Ausrüstungscheck fahren wir gemeinsam mit dem Bus ins Stubaital. Zu Beginn wandern wir angenehm über einen breiten Wirtschaftszweg bis zur Bsuchalm. Hier können wir bereits den beeindruckenden „Urfall“ bestaunen, einen rauschenden Wasserfall. Wir gelangen schließlich in den Talschluss des Langentals, von wo sich der Weg hoch zur Nürnberger Hütte auf 2.278 m Höhe schlängelt. Hier haben wir unser erstes Tagesziel erreicht und wir lassen den Tag gemütlich auf der Hütte ausklingen. 900 Hm1.600 Hm800m 3 hsehr schwerHalbpension <h3>2. Tag: Überschreitung des Stubaier Hauptkamm </h3> Über Gletscherschliffplatten und Wasserläufe mit Wollgras gehen wir zu den Ferner Seen. Das Gelände wird hochalpin und führt vom ehemaligen Grübelferner über Geröll und Moränen zur Rotgratscharte (3.007 m). Wir stehen auf der Grenze zu Südtirol und der Weg über Blockgelände auf den Roten Grat (3.096 m) ist nicht weit. Ein grandioses Panorama erwartet uns auf den südlichen Teil der vergletscherten Stubaier Alpen. Der Abstieg erfolgt teilweise weglos und steil über den Gaiswandsee zur Teplitzer Hütte (2.586 m). Auf der Terrasse genießen wir den Blick in das Ridnaun Tal. 750 Hm450 Hm800m4 hsehr schwerHalbpension <h3>3. Tag: Durch das historische Bergbaugebiet</h3> Nach dem Frühstück steigen wir zunächst an der Grohmannhütte vorbei in den Sandboden ab. Durch ein Hochtal, dass eine karge Steinwüste ist, anfänglich aber durch den Bewuchs des blühenden Wollgrases zu einer hochalpinen Traumlandschaft wird, gelangen wir über den Trüber See zum Egetjoch (2.695 m) mit Blick zum Botzer (3.251 m) und dem darunter liegenden Hängenden Ferner. Wir steigen zum klaren Moarer Egetensee ab, in dem sich der Himmel spiegelt. Auf dem Weg zur Schneeberg Scharte sind wir bereits mitten in dem historischen Bergbaugebiet vom Schneeberg. Das Schneeberghaus ist bereits zu sehen, unsere Unterkunft für die kommende Nacht. 1.000 Hm1.250 Hm800m7 hsehr schwerHalbpension <h3>4. Tag: Abstieg in das Passeier Tal </h3> Wir starten unsere Wanderung mit einem kleinen Abstieg, vorbei an historischen Bauwerken des Bergbaugebietes Schneeberg. Über Wiesen und abwechslungsreichen Gelände führt unser Weg unterhalb der Rinnenspitze und dem Ratschinger Weißen entlang in Richtung Hochwart (2.608 m). Der Gipfelbereich erfordert Konzentration. Wir überwinden die Ausgesetzten und zum Teil versicherten Passagen und erreichen den Gipfel mit einer Atemberaubenden Aussicht. Nach unserer Gipfelrast beginnen wir mit dem Abstieg und geht über das Refugio Hochalm auf halber Strecke bis kurz vor der Ortschaft Stuls. Ein kurzer Transfer bringt uns nach Pfelders im gleichnamigen Tal. Übernachtung im Hotel. 650 Hm1.400 Hm800m5 - 6 hsehr schwerHalbpension <h3>5. Tag: Durch die Texelgruppe zur Spronser Seen Platte</h3> Heute können wir das Frühstück in vollen Zügen genießen. Gut gestärkt wandern wir durch das Faltschnaltal zum Faltschnaljöchl (2.417 m) und schließlich dem Spronser Joch (2.581 m). Die Landschaft auf der Südseite ist geprägt von zahlreichen Seen. An einen der Seen bietet sich eine wohlverdiente Pause an. Unser Weg führt uns weiter im Naturpark Texelgruppe in Richtung Meran. Bald haben wir unsere Unterkunft für den heutigen Tag erreicht, dass Schutzhaus Bockerhütte (1.700 m). 1.000 Hm900 Hm800m5 hsehr schwerHalbpension <h3>6. Tag: Der Weg nach Meran</h3> Heute startet unsere letzte Etappe der Alpenüberquerung von Innsbruck nach Meran. Nach einem kurzen Aufstieg entlang der Mutspitze, geht es über den Mutkopf (1.664 m), hoch über dem Meraner Becken, weiter über Waldwege in das Dorf Tirol. Unser Ziel, Meran auf 323 m ist jetzt nicht mehr weit entfernt. In Meran angekommen haben wir noch Zeit durch die Altstadt zu schlendern, bevor es zum Abendessen geht. Übernachtung im Hotel. 250 Hm1.550 Hm800m4-5 hsehr schwerFrühstück <h3>7. Tag: Rückfahrt nach Innsbruck</h3> Mit der Bahn fahren wir über den Brenner zurück nach Innsbruck. Eine beindruckende Woche liegt hinter uns. Wir nehmen Abschied am frühen Nachmittag. 400 Hm1.200 Hm800m4 - 5 hsehr schwerFrühstück
 ws_text_services<ul> <li>Speisen und Getränke außerhalb der Halbpension</li> <li>Abendessen am letzten Abend</li> <li>Individuelle Trinkgelder</li> </ul>
 ws_text_information
 ws_text_location_description
 ws_text_accomodation
 ws_text_course_content
 ws_text_overview
 ws_text_advantages<ul> <li>Bequeme Bahnanreise nach Innsbruck</li> <li>Angenehme Tagesetappen</li> <li>Wandern im Naturpark Texelgruppe</li> <li>Abwechslungsreiche Unterkünfte</li> <li>Auf historischen Wegen über die Alpen</li> </ul>
 ws_text_detail_description_new<h3>Von Hütte zu Hütte | Alpenüberquerung von Innsbruck nach Meran</h3> Bei dieser Alpenüberquerung überschreiten wir die Stubaier Alpen mit ihren imposanten 3.000-ern sowie deren Gletschern. Wir tauchen ein in das Bergbaugebiet am Schneeberg. Hier wurde bis 1985 wertvolles Silber, Blei und Zink abgebaut. Über den Naturpark Texelgruppe mit der Spronser Seen Platte erreichen wir mit einer beeindruckenden Aussicht in den Vinschgau schließlich Meran. 
 ws_text_information_new
 ws_text_accomodation_new
 ws_text_arrival(null)
 Route(array)
 id6179
 hasha786191b368bcbabdf0b53bf83afda1a
 created2022-10-17 10:10:32
 updated2024-10-02 15:06:05
 modelTour
 foreign_key452
 base/
 aliasalpenueberquerung-von-innsbruck-nach-meran
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft7397
 rght7398
 route/alpenueberquerung-von-innsbruck-nach-meran
 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)
 id37128
 tour_id452
 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)
 1(array)
 id31
 hash353ce9bd62c24ea4e9ca5a3234093802
 created2016-06-28 11:22:43
 updated2019-01-10 15:50:08
 titleAlpenüberquerung
 oa_categoriesofferLong-distanceHiking
 use_for_mountain_guide_tour_search(false)
 tour_main_type_id3
 tour_count18
 TourTypesTour(array)
 id37129
 tour_id452
 tour_type_id31
 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)
 id1914
 hashe0cb51d189d21c1af6d847b4f00c0d77
 created2016-09-26 20:14:52
 updated2016-09-26 20:14:52
 titleWandern in der Bernina auf dem Bernina Trek
 cross_reference_count3
 MediaEntity(array)
 id606381
 pos1
 media_id1914
 modelTour
 fieldteaser_image
 foreign_key452
 FileUpload(array)
 0(array)
 id18653
 hash446ee15f971d86386641dfd9bdbdbf80
 created2016-09-26 20:14:36
 updated2016-09-26 20:14:52
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/57e9659cbf872.jpg
 size238690
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id817459
 hashb6680836a87cf46221f6a2332eb194b5
 created2024-10-02 16:35:55
 updated2024-10-02 16:35:55
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id18653
 filewebroot/files/Media/File/ThTourHeaderImage/66fd5a4b2ec33.jpg
 size83828
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 2(array)
 id445367
 hash9e7c15aab154a9ca561f041fe8cc01b5
 created2020-10-28 00:18:06
 updated2020-10-28 00:18:06
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id18653
 filewebroot/files/Media/File/ThMediaFileIndex/5f98aaae11eb2.jpg
 size13090
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id445369
 hashad57bc8bcf9d9e1bd179002b2cae3eff
 created2020-10-28 00:18:06
 updated2020-10-28 00:18:06
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id18653
 filewebroot/files/Media/File/CkeditorXs/5f98aaae46145.jpg
 size4133
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id445371
 hash947922586412cb454803b82479ba9c47
 created2020-10-28 00:18:06
 updated2020-10-28 00:18:06
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id18653
 filewebroot/files/Media/File/CkeditorSm/5f98aaae8c7da.jpg
 size13090
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id445372
 hashd213a55ea21f3cb056b394f819e4a42c
 created2020-10-28 00:18:06
 updated2020-10-28 00:18:06
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id18653
 filewebroot/files/Media/File/CkeditorMd/5f98aaaebcb0c.jpg
 size21021
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id445374
 hash7e2bdfffe84b7eb5bded3ab9307d76ca
 created2020-10-28 00:18:07
 updated2020-10-28 00:18:07
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id18653
 filewebroot/files/Media/File/CkeditorLg/5f98aaaeec867.jpg
 size45706
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 7(array)
 id813551
 hashb3fe0558d02ac29fc1de44f12718068a
 created2024-10-02 15:06:03
 updated2024-10-02 15:06:03
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id18653
 filewebroot/files/Media/File/ThTourTeaserImage/66fd453bd3be6.jpg
 size64063
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 8(array)
 id813552
 hash05e5985719ef838ee084cb9f5869ec48
 created2024-10-02 15:06:04
 updated2024-10-02 15:06:04
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id18653
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/66fd453bf2373.jpg
 size59958
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 9(array)
 id813553
 hashf69b92cabf8937f225d1ee2d1ca6e4a6
 created2024-10-02 15:06:04
 updated2024-10-02 15:06:04
 modelMedia
 fieldfile
 foreign_key1914
 aliaswandern-in-der-bernina-auf-dem-bernina-trek-thtourteaserimagefullscreen.jpg
 thumbnailth-tour-teaser-image-fullscreen
 parent_id18653
 filewebroot/files/Media/File/ThTourTeaserImageFullscreen/66fd453c14ee7.jpg
 size271243
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
- 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	/nuernberger-huette
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/nuernberger-huette
Remote Port	36996
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/nuernberger-huette
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/nuernberger-huette
Script Url	/nuernberger-huette
Unique Id	ZyLMM7eDAnhIcrFZonR0xwAAAQA
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/nuernberger-huette
Redirect Script Url	/nuernberger-huette
Redirect Unique Id	ZyLMM7eDAnhIcrFZonR0xwAAAQA
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/nuernberger-huette
Redirect Redirect Script Url	/nuernberger-huette
Redirect Redirect Unique Id	ZyLMM7eDAnhIcrFZonR0xwAAAQA
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1730333747.8629
Request Time	1730333747

====

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
====

Nürnberger Hütte Stubaier Alpen, 2.278 m Hütte am Stubaier Hauptkamm

Öffnungszeiten

Ausstattung

Währung & Bezahlung

Standort der Unterkunft

Reisen mit der Unterkunft Nürnberger Hütte 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

Nürnberger Hütte
Stubaier Alpen, 2.278 m
Hütte am Stubaier Hauptkamm

Total Time: 21 ms
Total Queries: 142 queries