Twists and turns on Oberjoch Pass
Oberreute - Nesselwang 61 kilometer
The Upper Allgäu tour runs through Oberstaufen, passing Grosser Alpsee lake, as well as Immenstadt, Sonthofen and Bad Hindelang, before following the Oberjoch Pass towards Wertach. The Oberjoch Pass is one of Bavaria's most popular scenic drives. Whether you're in an open-top car or on a motorbike, it offers an exhilarating drive with 105 bends.
The view point at 'Paradise' owes its name to the fantastic panoramic views of the Nagelfluhkette national park, the Vorarlberg (Austrian region) and the Swiss Alps. We continue to Oberstaufen. Visitors love the wide range of health offerings and leisure activities available here, as well as the quality and quantity of exceptional hotels and restaurants.
From Oberstaufen we first come to the Großen Alpsee lake, then to Immenstadt - an old royal city with a castle, many lovely squares and tourist attractions. Via Sonthofen and Bad Hindelang we approach the most winding road in Germany: the Oberjoch pass road, which dates back to the Middle Ages.
The Oberjoch pass was an important trade route over the Alps. In the year 1662, the pass road saw the transportation of 15,850 barrels of salt (each barrel weighing circa 280 kg / 600 lbs) with no fewer than 300 horses working the road each day. That was major traffic for its time and led to regional prosperity.
In 1895 the construction of the new road began, designed to handle heavier traffic with a wider breadth and lower gradient. The 300 m / 1,000 ft difference in height from Hindelang to Oberjoch was bridged with 106 bends. The integration of the road into the countryside was done so well that today the Oberjoch pass road is perceived as much part of the countryside as the adjacent mountains and villages.
So, buckle up and go! But don't miss the viewing platform just before the summit (looking back down the valley) as on the other side the descent to Wertach is gentle and through meadows.
-
- History
-
Session +
Session
- Config(array)
- userAgentca40b5f22cf3d88f707fb259b2686ed4
- time1656236359
- countdown10
- languageen
==== - Config(array)
-
Request +
Request
Cake Params
- pluginFrontendContents
- controllerFrontendContents
- actionregions
- named(empty)
- pass(array)
- 094
- ids(array)
- Menu68
- Content94
- Language4
- route(array)
- id214
- hashb55597bbc6f63ccfb8f76a0f7c6b0a77
- created2016-10-26 13:43:14
- updated2019-07-22 11:39:35
- modelContent
- foreign_key94
- base/en/route/allgaeu-alps/
- aliasallgaeu-alps
- controllerFrontendContents.FrontendContents
- actionregions
- parent_id176
- lft1823
- rght1824
- route/en/route/allgaeu-alps/allgaeu-alps
- isAjax(false)
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: 1 ms
Total Queries: 114 queriesQuery 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 `deutsche_alpenstr2019`.`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`))) = '/en/route/allgaeu-alps/allgaeu-alps' LIMIT 1 1 1 0 SELECT `Route`.`model`, `Route`.`foreign_key` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`lft` <= 1823 AND `Route`.`rght` >= 1824 ORDER BY `Route`.`lft` asc 5 5 0 SELECT `Menu`.`id`, `Language`.`id` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 68 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `deutsche_alpenstr2019`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL LIMIT 1 1 1 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 68 AND `Route`.`model` = 'Menu' 1 1 0 SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`seo` AS `Seo` WHERE `Seo`.`foreign_key` = 68 AND `Seo`.`model` = 'Menu' 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 150 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 68 AND `Teaser`.`model` = 'Menu' 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 150 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (29) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 13 13 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Language`.`langid` FROM `deutsche_alpenstr2019`.`languages` AS `Language` WHERE `Language`.`id` = 4 LIMIT 1 1 1 0 SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `deutsche_alpenstr2019`.`settings` AS `Setting` LEFT JOIN `deutsche_alpenstr2019`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id` 24 24 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 `deutsche_alpenstr2019`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 26, 27, 28, 29) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`map_lat`, `Content`.`map_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`teaser_icon`, `Content`.`region_id`, `Content`.`point_type`, `Content`.`stage_map_test`, `Content`.`gmap_long`, `Content`.`gmap_lat`, `Content`.`stage_map_test_two`, `Content`.`reduced_teaser`, `Content`.`download_text`, (CONCAT_WS (';',`Content`.`map_lat`,`Content`.`map_long`)) AS `Content__map`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Region`.`id`, `Region`.`hash`, `Region`.`created`, `Region`.`updated`, `Region`.`title`, `Region`.`association`, `Region`.`street`, `Region`.`zip_city`, `Region`.`phone`, `Region`.`fax`, `Region`.`email`, `Region`.`url`, `Region`.`webcam_url_teaser`, `Region`.`webcam_url_detail`, `Region`.`url_type`, `Region`.`region_content`, `Region`.`map_guid`, `Region`.`map_link_text_1`, `Region`.`map_link_url_1`, `Region`.`map_link_text_2`, `Region`.`map_link_url_2`, `Region`.`region_content_intro`, `Region`.`places_et4`, `Region`.`hotels_et4`, `Region`.`tips_et4`, `Region`.`next_link`, `Region`.`previous_link`, `Region`.`prev_west_region_id`, `Region`.`next_east_region_id`, `Region`.`stage_map_start`, `Region`.`stage_map_end`, `Region`.`stage_map_zoom`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`contents` AS `Content` LEFT JOIN `deutsche_alpenstr2019`.`regions` AS `Region` ON (`Content`.`region_id` = `Region`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') inner JOIN `deutsche_alpenstr2019`.`regions` AS `RegionsForConditions` ON (`Content`.`region_id` = `Region`.`id`) WHERE `Content`.`status` = 'active' AND `Content`.`id` = 94 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1 1 1 1 SELECT `PrevWestRegion`.`id`, `PrevWestRegion`.`hash`, `PrevWestRegion`.`created`, `PrevWestRegion`.`updated`, `PrevWestRegion`.`title`, `PrevWestRegion`.`association`, `PrevWestRegion`.`street`, `PrevWestRegion`.`zip_city`, `PrevWestRegion`.`phone`, `PrevWestRegion`.`fax`, `PrevWestRegion`.`email`, `PrevWestRegion`.`url`, `PrevWestRegion`.`webcam_url_teaser`, `PrevWestRegion`.`webcam_url_detail`, `PrevWestRegion`.`url_type`, `PrevWestRegion`.`region_content`, `PrevWestRegion`.`map_guid`, `PrevWestRegion`.`map_link_text_1`, `PrevWestRegion`.`map_link_url_1`, `PrevWestRegion`.`map_link_text_2`, `PrevWestRegion`.`map_link_url_2`, `PrevWestRegion`.`region_content_intro`, `PrevWestRegion`.`places_et4`, `PrevWestRegion`.`hotels_et4`, `PrevWestRegion`.`tips_et4`, `PrevWestRegion`.`next_link`, `PrevWestRegion`.`previous_link`, `PrevWestRegion`.`prev_west_region_id`, `PrevWestRegion`.`next_east_region_id`, `PrevWestRegion`.`stage_map_start`, `PrevWestRegion`.`stage_map_end`, `PrevWestRegion`.`stage_map_zoom` FROM `deutsche_alpenstr2019`.`regions` AS `PrevWestRegion` WHERE `PrevWestRegion`.`id` = 1 1 1 0 SELECT `RegionI18n`.`id`, `RegionI18n`.`hash`, `RegionI18n`.`created`, `RegionI18n`.`updated`, `RegionI18n`.`language_id`, `RegionI18n`.`region_id`, `RegionI18n`.`main_title`, `RegionI18n`.`title`, `RegionI18n`.`region_content_intro`, `RegionI18n`.`region_content`, `RegionI18n`.`image_title_7`, `RegionI18n`.`image_title_9`, `RegionI18n`.`image_title_8`, `RegionI18n`.`image_title_6`, `RegionI18n`.`image_title_10`, `RegionI18n`.`image_title_3`, `RegionI18n`.`image_title_1`, `RegionI18n`.`image_title_5`, `RegionI18n`.`image_title_4`, `RegionI18n`.`image_title_2`, `RegionI18n`.`previous_link`, `RegionI18n`.`next_link`, `RegionI18n`.`url` FROM `deutsche_alpenstr2019`.`region_i18n` AS `RegionI18n` WHERE `language_id` = '4' AND `RegionI18n`.`region_id` = (1) 1 1 0 SELECT `NextEastRegion`.`id`, `NextEastRegion`.`hash`, `NextEastRegion`.`created`, `NextEastRegion`.`updated`, `NextEastRegion`.`title`, `NextEastRegion`.`association`, `NextEastRegion`.`street`, `NextEastRegion`.`zip_city`, `NextEastRegion`.`phone`, `NextEastRegion`.`fax`, `NextEastRegion`.`email`, `NextEastRegion`.`url`, `NextEastRegion`.`webcam_url_teaser`, `NextEastRegion`.`webcam_url_detail`, `NextEastRegion`.`url_type`, `NextEastRegion`.`region_content`, `NextEastRegion`.`map_guid`, `NextEastRegion`.`map_link_text_1`, `NextEastRegion`.`map_link_url_1`, `NextEastRegion`.`map_link_text_2`, `NextEastRegion`.`map_link_url_2`, `NextEastRegion`.`region_content_intro`, `NextEastRegion`.`places_et4`, `NextEastRegion`.`hotels_et4`, `NextEastRegion`.`tips_et4`, `NextEastRegion`.`next_link`, `NextEastRegion`.`previous_link`, `NextEastRegion`.`prev_west_region_id`, `NextEastRegion`.`next_east_region_id`, `NextEastRegion`.`stage_map_start`, `NextEastRegion`.`stage_map_end`, `NextEastRegion`.`stage_map_zoom` FROM `deutsche_alpenstr2019`.`regions` AS `NextEastRegion` WHERE `NextEastRegion`.`id` = 3 1 1 0 SELECT `RegionI18n`.`id`, `RegionI18n`.`hash`, `RegionI18n`.`created`, `RegionI18n`.`updated`, `RegionI18n`.`language_id`, `RegionI18n`.`region_id`, `RegionI18n`.`main_title`, `RegionI18n`.`title`, `RegionI18n`.`region_content_intro`, `RegionI18n`.`region_content`, `RegionI18n`.`image_title_7`, `RegionI18n`.`image_title_9`, `RegionI18n`.`image_title_8`, `RegionI18n`.`image_title_6`, `RegionI18n`.`image_title_10`, `RegionI18n`.`image_title_3`, `RegionI18n`.`image_title_1`, `RegionI18n`.`image_title_5`, `RegionI18n`.`image_title_4`, `RegionI18n`.`image_title_2`, `RegionI18n`.`previous_link`, `RegionI18n`.`next_link`, `RegionI18n`.`url` FROM `deutsche_alpenstr2019`.`region_i18n` AS `RegionI18n` WHERE `language_id` = '4' AND `RegionI18n`.`region_id` = (3) 1 1 0 SELECT `RegionI18n`.`id`, `RegionI18n`.`hash`, `RegionI18n`.`created`, `RegionI18n`.`updated`, `RegionI18n`.`language_id`, `RegionI18n`.`region_id`, `RegionI18n`.`main_title`, `RegionI18n`.`title`, `RegionI18n`.`region_content_intro`, `RegionI18n`.`region_content`, `RegionI18n`.`image_title_7`, `RegionI18n`.`image_title_9`, `RegionI18n`.`image_title_8`, `RegionI18n`.`image_title_6`, `RegionI18n`.`image_title_10`, `RegionI18n`.`image_title_3`, `RegionI18n`.`image_title_1`, `RegionI18n`.`image_title_5`, `RegionI18n`.`image_title_4`, `RegionI18n`.`image_title_2`, `RegionI18n`.`previous_link`, `RegionI18n`.`next_link`, `RegionI18n`.`url` FROM `deutsche_alpenstr2019`.`region_i18n` AS `RegionI18n` WHERE `RegionI18n`.`language_id` = 4 AND `RegionI18n`.`region_id` = (2) 1 1 0 SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `GalleryMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Region' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC 6 6 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (38, 39, 40, 41, 42, 43) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 55 55 0 SELECT `RegionPointsForLocations`.`id`, `RegionPointsForLocations`.`hash`, `RegionPointsForLocations`.`created`, `RegionPointsForLocations`.`updated`, `RegionPointsForLocations`.`status`, `RegionPointsForLocations`.`title`, `RegionPointsForLocations`.`content_type`, `RegionPointsForLocations`.`category`, `RegionPointsForLocations`.`teaser_title`, `RegionPointsForLocations`.`top_tip`, `RegionPointsForLocations`.`map_lat`, `RegionPointsForLocations`.`map_long`, `RegionPointsForLocations`.`street`, `RegionPointsForLocations`.`zip_code`, `RegionPointsForLocations`.`city`, `RegionPointsForLocations`.`phone`, `RegionPointsForLocations`.`website_url`, `RegionPointsForLocations`.`email`, `RegionPointsForLocations`.`region1`, `RegionPointsForLocations`.`region2`, `RegionPointsForLocations`.`region3`, `RegionPointsForLocations`.`booking_link`, `RegionPointsForLocations`.`gmap_url`, `RegionPointsForLocations`.`external_id`, `RegionPointsForLocations`.`gmap_zoom`, `RegionPointsForLocations`.`fax`, `RegionPointsForLocations`.`weather_widget_code`, `RegionPointsForLocations`.`hotels_gastronomy`, `RegionPointsForLocations`.`hotels_wellness`, `RegionPointsForLocations`.`hotels_parking`, `RegionPointsForLocations`.`hotels_car_rental`, `RegionPointsForLocations`.`hotels_oldtimer`, `RegionPointsForLocations`.`hotels_transfer`, `RegionPointsForLocations`.`hotels_car_charging_possibility`, `RegionPointsForLocations`.`hotels_distance_to_nearest_train_station`, `RegionPointsForLocations`.`hotels_bike_rental`, `RegionPointsForLocations`.`hotels_car_rental_other_de`, `RegionPointsForLocations`.`hotels_car_rental_other_it`, `RegionPointsForLocations`.`hotels_car_rental_other_nl`, `RegionPointsForLocations`.`hotels_car_rental_other_en`, `RegionPointsForLocations`.`hotels_emobil`, (CONCAT_WS (';',`RegionPointsForLocations`.`map_lat`,`RegionPointsForLocations`.`map_long`)) AS `RegionPointsForLocations__map`, `PointsRegionsForLocation`.`id`, `PointsRegionsForLocation`.`region_id`, `PointsRegionsForLocation`.`point_id`, `PointsRegionsForLocation`.`position` FROM `deutsche_alpenstr2019`.`points` AS `RegionPointsForLocations` JOIN `deutsche_alpenstr2019`.`points_regions_for_locations` AS `PointsRegionsForLocation` ON (`PointsRegionsForLocation`.`region_id` = 2 AND `PointsRegionsForLocation`.`point_id` = `RegionPointsForLocations`.`id`) WHERE `RegionPointsForLocations`.`status` = 'active' ORDER BY `PointsRegionsForLocation`.`position` ASC 5 5 0 SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` WHERE `language_id` = '4' AND `PointI18n`.`point_id` IN (115, 112, 113, 110, 114) 1 1 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 172 AND `Route`.`model` = 'PointI18n' 1 1 0 SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` IN (115, 112, 113, 110, 114) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC 10 10 0 SELECT `RegionPointsForHotels`.`id`, `RegionPointsForHotels`.`hash`, `RegionPointsForHotels`.`created`, `RegionPointsForHotels`.`updated`, `RegionPointsForHotels`.`status`, `RegionPointsForHotels`.`title`, `RegionPointsForHotels`.`content_type`, `RegionPointsForHotels`.`category`, `RegionPointsForHotels`.`teaser_title`, `RegionPointsForHotels`.`top_tip`, `RegionPointsForHotels`.`map_lat`, `RegionPointsForHotels`.`map_long`, `RegionPointsForHotels`.`street`, `RegionPointsForHotels`.`zip_code`, `RegionPointsForHotels`.`city`, `RegionPointsForHotels`.`phone`, `RegionPointsForHotels`.`website_url`, `RegionPointsForHotels`.`email`, `RegionPointsForHotels`.`region1`, `RegionPointsForHotels`.`region2`, `RegionPointsForHotels`.`region3`, `RegionPointsForHotels`.`booking_link`, `RegionPointsForHotels`.`gmap_url`, `RegionPointsForHotels`.`external_id`, `RegionPointsForHotels`.`gmap_zoom`, `RegionPointsForHotels`.`fax`, `RegionPointsForHotels`.`weather_widget_code`, `RegionPointsForHotels`.`hotels_gastronomy`, `RegionPointsForHotels`.`hotels_wellness`, `RegionPointsForHotels`.`hotels_parking`, `RegionPointsForHotels`.`hotels_car_rental`, `RegionPointsForHotels`.`hotels_oldtimer`, `RegionPointsForHotels`.`hotels_transfer`, `RegionPointsForHotels`.`hotels_car_charging_possibility`, `RegionPointsForHotels`.`hotels_distance_to_nearest_train_station`, `RegionPointsForHotels`.`hotels_bike_rental`, `RegionPointsForHotels`.`hotels_car_rental_other_de`, `RegionPointsForHotels`.`hotels_car_rental_other_it`, `RegionPointsForHotels`.`hotels_car_rental_other_nl`, `RegionPointsForHotels`.`hotels_car_rental_other_en`, `RegionPointsForHotels`.`hotels_emobil`, (CONCAT_WS (';',`RegionPointsForHotels`.`map_lat`,`RegionPointsForHotels`.`map_long`)) AS `RegionPointsForHotels__map`, `PointsRegionsForHotel`.`id`, `PointsRegionsForHotel`.`region_id`, `PointsRegionsForHotel`.`point_id`, `PointsRegionsForHotel`.`position` FROM `deutsche_alpenstr2019`.`points` AS `RegionPointsForHotels` JOIN `deutsche_alpenstr2019`.`points_regions_for_hotels` AS `PointsRegionsForHotel` ON (`PointsRegionsForHotel`.`region_id` = 2 AND `PointsRegionsForHotel`.`point_id` = `RegionPointsForHotels`.`id`) WHERE `RegionPointsForHotels`.`status` = 'active' ORDER BY `PointsRegionsForHotel`.`position` ASC 3 3 0 SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` WHERE `language_id` = '4' AND `PointI18n`.`point_id` IN (150, 151, 169) 3 3 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 `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 268 AND `Route`.`model` = 'PointI18n' 1 1 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 272 AND `Route`.`model` = 'PointI18n' 1 1 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 307 AND `Route`.`model` = 'PointI18n' 1 1 0 SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` IN (150, 151, 169) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC 6 6 0 SELECT `RegionPointsForPOIs`.`id`, `RegionPointsForPOIs`.`hash`, `RegionPointsForPOIs`.`created`, `RegionPointsForPOIs`.`updated`, `RegionPointsForPOIs`.`status`, `RegionPointsForPOIs`.`title`, `RegionPointsForPOIs`.`content_type`, `RegionPointsForPOIs`.`category`, `RegionPointsForPOIs`.`teaser_title`, `RegionPointsForPOIs`.`top_tip`, `RegionPointsForPOIs`.`map_lat`, `RegionPointsForPOIs`.`map_long`, `RegionPointsForPOIs`.`street`, `RegionPointsForPOIs`.`zip_code`, `RegionPointsForPOIs`.`city`, `RegionPointsForPOIs`.`phone`, `RegionPointsForPOIs`.`website_url`, `RegionPointsForPOIs`.`email`, `RegionPointsForPOIs`.`region1`, `RegionPointsForPOIs`.`region2`, `RegionPointsForPOIs`.`region3`, `RegionPointsForPOIs`.`booking_link`, `RegionPointsForPOIs`.`gmap_url`, `RegionPointsForPOIs`.`external_id`, `RegionPointsForPOIs`.`gmap_zoom`, `RegionPointsForPOIs`.`fax`, `RegionPointsForPOIs`.`weather_widget_code`, `RegionPointsForPOIs`.`hotels_gastronomy`, `RegionPointsForPOIs`.`hotels_wellness`, `RegionPointsForPOIs`.`hotels_parking`, `RegionPointsForPOIs`.`hotels_car_rental`, `RegionPointsForPOIs`.`hotels_oldtimer`, `RegionPointsForPOIs`.`hotels_transfer`, `RegionPointsForPOIs`.`hotels_car_charging_possibility`, `RegionPointsForPOIs`.`hotels_distance_to_nearest_train_station`, `RegionPointsForPOIs`.`hotels_bike_rental`, `RegionPointsForPOIs`.`hotels_car_rental_other_de`, `RegionPointsForPOIs`.`hotels_car_rental_other_it`, `RegionPointsForPOIs`.`hotels_car_rental_other_nl`, `RegionPointsForPOIs`.`hotels_car_rental_other_en`, `RegionPointsForPOIs`.`hotels_emobil`, (CONCAT_WS (';',`RegionPointsForPOIs`.`map_lat`,`RegionPointsForPOIs`.`map_long`)) AS `RegionPointsForPOIs__map`, `PointsRegionsForPois`.`id`, `PointsRegionsForPois`.`region_id`, `PointsRegionsForPois`.`point_id`, `PointsRegionsForPois`.`position` FROM `deutsche_alpenstr2019`.`points` AS `RegionPointsForPOIs` JOIN `deutsche_alpenstr2019`.`points_regions_for_pois` AS `PointsRegionsForPois` ON (`PointsRegionsForPois`.`region_id` = 2 AND `PointsRegionsForPois`.`point_id` = `RegionPointsForPOIs`.`id`) WHERE `RegionPointsForPOIs`.`status` = 'active' ORDER BY `PointsRegionsForPois`.`position` ASC 2 2 0 SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` WHERE `language_id` = '4' AND `PointI18n`.`point_id` IN (160, 171) 0 0 0 SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` IN (160, 171) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC 4 4 0 SELECT `PointI18n`.`title`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`content_type`, IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`)) AS Route__route, `Point`.`id` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `Point`.`status` = 'active' AND `PointI18n`.`language_id` = 4 37 37 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'stages' AND `Language`.`langid` = 'en' 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 336 AND `Menu`.`rght` < 357 ORDER BY `Menu`.`lft` asc 9 9 0 SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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 `deutsche_alpenstr2019`.`languages` AS `Language` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`langid` = 'de' LIMIT 1 1 1 0 SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC 2 2 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'en' 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 325 AND `Menu`.`rght` < 438 ORDER BY `Menu`.`lft` asc 55 55 0 SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'en' 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 60 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 142 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (170) 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 142 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 60 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 60 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'links' AND `Language`.`langid` = 'en' 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 564 AND `Menu`.`rght` < 569 ORDER BY `Menu`.`lft` asc 2 2 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'en' 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 436 AND `Menu`.`rght` < 437 ORDER BY `Menu`.`lft` asc 0 0 0 SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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 `deutsche_alpenstr2019`.`languages` AS `Language` LEFT JOIN `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`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 8 8 0 SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Content' AND `Seo`.`foreign_key` = 94 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 188 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 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` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` WHERE `Menu`.`id` = 68 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 339 AND `Menu`.`rght` >= 340 AND `Menu`.`type` != 'structure' ORDER BY `Menu`.`lft` asc 2 2 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 68 LIMIT 1 1 1 0 SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'en' 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 61 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 143 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 143 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 61 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 61 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` < 339 AND `Menu`.`rght` > 340 AND `Menu`.`parent_id` = 61 ORDER BY `Menu`.`lft` asc LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 148 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 148 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 66 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 66 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social_share_links' AND `Language`.`langid` = 'en' 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 179 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 441 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 441 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 179 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 179 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 179 3 3 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 443 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 445 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 446 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 443 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 445 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 446 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 183, 184) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 183, 184) AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 3 3 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (285, 287, 288) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 18 18 0 SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social_site_links' AND `Language`.`langid` = 'en' 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 180 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 442 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 442 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 180 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 180 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 180 0 0 0 SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_social_links' AND `Language`.`langid` = 'en' 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 319 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 916 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 686 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 319 2 2 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 917 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 918 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 687 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 688 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (320, 321) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (320, 321) AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC 2 2 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (351, 352) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 2 2 0 SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' 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` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' 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` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'it' 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` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'nl' 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`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` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' 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 0 0 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 26.44 MB
Message Memory use Component initialization 9.77 MB Controller action start 13.29 MB Controller render start 16.96 MB View render complete 21.17 MB Timers
Total Request Time: 582 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 151.27 Event: Controller.initialize 71.81 Event: Controller.startup 7.61 Controller action 91.61 Event: Controller.beforeRender 88.46 » Processing toolbar data 19.78 Rendering View 47.03 » Event: View.beforeRender 0.50 » Rendering APP/Plugin/FrontendContents/View/FrontendContents/regions.php 20.91 » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php 10.87 » » Rendering APP/Plugin/FrontendContents/View/Elements/region_info_modals.php 4.26 » Event: View.afterRender 0.12 » Event: View.beforeLayout 0.05 » Rendering APP/View/Layouts/index.php 22.21 » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php 2.41 » » Rendering APP/View/Elements/subpages-heading.php 1.52 » » Rendering APP/View/Elements/footer-links.php 1.87 » » Rendering APP/View/Elements/contact-partners.php 0.38 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- row(array)
- Content(array)
- id94
- hasha8ed1df4cbd6357b09727bc20f1615bd
- created2016-10-26 13:43:14
- updated2019-07-22 11:39:35
- menu_id68
- position1
- typeregions
- statusactive
- titleAllgäu Alps
- layoutcol12
- language_id4
- article_content(null)
- contact_content(null)
- contact_email(null)
- contact_success(null)
- contact_error(null)
- iframe_url(null)
- iframe_width(null)
- iframe_height(null)
- release(null)
- hide(null)
- map_lat(null)
- map_long(null)
- gmap_zoom(null)
- gmap_type(null)
- gmap_marker(null)
- video_type(null)
- video_url(null)
- developer_template_code(null)
- developer_template_css(null)
- developer_template_js(null)
- teaser_menu_id(null)
- teaser_external_url(null)
- teaser_external_target(null)
- member_group_id0
- teaser_icon(null)
- region_id2
- point_typepoi
- stage_map_test(null)
- gmap_long(null)
- gmap_lat(null)
- stage_map_test_two(null)
- reduced_teaser(null)
- download_text(null)
- map
- published1
- Region(array)
- id2
- hasheed4a3faabb3d126dc2157d18438648b
- created2016-07-19 09:47:04
- updated2021-07-05 09:31:31
- titleAllgäu Gipfelwelten
- associationAllgäu GmbH
- streetAllgäuer Straße 1
- zip_city87435 Kempten
- phoneTel.: +49 (0) 8323 / 80 25 93 1
- faxFax: +49 (0) 831 / 5 75 37 33
- emailinfo@allgaeu.de
- urlhttp://www.allgaeu.de
- webcam_url_teaserhttps://www.feratel.com/webcams/deutschland/bad-hindelang
- webcam_url_detailhttps://www.feratel.com/webcams/deutschland/bad-hindelang
- url_typeurl
- region_content<p>Über das so genannte „Paradies", das seinen Namen dem fantastischen Panoramablick auf die Nagelfluhkette, die Vorarlberger und die Schweizer Alpen verdankt, geht es weiter nach Oberstaufen. Gäste schätzen neben den zahlreichen Gesundheits- und Freizeitangeboten vor allem die Qualität und Dichte an gehobener Hotellerie und Gastronomie.</p> <p>Was nur wenigen bekannt ist, jährlich am ersten Wochenende im Mai startet hier die Allgäu-Orient-Rallye. Sie ist mit etwa 100 Teams, 300 Autos/Motorrädern und 600 Teilnehmern die zweitgrößte Rallye-Veranstaltung der Welt. Auf dem 18-tägigen Weg nach Amman in Jordanien müssen die Teams ähnlich einer Schnitzeljagd viele Aufgaben erledigen.</p> <p>Von Oberstaufen geht es weiter durch das Oberallgäu am Großen Alpsee vorbei nach Immenstadt, der alten Residenzstadt mit Stadtschloss, mit vielen lieblichen Plätzen und Sehenswürdigkeiten. Über Sonthofen und Bad Hindelang nähern Sie sich der kurvenreichsten Straße Deutschlands: der Oberjoch Passstraße: bereits im Mittelalter war die Verbindung über den Oberjoch Pass ein wichtiger Handelsweg über die Alpen. So wurden im Jahr 1662 auf der Jochstraße 15.850 Salzfässer (ein Fass wog etwa 5 Zentner) verfrachtet. Nicht weniger als 300 Pferde waren Tag für Tag unterwegs, ein für damalige Zeiten gewaltiger Verkehr.</p> <p>1895 wurde mit dem Bau der neuen Straße begonnen. Sie wurde von vornherein für starken Verkehr angelegt, erhielt eine ansehnliche Breite und vor allem ein geringes Gefälle. Der Höhenunterschied von 300 Metern von Hindelang nach Oberjoch wurde mit 106 Kurven überbrückt. Die Integration der Straße in die Landschaft erfolgte so großartig und einfühlsam, dass heute die Jochstraße als genauso zur Landschaft gehörend empfunden wird wie das Bergpanorama und die Ortschaften. Also, anschnallen und los gehts! Aber verpassen Sie nicht die Aussichtskanzel kurz vor der Passhöhe, um nochmals einen Blick zurückzuwerfen, denn auf der anderen Seite geht es recht sanft über Almwiesen hinunter in Richtung Wertach.</p>
- map_guidD40B92B8A93F921A0D501E3F4A87B2D5
- map_link_text_1Etappe auf Karte anzeigen
- map_link_url_1http://ecmaps.de/?hideSearch=true&experience=deutsche-alpenstrasse&inherit=_ecMaps_v5light#q=all%3Aall&lat=47.5508&lon=10.2070&z=12&id=D40B92B8A93F921A0D501E3F4A87B2D5&type=Tour
- map_link_text_2Alle Etappen auf Karte anzeigen
- map_link_url_2http://ecmaps.de/?hideSearch=true&experience=deutsche-alpenstrasse&inherit=_ecMaps_v5light#q=all%3Aall&lat=47.5348&lon=11.2747&z=9&id=CDF4B633EE7AA683E5D4EADEC6839F55&type=Tour
- region_content_intro<h2>Kurvenfeeling am Oberjoch Pass</h2> <h3>Von Oberstaufen nach Wertach</h3> <p><strong>Routenlänge: ca. 65 km</strong></p> <p>Die Tour durch das Oberallgäu führt über Oberstaufen vorbei am Großen Alpsee nach Immenstadt, Sonthofen, Bad Hindelang und das Oberjoch in Richtung Wertach. Die Oberjoch Passstrasse zählt zu den bekanntesten Ausflugsstraßen Bayerns. Egal, ob Sie eine Motorrad- oder Cabriotour planen: die 106 Kurven bieten Fahrvergnügen vom Feinsten.</p>
- places_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Poi/Route_02/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- hotels_et4
- tips_et4
- next_linkhttps://www.deutsche-alpenstrasse.de/de/route/allgaeu-schlosspark
- previous_linkhttps://www.deutsche-alpenstrasse.de/de/route/allgaeu-bodensee
- prev_west_region_id1
- next_east_region_id3
- stage_map_start224
- stage_map_end607
- stage_map_zoom(null)
- PrevWestRegion(array)
- id1
- hash5d8a76c6399629dbf0723deabdddb9a6
- created2016-07-18 11:58:15
- updated2021-08-03 11:06:56
- titleAllgäu Bodensee
- associationAllgäu GmbH
- streetAllgäuer Straße 1
- zip_city87435 Kempten
- phoneTel.: +49 (0) 8323 / 80 25 93 1
- faxFax: +49 (0) 831 / 5 75 37 33
- emailinfo@allgaeu.de
- urlhttp://www.allgaeu.de
- webcam_url_teaserhttps://player.livespotting.tv/?alias=PS_473d4&ratio=16:9
- webcam_url_detailhttps://player.livespotting.tv/?alias=PS_473d4&ratio=16:9
- url_typeurl
- region_content<p>Ein Bummel durch Lindau ist genau das Richtige, um sich auf die bevorstehende Tour entlang der Deutschen Alpenstraße einzustimmen. Nehmen Sie sich Zeit für einen Rundgang durch die historische Altstadt. Bei einem Kaffee mit Ausblick auf das Treiben im Hafen kann man erst mal ankommen und sich vom mediterranen Klima durchwärmen lassen, bevor es hinauf in die Bergfrische geht.</p> <p>Auf dem Weg hinaus aus der Stadt gibt es noch einige Möglichkeiten, sich mit saftigen Äpfeln aus der Bodenseeregion einzudecken, die erfrischende und gesunde Wegzehrung für den kleinen Hunger zwischendurch. <span>Woran Sie ebenfalls nicht vorbeikommen, ist das Thema Käse. Entlang der Route bieten sich zahlreiche Möglichkeiten mehr über die Käseherstellung zu erfahren und die ein oder andere Kostprobe zu nehmen.</span></p> <p>Dann geht's gleich richtig los: die sieben Kehren, in denen sich der „Rohrach Anstieg" 400 Höhenmeter mit bis zu 9 Prozent Steigung nach oben windet, stimmen Sie ein auf das Fahrerlebnis Deutsche Alpenstraße. Lohnenswerte Abstecher führen zu den Scheidegger Wasserfällen, die zu Bayerns schönsten Geotopen zählen oder zum idyllisch gelegenen Waldsee, Deutschlands höchstgelegenem Moorbadesee.</p> <p>Die Geschichte des Städtchens Lindenberg wurde geprägt von der Hutindustrie. Die erste Hutfabrik wurde in der Biedermeierzeit gegründet, 1890 gab es 34 Strohhuthersteller, die um die 8 Millionen Strohhüte herstellten. Nicht verwunderlich also, dass Lindenberg Anfang des 20. Jahrhunderts als Zentrum der deutschen Herrenstrohhutindustrie galt und „Klein-Paris" der Hutmode genannt wurde. Das Lindenberger Hutmuseum gibt einen Einblick in die jahrhundertealte Huttradition der Stadt Lindenberg.</p> <p>Auf den nächsten Kilometern löst eine grandiose Aussicht die nächste ab. So bietet etwa 1,5 Kilometer nach der Abzweigung bei der Firma Liebherr eine Parkbucht den Fotostopp mit großartigem Ausblick auf die gesamte Nagelfluhkette. Auf dem Höhenrücken zwischen Weiler und Simmerberg sehen Sie bei klarem Wetter nicht nur die Allgäuer und Vorarlberger Berge, sondern sogar bis zum Schweizer Säntis-Massiv. Die Sonnenterrasse des Westallgäus, wo sich Hügel, Täler, Einzelgehöfte und Wiesen zu einem harmonischen Bild fügen, ist Autokino pur.</p>
- map_guid9AEF0258A782D0AB8B6FB27F6C6FC918
- map_link_text_1Etappe auf Karte anzeigen
- map_link_url_1http://ecmaps.de/?hideSearch=true&experience=deutsche-alpenstrasse&inherit=_ecMaps_v5light#q=all%3Aall&lat=47.5671&lon=9.8386&z=12&id=9AEF0258A782D0AB8B6FB27F6C6FC918&type=Tour
- map_link_text_2Alle Etappen auf Karte anzeigen
- map_link_url_2http://ecmaps.de/?hideSearch=true&experience=deutsche-alpenstrasse&inherit=_ecMaps_v5light#q=all%3Aall&lat=47.5348&lon=11.2747&z=9&id=CDF4B633EE7AA683E5D4EADEC6839F55&type=Tour
- region_content_intro<h2><strong>Vom Bodensee in die Westallgäuer Berge</strong></h2> <h3>Von Lindau nach Oberreute</h3> <p><strong>Routenlänge: ca. 30 km</strong></p> <p>Die beliebteste Ferienstraße Bayerns beginnt im Westallgäu. Vom mediterranen Lindau geht es über den Rohrbach Anstieg in die Allgäuer Berge. Besonders beliebt ist diese Panoramatour wegen ihrer grandiosen Blicke auf die Allgäuer und Vorarlberger Berge. Die Scheidegger Wasserfälle und das Städtchen Lindenberg mit seinem Hutmuseum bieten lohnenswerte Abstecher.</p>
- places_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Poi/Route_01%20%20category%3A%22Tourist-Informationen%22/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- hotels_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Gastgeber/route_01/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- tips_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Poi/tag%3A%22Route_01%22%20AND%20all%3Aall%20-category%3A%22Tourist-Informationen%22/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- next_link
- previous_link
- prev_west_region_id(null)
- next_east_region_id2
- stage_map_start0
- stage_map_end224
- stage_map_zoom(null)
- RegionI18n(array)
- 0(array)
- id12
- hash8d56d48ad02e9c2349cf781a40853d7c
- created2018-11-29 11:32:21
- updated2020-10-07 09:55:51
- language_id4
- region_id1
- main_titleAllgäu - Lake Constance
- titleLake Constance to the western Allgäu
- region_content_intro<p>Lindau - Oberreute 34 kilometer</p> <p>Bavaria’s best-loved tourist route starts in the western Allgäu. From Lindau, with its mediterranean feel, the route takes the Rohrach ascent into the Allgäu peaks. This panoramic tour is popular because of the views of the Allgäu and Vorarlberg mountains. The Scheidegg waterfalls and Lindenberg with its hat museum merit a visit.</p>
- region_content<div> <p>A walk around <a href="https://www.deutsche-alpenstrasse.de/en/highlights/lindau" target="_blank">Lindau</a> is the perfect way to get in the mood for your upcoming tour along the German Alpine Road. Now the fun really begins – the seven switchbacks of the Rohrach ascent, which climbs 400 metres on an incline of up to 9 per cent, give you a taste of what’s to come on the German Alpine Road. The Scheidegg waterfalls, one of Bavaria’s most beautiful geological features, are well worth a detour, as is idyllic Waldsee, Germany’s highest moorland swimming lake. The history of the small town of Lindenberg has been shaped by hat making. The first hat factory was founded in the early 19th century during the Biedermeier period. By 1890, there were 34 straw hat manufacturers producing around eight million hats a year. At the beginning of the 20th century, this small town was known as the ‘Little Paris’ of hat fashion.</p> <p>Over the next few kilometres, there’s a procession of fabulous views. Around 1.5 kilometres after the turn off for Liebherr Aerospace, a parking bay offers magnificent views of the Nagelfluhkette mountains – a great photo opportunity. Further along on the ridge between Weiler and Simmerberg, you can enjoy views across the Allgäu and Vorarlberg mountains, and even to the Säntis mountain in Switzerland when the weather is good. The sun-kissed hills, valleys, farms and meadows of the western Allgäu combine to offer an almost cinematic experience.</p> </div>
- image_title_7 Allgäu - Lake Constance
- image_title_9
- image_title_8
- image_title_6 Allgäu - Lake Constance
- image_title_10
- image_title_3 Allgäu - Lake Constance
- image_title_1 Allgäu - Lake Constance
- image_title_5 Allgäu - Lake Constance
- image_title_4 Allgäu - Lake Constance
- image_title_2 Allgäu - Lake Constance
- previous_link
- next_link
- url
- 0(array)
- NextEastRegion(array)
- id3
- hash477349f76651dee3ae23b7de17904f74
- created2016-08-01 17:05:35
- updated2022-04-07 12:29:43
- titleAllgäu Schlosspark
- association Allgäu GmbH
- street Allgäuer Straße 1
- zip_city 87435 Kempten
- phoneTel.: +49 (0) 8323 / 80 25 93 1
- faxFax: +49 (0) 831 / 5 75 37 33
- emailinfo@allgaeu.de
- urlhttp://www.allgaeu.de
- webcam_url_teaserhttps://www.foto-webcam.eu/webcam/tegelberg/current/400.jpg
- webcam_url_detailhttps://www.foto-webcam.eu/webcam/tegelberg/
- url_typeurl
- region_content<p>Von Wertach kommend erreichen Sie den Grüntensee. Vielleicht haben Sie Lust, das Auto für ein paar Stunden gegen ein Rad einzutauschen? Die Rad- und Mountainbike-Arena, ein Gemeinschaftsprojekt der Gemeinden Oy-Mittelberg, Wertach und Nesselwang, bietet mit 15 attraktiven Rundtouren ein breites Tourenangebot. Von der gemütlichen Familienrunde bis zur anspruchsvollen Tagestour ist alles mit dabei.</p> <p>Als besondere Herausforderung warten auf fahrtechnisch versierte und konditionell starke Biker insgesamt über 580 Tourenkilometer und knapp 12.400 Höhenmeter darauf erobert zu werden. Da fühlt sich die ein oder andere Steigung, die aus eigenem Antrieb bewältigt werden muss, doch gleich ganz anders an. Und wenn einen unterwegs der Hunger plagt: wie wäre es mit einer ordentlichen Portion Allgäuer Käsespätzle?</p> <p><a href="http://www.deutsche-alpenstrasse.de/de/highlights/pfronten">Pfronten</a>, nach Nesselwang der nächste Ort auf unserer Strecke, hat sich ganz den Heilkräften des Heus verschrieben. Es stammt ausschließlich von über 900 Metern gelegenen Bergwiesen, die weder beweidet noch gedüngt werden. Die schier unerschöpfliche Heilkraft des Bergwiesenheus mit über 70 verschiedenen Kräutern, Gräsern und Heilpflanzen entfaltet sich auf unterschiedlichste Weise. Vielleicht versuchen Sie mal eine Heustempel Massage, um Ihre Muskeln wieder zu lockern?</p> <p>Weißensee, Hopfensee, Forggensee - entlang der Deutschen Alpenstraße haben Sie immer wieder Gelegenheit zu einem erfrischenden Sprung ins kühle Nass. Und im Gegensatz zu den Bergen, wo die Sonne oft recht bald untergeht, können Sie sich hier an schönen Sommerabenden noch lange von den Sonnenstrahlen wärmen lassen.</p> <p>Vom Füssener Land war einst schon König Ludwig II. fasziniert. Folgen Sie seinen Spuren bei einer Führung durch Schloss Hohenschwangau, in dem er einen Großteil seiner Kindheit verbrachte oder dem Schloss Neuschwanstein, dessen Fertigstellung er selbst nicht mehr erleben konnte. Aber vorher sollten Sie sich noch ein bisschen ausführlicher der Stadt <a href="http://www.deutsche-alpenstrasse.de/de/highlights/fuessen" target="_self">Füssen</a> widmen und zu Fuß die romantische Altstadt erkunden.</p>
- map_guid6BA47D64586273F4FDC4A6095070EBC7
- map_link_text_1Etappe auf Karte anzeigen
- map_link_url_1http://ecmaps.de/?hideSearch=true&experience=deutsche-alpenstrasse&inherit=_ecMaps_v5light#q=all%3Aall&lat=47.6052&lon=10.6561&z=12&id=6BA47D64586273F4FDC4A6095070EBC7&type=Tour
- map_link_text_2Alle Etappen auf Karte anzeigen
- map_link_url_2http://ecmaps.de/?hideSearch=true&experience=deutsche-alpenstrasse&inherit=_ecMaps_v5light#q=all%3Aall&lat=47.5348&lon=11.2747&z=9&id=CDF4B633EE7AA683E5D4EADEC6839F55&type=Tour
- region_content_intro<h2>Unterwegs auf königlichen Spuren</h2> <h3>Von Nesselwang nach Halblech</h3> <p><strong>Routenlänge: ca. 35 km</strong></p> <p>Bei der Alpentour durch das Ostallgäu kommen Romantiker voll auf ihre Kosten. Bei einer Führung durch die Schlösser Neuschwanstein und Hohenschwangau oder das Museum der Bayerischen Könige taucht man ein in die Märchenwelt König Ludwigs II. Romantische Stunden lassen sich auch an Weißensee, Hopfensee oder Forggensee verbringen.</p>
- places_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Poi/Route_03%20%20category%3A%22Tourist-Informationen%22/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- hotels_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Gastgeber/route_03/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- tips_et4https://pages.et4.de/de/deutsche-alpenstrasse/default/search/Poi/Route_03%20%20highlight%3A%22true%22/view:list/sort:title/hideSearchForm:1?i_target=et4pages
- next_linkhttps://www.deutsche-alpenstrasse.de/de/route/zugspitz-region
- previous_linkhttps://www.deutsche-alpenstrasse.de/de/route/allgaeuer-gipfelwelten
- prev_west_region_id2
- next_east_region_id4
- stage_map_start607
- stage_map_end812
- stage_map_zoom(null)
- RegionI18n(array)
- 0(array)
- id14
- hash5da13115c361e03c699a94f3a45e6320
- created2019-01-28 11:36:11
- updated2020-10-07 09:59:55
- language_id4
- region_id3
- main_titleRoyal Allgäu
- titleOn the trail of kings
- region_content_intro<h3>Nesselwang - Halblech 42 kilometer</h3> <p>There is plenty to delight romantics on this Alpine tour through the eastern Allgäu. Step into the fairytale world of King Ludwig II on a tour of the castles of Neuschwanstein and Hohenschwangau or visit the Museum of the Bavarian Kings. Three lakes, Weissensee, Hopfensee and Forggensee, also offer romantic picture-book scenery.</p>
- region_content<div> <p>From Wertach we reach Grüntensee lake, where perhaps we could swap four wheels for two for a few hours? The cycling and mountain biking arena is a joint project of the communities Oy-Mittelberg, Wertach and Nesselwang, offering a wide range of 15 attractive tours: from gentle family oriented tours to demanding full-day epics for technically savvy and physically strong bikers. There are 580 km of trails with over 12,000 m / 40,000 ft of ascent waiting to be conquered. As a result, one or another incline may feel quite different when you have to do it under your own steam. Such cycling demands a hearty appetite, and what could be more satisfying than an Allgäu cheese spätzle?</p> <p>A subject you are certain to come across in the Allgäu is cheese; along our route are plenty of opportunities to learn more about the cheese making process, and of-course sample the produce.</p> <p><a href="https://www.deutsche-alpenstrasse.de/en/highlights/pfronten" target="_blank">Pfronten</a>, the next village after Nesselwang, has become devoted to the healing powers of hay; this comes exclusively from mountain meadows, more than 900 m / 3,000 ft in altitude, which are neither grazed nor fertilized. The inexhaustible healing power of mountain meadow hay with over 70 different herbs, grasses and medicinal plants has many different usages. Maybe take a 'hay stamp' massage to loosen up those drivers' muscles again!</p> <p>The lakes Weissensee, Hopfensee and Forggensee line the German Alpine Road providing numerous opportunities for a refreshing dip in cool water. Contrasting to the mountain areas where the sun often hides earlier than expected, these lakes allow us to bask in glorious rays late into summer evenings.</p> <p>From <a href="https://www.deutsche-alpenstrasse.de/en/highlights/fuessen" target="_blank">Füssen</a>, which once fascinated King Ludwig II, we follow in his footsteps on a tour through Hohenschwangau Castle, where he spent much of his childhood. Overlooking the area is Neuschwanstein castle, whose completion he himself did not live to see. But before all of that we focus a bit more on the town of Füssen itself.</p> </div>
- image_title_7Royal Allgäu
- image_title_9
- image_title_8
- image_title_6Royal Allgäu
- image_title_10
- image_title_3Royal Allgäu
- image_title_1Royal Allgäu
- image_title_5Royal Allgäu
- image_title_4Royal Allgäu
- image_title_2Royal Allgäu
- previous_link
- next_link
- url
- 0(array)
- RegionI18n(array)
- 0(array)
- id13
- hash7164e97d3802a8f0f066e4f774498a92
- created2018-11-29 11:38:12
- updated2020-10-07 09:57:05
- language_id4
- region_id2
- main_titleAllgäu Alps
- titleTwists and turns on Oberjoch Pass
- region_content_intro<h3>Oberreute - Nesselwang 61 kilometer</h3> <p>The Upper Allgäu tour runs through Oberstaufen, passing Grosser Alpsee lake, as well as Immenstadt, Sonthofen and Bad Hindelang, before following the Oberjoch Pass towards Wertach. The Oberjoch Pass is one of Bavaria's most popular scenic drives. Whether you're in an open-top car or on a motorbike, it offers an exhilarating drive with 105 bends.</p>
- region_content<p>The view point at 'Paradise' owes its name to the fantastic panoramic views of the Nagelfluhkette national park, the Vorarlberg (Austrian region) and the Swiss Alps. We continue to Oberstaufen. Visitors love the wide range of health offerings and leisure activities available here, as well as the quality and quantity of exceptional hotels and restaurants.</p> <p>From Oberstaufen we first come to the Großen Alpsee lake, then to Immenstadt - an old royal city with a castle, many lovely squares and tourist attractions. Via Sonthofen and <a href="https://www.deutsche-alpenstrasse.de/en/highlights/bad-hindelang" target="_blank">Bad Hindelang</a> we approach the most winding road in Germany: the Oberjoch pass road, which dates back to the Middle Ages.</p> <p>The Oberjoch pass was an important trade route over the Alps. In the year 1662, the pass road saw the transportation of 15,850 barrels of salt (each barrel weighing circa 280 kg / 600 lbs) with no fewer than 300 horses working the road each day. That was major traffic for its time and led to regional prosperity.</p> <p>In 1895 the construction of the new road began, designed to handle heavier traffic with a wider breadth and lower gradient. The 300 m / 1,000 ft difference in height from Hindelang to Oberjoch was bridged with 106 bends. The integration of the road into the countryside was done so well that today the Oberjoch pass road is perceived as much part of the countryside as the adjacent mountains and villages.</p> <p>So, buckle up and go! But don't miss the viewing platform just before the summit (looking back down the valley) as on the other side the descent to Wertach is gentle and through meadows.</p>
- image_title_7
- image_title_9
- image_title_8
- image_title_6Allgäu Alps
- image_title_10
- image_title_3Allgäu Alps
- image_title_1Allgäu Alps
- image_title_5Allgäu Alps
- image_title_4Allgäu Alps
- image_title_2Allgäu Alps
- previous_link
- next_link
- url
- 0(array)
- GalleryMedia(array)
- 0(array)
- id38
- hash879530ce0d190ee2b6d530379d0245bc
- created2016-09-23 19:12:44
- updated2017-02-20 09:22:00
- titleDer Jochpass ist eine der kurvenreichsten Passstraßen - Bild: Bad Hindelang Tourismus/Wolfgang B. Kleiner
- cross_reference_count4
- MediaEntity(array)
- id10652
- pos1
- media_id38
- modelRegion
- fieldgallery
- foreign_key2
- FileUpload(array)
- 0(array)
- id4773
- hash02fcfeb3fc238081fa27c31cefc51548
- created2016-12-08 16:02:39
- updated2016-12-08 16:02:40
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/58497610a67bf.jpg
- size329578
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id4774
- hashc75637e63ad19889087726da6bcec0ea
- created2016-12-08 16:02:40
- updated2016-12-08 16:02:40
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id4773
- filewebroot/files/Media/File/ThMediaFileIndex/58497610aacb2.jpg
- size15416
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 2(array)
- id4775
- hash028cf0c0bbf4e72526e4991aa7e022ba
- created2016-12-08 16:02:40
- updated2016-12-08 16:02:40
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id4773
- filewebroot/files/Media/File/CkeditorXs/58497610cd02b.jpg
- size4779
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 3(array)
- id4776
- hash5c8cab05faa31ef184e8f21e38b24d4d
- created2016-12-08 16:02:41
- updated2016-12-08 16:02:41
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id4773
- filewebroot/files/Media/File/CkeditorSm/58497610ec9bc.jpg
- size15416
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 4(array)
- id4777
- hash676a37cb3c50a67a5fd03aa7136da8a2
- created2016-12-08 16:02:41
- updated2016-12-08 16:02:41
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id4773
- filewebroot/files/Media/File/CkeditorMd/584976111898d.jpg
- size24924
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 5(array)
- id4778
- hash0d81421df3adc2ea947604f105c5ec64
- created2016-12-08 16:02:41
- updated2016-12-08 16:02:41
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id4773
- filewebroot/files/Media/File/CkeditorLg/58497611385ed.jpg
- size54237
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 6(array)
- id9924
- hashfba6feff1f4356398a73f3b8e64badfd
- created2018-05-09 10:04:11
- updated2018-05-09 10:04:11
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-thteaserimagexs.jpg
- thumbnailth-teaser-image-xs
- parent_id4773
- filewebroot/files/Media/File/ThTeaserImageXs/5af2ab7b40362.jpg
- size26743
- ext.jpg
- mimeimage/jpeg
- width350
- height262
- 7(array)
- id9925
- hash1908844e620047c5b2b8b6e3316a586a
- created2018-05-09 10:04:11
- updated2018-05-09 10:04:11
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-thteaserimagelandingpage.jpg
- thumbnailth-teaser-image-landingpage
- parent_id4773
- filewebroot/files/Media/File/ThTeaserImageLandingpage/5af2ab7b69f68.jpg
- size862847
- ext.jpg
- mimeimage/jpeg
- width1673
- height611
- 8(array)
- id17364
- hashc36906bb4301d80fc22c92934973d75c
- created2021-07-05 09:31:32
- updated2021-07-05 09:31:32
- modelMedia
- fieldfile
- foreign_key38
- aliasallgaeuer-gipfelwelten-hindelang-jochpass-copyright-bad-hindelang-web-thregiongalleryresponsive.jpg
- thumbnailth-region-gallery-responsive
- parent_id4773
- filewebroot/files/Media/File/ThRegionGalleryResponsive/60e2b553cfdba.jpg
- size95033
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 1(array)
- id39
- hash8e4baa49ab7c88a1856b17ac7599618e
- created2016-09-23 19:15:51
- updated2016-12-08 16:02:54
- titleDie Berge um Bad Hindelang laden ein zum Wandern und Klettern - Bild: Allgäu Marketing
- cross_reference_count4
- MediaEntity(array)
- id10653
- pos2
- media_id39
- modelRegion
- fieldgallery
- foreign_key2
- FileUpload(array)
- 0(array)
- id4779
- hash9f4eddf9aac46aac456b09f47878ea47
- created2016-12-08 16:02:52
- updated2016-12-08 16:02:54
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5849761e277cd.jpg
- size321145
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id4780
- hash584a989c19159ba15f7fdf6f8a78bce8
- created2016-12-08 16:02:54
- updated2016-12-08 16:02:54
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id4779
- filewebroot/files/Media/File/ThMediaFileIndex/5849761e2b2f5.jpg
- size14999
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 2(array)
- id4781
- hash1917023c9a7396ce347344e6e4712153
- created2016-12-08 16:02:54
- updated2016-12-08 16:02:54
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id4779
- filewebroot/files/Media/File/CkeditorXs/5849761e4eacd.jpg
- size4561
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 3(array)
- id4782
- hash1846a805e7528c01b33ca2a6743d9f9e
- created2016-12-08 16:02:54
- updated2016-12-08 16:02:54
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id4779
- filewebroot/files/Media/File/CkeditorSm/5849761e7cf59.jpg
- size14999
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 4(array)
- id4783
- hash2d20a447140b17d58f365484c69518ce
- created2016-12-08 16:02:54
- updated2016-12-08 16:02:54
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id4779
- filewebroot/files/Media/File/CkeditorMd/5849761ea4d67.jpg
- size24097
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 5(array)
- id4784
- hash8b1265592aab9d7413b217269a95cd41
- created2016-12-08 16:02:54
- updated2016-12-08 16:02:54
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id4779
- filewebroot/files/Media/File/CkeditorLg/5849761ec8815.jpg
- size52898
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 6(array)
- id17365
- hash7bdd6496c8fe5e8685b92d9a104adfad
- created2021-07-05 09:31:32
- updated2021-07-05 09:31:32
- modelMedia
- fieldfile
- foreign_key39
- aliasallgaeuer-gipfelwelten-ort-bad-hindelang-copyright-allgaeu-marketing-web-thregiongalleryresponsive.jpg
- thumbnailth-region-gallery-responsive
- parent_id4779
- filewebroot/files/Media/File/ThRegionGalleryResponsive/60e2b55482808.jpg
- size83197
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 2(array)
- id40
- hash5cda0d24d6c16d3aa1d704eca7d0d712
- created2016-09-23 19:18:48
- updated2016-12-08 16:03:11
- titleDer Große Alpsee am Weg von Oberstaufen nach Immenstadt - Bild: Immenstadt
- cross_reference_count6
- MediaEntity(array)
- id10654
- pos3
- media_id40
- modelRegion
- fieldgallery
- foreign_key2
- FileUpload(array)
- 0(array)
- id4785
- hash5b109e6e23bbb27c1c822c7d813582a0
- created2016-12-08 16:03:08
- updated2016-12-08 16:03:11
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5849762fb02fe.jpg
- size329600
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id19721
- hashacb27c2b7746e90ceba6d6574d5206d5
- created2022-05-02 12:56:18
- updated2022-05-02 12:56:18
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-thseoimagefacebook.png
- thumbnailth-seo-image-facebook
- parent_id4785
- filewebroot/files/Media/File/ThSeoImageFacebook/626fb8d1e9eef.png
- size2195113
- ext.png
- mimeimage/png
- width1500
- height843
- 2(array)
- id19722
- hash96391eff87b7b45f61f4167796ca2500
- created2022-05-02 12:56:19
- updated2022-05-02 12:56:19
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-thseoimagegoogle.png
- thumbnailth-seo-image-google
- parent_id4785
- filewebroot/files/Media/File/ThSeoImageGoogle/626fb8d285509.png
- size2195113
- ext.png
- mimeimage/png
- width1500
- height843
- 3(array)
- id19723
- hash9cd15e4e89e29cec520f5518db2b0d1c
- created2022-05-02 12:56:19
- updated2022-05-02 12:56:19
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-thseoimagetwitter.png
- thumbnailth-seo-image-twitter
- parent_id4785
- filewebroot/files/Media/File/ThSeoImageTwitter/626fb8d318243.png
- size155329
- ext.png
- mimeimage/png
- width375
- height210
- 4(array)
- id4786
- hash736f2456e49257315adeea10f6f392b2
- created2016-12-08 16:03:11
- updated2016-12-08 16:03:11
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id4785
- filewebroot/files/Media/File/ThMediaFileIndex/5849762fb44d2.jpg
- size14719
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 5(array)
- id4787
- hash99582ffd7ed75e92a0b98c5c38f22467
- created2016-12-08 16:03:12
- updated2016-12-08 16:03:12
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id4785
- filewebroot/files/Media/File/CkeditorXs/5849762fdabe9.jpg
- size4575
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 6(array)
- id4788
- hashe7528f26afad005a0f60554ce36aef73
- created2016-12-08 16:03:12
- updated2016-12-08 16:03:12
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id4785
- filewebroot/files/Media/File/CkeditorSm/5849763005b6e.jpg
- size14719
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id4789
- hashb642445f225e5c8280afb70ee86f36bd
- created2016-12-08 16:03:12
- updated2016-12-08 16:03:12
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id4785
- filewebroot/files/Media/File/CkeditorMd/5849763026666.jpg
- size23783
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 8(array)
- id4790
- hash89cc4fa97837103fd0b3c6745df21a89
- created2016-12-08 16:03:12
- updated2016-12-08 16:03:12
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id4785
- filewebroot/files/Media/File/CkeditorLg/5849763045c6f.jpg
- size52107
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 9(array)
- id17366
- hash51015c1b3cdcd73d1c431305969f2754
- created2021-07-05 09:31:32
- updated2021-07-05 09:31:32
- modelMedia
- fieldfile
- foreign_key40
- aliasallgauer-gipfelwelten-immenstadt-grosser-alpsee-copyright-immenstadt-web-thregiongalleryresponsive.jpg
- thumbnailth-region-gallery-responsive
- parent_id4785
- filewebroot/files/Media/File/ThRegionGalleryResponsive/60e2b554c036e.jpg
- size95591
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 3(array)
- id41
- hashc1c25f1cdc406e072ce39bdb0a4b6333
- created2016-09-23 19:21:15
- updated2016-12-08 16:03:41
- titleBlick über Oberreute auf den Hochgrat - Bild: Oberreute
- cross_reference_count4
- MediaEntity(array)
- id10655
- pos4
- media_id41
- modelRegion
- fieldgallery
- foreign_key2
- FileUpload(array)
- 0(array)
- id4791
- hashd791ba46ba05a88c5d0e7f80f6633f5f
- created2016-12-08 16:03:34
- updated2016-12-08 16:03:41
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5849764d372e0.jpg
- size327936
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id4792
- hashcf7f67eaa41b753d08c4e7eb19ff8e04
- created2016-12-08 16:03:41
- updated2016-12-08 16:03:41
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id4791
- filewebroot/files/Media/File/ThMediaFileIndex/5849764d3ae7d.jpg
- size12962
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 2(array)
- id4793
- hash04e5b71ea61cdb52960dd9f0794f6309
- created2016-12-08 16:03:41
- updated2016-12-08 16:03:41
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id4791
- filewebroot/files/Media/File/CkeditorXs/5849764d5d41c.jpg
- size4106
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 3(array)
- id4794
- hashe08b1b00246f1ddde8cab2751bfebfd7
- created2016-12-08 16:03:41
- updated2016-12-08 16:03:41
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id4791
- filewebroot/files/Media/File/CkeditorSm/5849764d7cb34.jpg
- size12962
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 4(array)
- id4795
- hash263f2952d7b4603cd9e89540be3ed468
- created2016-12-08 16:03:41
- updated2016-12-08 16:03:41
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id4791
- filewebroot/files/Media/File/CkeditorMd/5849764da8586.jpg
- size20843
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 5(array)
- id4796
- hash78fd4d65d779c3d5b4df94df3cfcf7bb
- created2016-12-08 16:03:42
- updated2016-12-08 16:03:42
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id4791
- filewebroot/files/Media/File/CkeditorLg/5849764dd66bf.jpg
- size45188
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 6(array)
- id17367
- hashfdd272d25585e10f8a2925622618331b
- created2021-07-05 09:31:33
- updated2021-07-05 09:31:33
- modelMedia
- fieldfile
- foreign_key41
- aliasallgaeuer-gipfelwelten-blick-auf-hochgrat-copyright-oberreute-web-thregiongalleryresponsive.jpg
- thumbnailth-region-gallery-responsive
- parent_id4791
- filewebroot/files/Media/File/ThRegionGalleryResponsive/60e2b554f1656.jpg
- size63371
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 4(array)
- id42
- hashb37c23c1ee7582f275b6739d595fd356
- created2016-09-23 19:23:53
- updated2016-12-08 16:03:58
- titleUrlaub im Paradies – möglich im Oberstaufener Ortsteil mit dem himmlischen Namen - Bild: Oberstaufen
- cross_reference_count5
- MediaEntity(array)
- id10656
- pos5
- media_id42
- modelRegion
- fieldgallery
- foreign_key2
- FileUpload(array)
- 0(array)
- id4797
- hash70bd4d81f9ce169c5a535f18f74f5d84
- created2016-12-08 16:03:56
- updated2016-12-08 16:03:58
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5849765eeb68c.jpg
- size355766
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id19712
- hash040dbb91b447349f2830f6d605ef55fe
- created2022-05-02 12:52:17
- updated2022-05-02 12:52:17
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-thseoimagefacebook.png
- thumbnailth-seo-image-facebook
- parent_id4797
- filewebroot/files/Media/File/ThSeoImageFacebook/626fb7e0eb400.png
- size2060826
- ext.png
- mimeimage/png
- width1500
- height843
- 2(array)
- id19713
- hash9188c7309ce800d156495e72d9012d1c
- created2022-05-02 12:52:17
- updated2022-05-02 12:52:17
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-thseoimagegoogle.png
- thumbnailth-seo-image-google
- parent_id4797
- filewebroot/files/Media/File/ThSeoImageGoogle/626fb7e177c31.png
- size2060826
- ext.png
- mimeimage/png
- width1500
- height843
- 3(array)
- id19714
- hash2a6eafece86f97c830dc8529d0493288
- created2022-05-02 12:52:18
- updated2022-05-02 12:52:18
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-thseoimagetwitter.png
- thumbnailth-seo-image-twitter
- parent_id4797
- filewebroot/files/Media/File/ThSeoImageTwitter/626fb7e200be7.png
- size142631
- ext.png
- mimeimage/png
- width375
- height210
- 4(array)
- id4798
- hash20b6ef6f3d4ed44adec1ef7d598168d9
- created2016-12-08 16:03:59
- updated2016-12-08 16:03:59
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id4797
- filewebroot/files/Media/File/ThMediaFileIndex/5849765eeff5d.jpg
- size13281
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 5(array)
- id4799
- hash70bfd73db178c051671a65d1578c9c61
- created2016-12-08 16:03:59
- updated2016-12-08 16:03:59
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id4797
- filewebroot/files/Media/File/CkeditorXs/5849765f1e5b8.jpg
- size4130
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 6(array)
- id4800
- hashabe7a5a3b2e86a2180c9a49dea97e1b2
- created2016-12-08 16:03:59
- updated2016-12-08 16:03:59
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id4797
- filewebroot/files/Media/File/CkeditorSm/5849765f3e1f5.jpg
- size13281
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id4801
- hash825504e5b81d31d0b4558fa6b44c3552
- created2016-12-08 16:03:59
- updated2016-12-08 16:03:59
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id4797
- filewebroot/files/Media/File/CkeditorMd/5849765f5ef40.jpg
- size21351
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 8(array)
- id4802
- hash3f3280a8fe3d39a1fd8ba77ee7d7c604
- created2016-12-08 16:03:59
- updated2016-12-08 16:03:59
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id4797
- filewebroot/files/Media/File/CkeditorLg/5849765f822a8.jpg
- size48295
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 9(array)
- id17368
- hash3ff84627ffc6d35e556c0e10f077a75d
- created2021-07-05 09:31:33
- updated2021-07-05 09:31:33
- modelMedia
- fieldfile
- foreign_key42
- aliasallgaeuer-gipfelwelten-oberstaufen-paradies-copyright-oberstaufen-web-thregiongalleryresponsive.jpg
- thumbnailth-region-gallery-responsive
- parent_id4797
- filewebroot/files/Media/File/ThRegionGalleryResponsive/60e2b5552dcf3.jpg
- size87988
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 5(array)
- id43
- hasha7298a388e98cdf94d727dc0d14e529a
- created2016-09-23 19:25:31
- updated2016-12-08 16:04:44
- titleBlick auf Sonthofen und die Allgäuer Hochalpen - Bild: Sonthofen
- cross_reference_count8
- MediaEntity(array)
- id10657
- pos6
- media_id43
- modelRegion
- fieldgallery
- foreign_key2
- FileUpload(array)
- 0(array)
- id4803
- hash54af4486faa72a2ae7ed2106ae9ceac6
- created2016-12-08 16:04:42
- updated2016-12-08 16:04:44
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5849768c83712.jpg
- size310644
- ext.jpg
- mimeimage/jpeg
- width1920
- height1081
- 1(array)
- id19718
- hash77d8ca8647f7a6bdcaa62da86e662474
- created2022-05-02 12:53:53
- updated2022-05-02 12:53:53
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thseoimagefacebook.png
- thumbnailth-seo-image-facebook
- parent_id4803
- filewebroot/files/Media/File/ThSeoImageFacebook/626fb84088fd5.png
- size2130018
- ext.png
- mimeimage/png
- width1500
- height844
- 2(array)
- id19719
- hash46bdebe47c25d80a74f7c62ec6f38d9a
- created2022-05-02 12:53:54
- updated2022-05-02 12:53:54
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thseoimagegoogle.png
- thumbnailth-seo-image-google
- parent_id4803
- filewebroot/files/Media/File/ThSeoImageGoogle/626fb841702db.png
- size2130018
- ext.png
- mimeimage/png
- width1500
- height844
- 3(array)
- id19720
- hasha1bb2108c0c08c88fd56ac37a283a0ab
- created2022-05-02 12:53:54
- updated2022-05-02 12:53:54
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thseoimagetwitter.png
- thumbnailth-seo-image-twitter
- parent_id4803
- filewebroot/files/Media/File/ThSeoImageTwitter/626fb84255ce4.png
- size161707
- ext.png
- mimeimage/png
- width375
- height211
- 4(array)
- id18817
- hash161958a77c88678121c106a7182140e1
- created2022-04-22 10:10:29
- updated2022-04-22 10:10:29
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thteaserimagexs.jpg
- thumbnailth-teaser-image-xs
- parent_id4803
- filewebroot/files/Media/File/ThTeaserImageXs/626262f554145.jpg
- size27307
- ext.jpg
- mimeimage/jpeg
- width350
- height262
- 5(array)
- id18818
- hashef23b7a61ac8c1ae676ed58cd530bd70
- created2022-04-22 10:10:29
- updated2022-04-22 10:10:29
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thteaserimagelandingpage.jpg
- thumbnailth-teaser-image-landingpage
- parent_id4803
- filewebroot/files/Media/File/ThTeaserImageLandingpage/626262f577035.jpg
- size789814
- ext.jpg
- mimeimage/jpeg
- width1673
- height611
- 6(array)
- id4804
- hashb703acbde4f3d96c8dacbc7995d8f1af
- created2016-12-08 16:04:44
- updated2016-12-08 16:04:44
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id4803
- filewebroot/files/Media/File/ThMediaFileIndex/5849768c889b1.jpg
- size15014
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id4805
- hash451c5ecbd088e0fd34ca809cf6324e01
- created2016-12-08 16:04:44
- updated2016-12-08 16:04:44
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id4803
- filewebroot/files/Media/File/CkeditorXs/5849768ca945b.jpg
- size4523
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 8(array)
- id4806
- hash9442d2280f360249f1809eb750909c50
- created2016-12-08 16:04:44
- updated2016-12-08 16:04:44
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id4803
- filewebroot/files/Media/File/CkeditorSm/5849768cca477.jpg
- size15014
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 9(array)
- id4807
- hash06904b120b07888aed8ca637f89d29b7
- created2016-12-08 16:04:45
- updated2016-12-08 16:04:45
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id4803
- filewebroot/files/Media/File/CkeditorMd/5849768ceb2aa.jpg
- size24309
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 10(array)
- id4808
- hash2b0a55d7217ba19765600203948f8650
- created2016-12-08 16:04:45
- updated2016-12-08 16:04:45
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id4803
- filewebroot/files/Media/File/CkeditorLg/5849768d17966.jpg
- size53983
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 11(array)
- id17369
- hash1491b788162185638004c835d59f6be1
- created2021-07-05 09:31:33
- updated2021-07-05 09:31:33
- modelMedia
- fieldfile
- foreign_key43
- aliasallgaeuer-gipfelwelten-sonthofen-copyright-sonthofen-web-thregiongalleryresponsive.jpg
- thumbnailth-region-gallery-responsive
- parent_id4803
- filewebroot/files/Media/File/ThRegionGalleryResponsive/60e2b5555a741.jpg
- size90331
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 0(array)
- RegionPointsForLocations(array)
- 0(array)
- id115
- hash4b62b8a1112a791dcf2aa077f62f7fb9
- created2018-11-02 12:35:17
- updated2022-06-21 12:17:22
- statusactive
- titleOberstaufen
- content_typecity
- categoryTourist-Informationen
- teaser_titleOberstaufen Tourismus
- top_tip(false)
- map_lat47.554352
- map_long10.020797
- streetHugo-von-Königsegg-Straße 8
- zip_code87534
- cityOberstaufen
- phone+49(0)8386 93000
- website_urlhttp://www.oberstaufen.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_link
- gmap_urlhttps://goo.gl/maps/P5d8a84UjLBy93v9A
- external_id100006017
- gmap_zoom7
- fax
- weather_widget_code
- hotels_gastronomy0
- hotels_wellness0
- hotels_parking0
- hotels_car_rental0
- hotels_oldtimer0
- hotels_transfernone
- hotels_car_charging_possibility(false)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental0
- hotels_car_rental_other_de
- hotels_car_rental_other_it
- hotels_car_rental_other_nl
- hotels_car_rental_other_en
- hotels_emobil(false)
- map47.554352;10.020797
- PointsRegionsForLocation(array)
- id884
- region_id2
- point_id115
- position1
- PointI18n(empty)
- TeaserImageUpload(array)
- 0(array)
- id13904
- hashf9f9ccf6a9a3f28c413911c2c072fffb
- created2019-09-12 14:55:11
- updated2019-09-12 14:56:04
- modelPoint
- fieldteaser_image
- foreign_key115
- aliasoberstaufen-fgz-bahnhofstrasse-oberstaufen-tourismus.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/5d7a40641cbf6.jpg
- size389742
- ext.jpg
- mimeimage/jpeg
- width1560
- height1040
- 1(array)
- id13907
- hash069c4a2752ac8da25c8f7c2825f1d130
- created2019-09-12 14:56:04
- updated2019-09-12 14:56:04
- modelPoint
- fieldteaser_image
- foreign_key115
- aliasoberstaufen-fgz-bahnhofstrasse-oberstaufen-tourismus-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id13904
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d7a40641f362.jpg
- size96542
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 1(array)
- id112
- hash202c3958778654d6fe56289eacce9aeb
- created2018-11-02 12:35:15
- updated2019-09-12 15:09:25
- statusactive
- titleImmenstadt
- content_typecity
- categoryTourist-Informationen
- teaser_titleImmenstadt
- top_tip(false)
- map_lat47.569626
- map_long10.193026
- streetSeestraße 10
- zip_code87509
- cityImmenstadt im Allgäu
- phone+49(0)8323 / 9988-77
- website_urlhttps://www.alpsee-gruenten.de/urlaub-im-allgaeu/immenstadt.html
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_link
- gmap_urlhttps://goo.gl/maps/FjqCrGCTVs3SuyPH8
- external_id100028905
- gmap_zoom7
- fax
- weather_widget_code(null)
- hotels_gastronomy(null)
- hotels_wellness(null)
- hotels_parking(null)
- hotels_car_rental(null)
- hotels_oldtimer(null)
- hotels_transfer(null)
- hotels_car_charging_possibility(null)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental(null)
- hotels_car_rental_other_de(null)
- hotels_car_rental_other_it(null)
- hotels_car_rental_other_nl(null)
- hotels_car_rental_other_en(null)
- hotels_emobil(null)
- map47.569626;10.193026
- PointsRegionsForLocation(array)
- id885
- region_id2
- point_id112
- position2
- PointI18n(empty)
- TeaserImageUpload(array)
- 0(array)
- id12354
- hash0fd09a4ecb8fcf411bf61c128cc55b24
- created2018-11-02 12:35:15
- updated2018-11-02 12:35:15
- modelPoint
- fieldteaser_image
- foreign_key112
- aliasimmenstadt.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/5bdc36738d970.jpg
- size133005
- ext.jpg
- mimeimage/jpeg
- width1280
- height720
- 1(array)
- id13420
- hash86e4327e3912658b35b9371593a81f46
- created2019-07-02 17:22:34
- updated2019-07-02 17:22:34
- modelPoint
- fieldteaser_image
- foreign_key112
- aliasimmenstadt-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id12354
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d1b76ba778cb.jpg
- size78458
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 2(array)
- id113
- hash78264b52f3b5e0e3fa2bf7e00d5c7b98
- created2018-11-02 12:35:15
- updated2019-09-12 15:12:21
- statusactive
- titleSonthofen
- content_typecity
- categoryTourist-Informationen
- teaser_titleSonthofen
- top_tip(false)
- map_lat47.513588
- map_long10.281387
- streetRathausplatz 1
- zip_code87527
- citySonthofen
- phone+49(0)8321 615291
- website_urlhttps://www.alpsee-gruenten.de/urlaub-im-allgaeu/sonthofen.html
- region1Allgäu
- region2Allgäu Bodensee
- region3
- booking_link
- gmap_urlhttps://goo.gl/maps/pG3BrsZnNEm3vf2m8
- external_id100021266
- gmap_zoom7
- fax
- weather_widget_code(null)
- hotels_gastronomy(null)
- hotels_wellness(null)
- hotels_parking(null)
- hotels_car_rental(null)
- hotels_oldtimer(null)
- hotels_transfer(null)
- hotels_car_charging_possibility(null)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental(null)
- hotels_car_rental_other_de(null)
- hotels_car_rental_other_it(null)
- hotels_car_rental_other_nl(null)
- hotels_car_rental_other_en(null)
- hotels_emobil(null)
- map47.513588;10.281387
- PointsRegionsForLocation(array)
- id886
- region_id2
- point_id113
- position3
- PointI18n(empty)
- TeaserImageUpload(array)
- 0(array)
- id12356
- hashc0a1579f4697d520ad21c90eff828670
- created2018-11-02 12:35:15
- updated2018-11-02 12:35:16
- modelPoint
- fieldteaser_image
- foreign_key113
- aliassonthofen.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/5bdc367402164.jpg
- size1396372
- ext.jpg
- mimeimage/jpeg
- width2505
- height2041
- 1(array)
- id13421
- hash0432318448a1e842e16f0b7bb544f9cc
- created2019-07-02 17:22:35
- updated2019-07-02 17:22:35
- modelPoint
- fieldteaser_image
- foreign_key113
- aliassonthofen-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id12356
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d1b76baa3efc.jpg
- size98328
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 3(array)
- id110
- hashe1c9dca2e7da4869454aa3810e9b3e27
- created2018-11-02 12:35:14
- updated2022-06-24 10:58:13
- statusactive
- titleBad Hindelang Tourist-Information
- content_typecity
- categoryTourist-Informationen
- teaser_titleBad Hindelang
- top_tip(false)
- map_lat47.505192
- map_long10.372417
- streetUnterer Buigenweg 2
- zip_code87541
- cityBad Hindelang
- phone+49(0)8324 8920
- website_urlhttp://www.badhindelang.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_link
- gmap_urlhttps://goo.gl/maps/5p94phmHzcQsDE5X8
- external_id100021267
- gmap_zoom7
- fax
- weather_widget_code<div id="wcom-6692b5d25df8153c8149352e30c7544f" class="wcom-default w300x250" style="border: 1px solid #CCC; background-color: #FCFCFC; border-radius: 5px"><link rel="stylesheet" href="//cs3.wettercomassets.com/woys/5/css/w.css" media="all"><div class="wcom-city"><a style="color: #000" href="https://www.wetter.com/deutschland/bad-hindelang/DE0000633.html" target="_blank" rel="nofollow" aria-label="Wetter Berlin" title="Wetter Bad Hindelang">Wetter Bad Hindelang</a></div><div id="wcom-6692b5d25df8153c8149352e30c7544f-weather"></div><script type="text/javascript" src="//cs3.wettercomassets.com/woys/5/js/w.js"></script><script type="text/javascript">_wcomWidget({id: 'wcom-6692b5d25df8153c8149352e30c7544f',location: 'DE0000633',format: '300x250',type: 'summary'});</script></div>
- hotels_gastronomy0
- hotels_wellness0
- hotels_parking0
- hotels_car_rental0
- hotels_oldtimer0
- hotels_transfernone
- hotels_car_charging_possibility(false)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental0
- hotels_car_rental_other_de
- hotels_car_rental_other_it
- hotels_car_rental_other_nl
- hotels_car_rental_other_en
- hotels_emobil(false)
- map47.505192;10.372417
- PointsRegionsForLocation(array)
- id887
- region_id2
- point_id110
- position4
- PointI18n(array)
- 0(array)
- id172
- hash2c28f66e04a92d33d0ccfdb269ee39a7
- created2019-05-23 14:46:00
- updated2020-07-24 19:09:13
- language_id4
- point_id110
- country
- introduction_text<h2>The sunniest region in the south of Germany</h2> <p>On alpine terrain, the Alpine road in Bad Hindelang passes the districts Vorderhindelang, Hindelang and Bad Oberdorf, with the turnoff to Hinterstein and leads over the Jochpass, on which 105 bends complete 360 meters of altitude difference, continue past the high-lying districts Oberjoch and Unterjoch.</p>
- detail_text<p>The German Alpine Road passes through Bad Hindelang, the sunniest Alpine region in southern Germany. Winding its way past Vorderhindelang, Hindelang, Bad Oberdorf and the turn-off towards Hinterstein, it takes you over Joch Pass, where the road bridges a 360 metre difference in altitude along 105 bends, and continues past the villages of Oberjoch and Unterjoch.</p> <p>Situated at the heart of the Allgäuer Hochalpen nature conservation area, this region is highly biodiverse and is ideal for active holidaymakers, families and anyone who enjoys life. There are 300km of marked trails and numerous cycle routes that lead through unspoilt nature, three Alpine via ferrata for keen climbers and three cable cars that take visitors up high to enjoy the fabulous views of the valley.</p> <p>The Bad Hindelang PLUS card offers 40 free recreational activities/benefits and is available from participating accommodation providers if you stay at least one night. It can be used, for example, for free rides on the cable car and local buses; it provides free entry to leisure facilities, such as swimming pools, and in winter can even be used as a free ski pass for the entire region. To celebrate its tenth anniversary in May 2020, the card also offers 20 new exclusive experiences such as a <em>kässpatzen</em> cookery course or a mountain bike training session with pro cyclist Nadine Rieder.</p> <p>Bad Hindelang is a climatic health resort and hydrotherapy spa, and its clean air and unspoilt nature are particularly beneficial for allergy sufferers. Since 2011, more than 110 companies throughout the town have been certified allergy-friendly. In 2019, Bad Hindelang was awarded the TÜV product standards regulator’s ‘quality-certified spa resort for allergy sufferers’ seal by the Bavarian Spa Association. The town provides a network of allergy-friendly amenities, including places to stay, eat and shop.</p>
- teaser_text<p>On alpine terrain, the Alpine road in Bad Hindelang passes the districts Vorderhindelang, Hindelang and Bad Oberdorf, with the turnoff to Hinterstein and leads over the Jochpass, on which 105 bends complete 360 meters of altitude difference, continue past the high-lying districts Oberjoch and Unterjoch.</p>
- image_title_1Bad Hindelang
- image_title_2Bad Hindelang
- image_title_3Bad Hindelang
- image_title_4Bad Hindelang
- image_title_5Bad Hindelang
- image_title_6Bad Hindelang
- image_title_7Bad Hindelang
- titleBad Hindelang
- teaser_buttonread more
- previous_url(null)
- Route(array)
- id540
- hash4dd5126ddf4653aa3902df3a739ca8cc
- created2019-05-23 14:46:00
- updated2020-07-24 19:09:13
- modelPointI18n
- foreign_key172
- base/en/
- aliasbad-hindelang
- controllerFrontendPoints.FrontendPoints
- actionpoint
- parent_id4
- lft1996
- rght1997
- route/en/bad-hindelang
- 0(array)
- TeaserImageUpload(array)
- 0(array)
- id18437
- hash6ac5aa1ccedd48d45f8b77ce223fd2bb
- created2021-12-16 15:18:41
- updated2021-12-16 15:18:49
- modelPoint
- fieldteaser_image
- foreign_key110
- aliasallgaeu-marketing-orthindelang-15-copy-1.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/61bb4ac9cdb66.jpg
- size424092
- ext.jpg
- mimeimage/jpeg
- width1920
- height1280
- 1(array)
- id18439
- hash2a3638fec9196efe144ef3e64f99c35c
- created2021-12-16 15:18:50
- updated2021-12-16 15:18:50
- modelPoint
- fieldteaser_image
- foreign_key110
- aliasallgaeu-marketing-orthindelang-15-copy-1-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id18437
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/61bb4ac9d8355.jpg
- size84806
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 4(array)
- id114
- hashcea9887cbb7b52417d98c3324ac23dda
- created2018-11-02 12:35:16
- updated2019-09-13 12:27:40
- statusactive
- titleWertach
- content_typecity
- categoryTourist-Informationen
- teaser_titleWertach (c) David Sünderhauf
- top_tip(false)
- map_lat47.603100
- map_long10.412226
- streetRathausstraße 3
- zip_code87497
- cityWertach
- phone+49 (0)8365 7021 99
- website_urlhttp://www.wertach.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_link
- gmap_urlhttps://goo.gl/maps/Ntbebnjxcf9ge5yy6
- external_id100028938
- gmap_zoom7
- fax
- weather_widget_code(null)
- hotels_gastronomy(null)
- hotels_wellness(null)
- hotels_parking(null)
- hotels_car_rental(null)
- hotels_oldtimer(null)
- hotels_transfer(null)
- hotels_car_charging_possibility(null)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental(null)
- hotels_car_rental_other_de(null)
- hotels_car_rental_other_it(null)
- hotels_car_rental_other_nl(null)
- hotels_car_rental_other_en(null)
- hotels_emobil(null)
- map47.603100;10.412226
- PointsRegionsForLocation(array)
- id888
- region_id2
- point_id114
- position5
- PointI18n(empty)
- TeaserImageUpload(array)
- 0(array)
- id13908
- hashc6cd9ad877806ff5f0591e69d62103b4
- created2019-09-12 15:26:47
- updated2019-09-12 15:27:17
- modelPoint
- fieldteaser_image
- foreign_key114
- aliaswertach-von-david-suenderhauf-3.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/5d7a47b5025ee.jpg
- size397185
- ext.jpg
- mimeimage/jpeg
- width2166
- height1080
- 1(array)
- id13911
- hashec3ea1aee6527f6ac9ca1de0058b504e
- created2019-09-12 15:27:17
- updated2019-09-12 15:27:17
- modelPoint
- fieldteaser_image
- foreign_key114
- aliaswertach-von-david-suenderhauf-3-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id13908
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d7a47b504716.jpg
- size70352
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 0(array)
- RegionPointsForHotels(array)
- 0(array)
- id150
- hash12a171aa3cd67f947cf76d2f92e82758
- created2020-03-30 21:28:08
- updated2021-08-02 16:15:07
- statusactive
- titleAllgäu Sonne
- content_typehotel
- category(null)
- teaser_titleHotel Allgäu Sonne
- top_tip(true)
- map_lat47.550827
- map_long10.013640
- streetStießberg 1
- zip_code87534
- cityOberstaufen
- phone+49 (0)8386 702 0
- website_urlhttp://www.allgaeu-sonne.de
- emailinfo@allgaeu-sonne.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_linkhttps://secure.hotelwebservice.com/reservation/fb/?arrival=2020-10-13&departure=2020-10-14&rooms=1&adults=1&children=0&lang=de&token=allgaeusonne&project=&utm_source=liverate_compare&utm_medium=referral
- gmap_urlhttps://goo.gl/maps/twShi5XJR5QEchy7A
- external_id(null)
- gmap_zoom7
- fax+49 (0)8386 702 7826
- weather_widget_code
- hotels_gastronomy15
- hotels_wellness501
- hotels_parking3
- hotels_car_rental0
- hotels_oldtimer4
- hotels_transferfree
- hotels_car_charging_possibility(true)
- hotels_distance_to_nearest_train_station1.500000
- hotels_bike_rental12
- hotels_car_rental_other_de
- hotels_car_rental_other_it
- hotels_car_rental_other_nl
- hotels_car_rental_other_en
- hotels_emobil(true)
- map47.550827;10.013640
- PointsRegionsForHotel(array)
- id306
- region_id2
- point_id150
- position1
- PointI18n(array)
- 0(array)
- id268
- hash61da83c86f45bd9d424f5dc506a97b1b
- created2020-03-30 21:37:33
- updated2021-06-25 12:26:18
- language_id4
- point_id150
- country
- introduction_text
- detail_text<p>Situated on a sunny, south-facing slope above Oberstaufen, the 5-star Hotel Allgäu Sonne has spectacular views of the Allgäu mountains. And you too can enjoy them in what is probably German's most beautiful hotel gym. On offer every day from Monday to Saturday are up to 8 exercise classes and a guided walk, while relaxation awaits in the spa area featuring two indoor and one outdoor pool, a jacuzzi, a steamroom and a panoramic sauna.</p> <p>The kitchen team specialises in creative regional dishes, and every evening there is live music and dancing. Among our 149 rooms and suites there are 65 single rooms, making Allgäu Sonne the ideal destination for solo travellers and groups of friends.</p>
- teaser_text<p>Oberstaufen</p> <p>Tel. +49 (0)8386 702 0</p> <p>www.allgaeu-sonne.de</p>
- image_title_1
- image_title_2
- image_title_3
- image_title_4
- image_title_5
- image_title_6
- image_title_7
- titleHotel Allgäu Sonne Oberstaufen
- teaser_buttonread more
- previous_url(null)
- Route(array)
- id810
- hash3d45deb737cad6acae5b26a826b81b81
- created2020-03-30 21:37:33
- updated2021-06-25 12:26:18
- modelPointI18n
- foreign_key268
- base/en/
- aliashotel-allgaeu-sonne-oberstaufen
- controllerFrontendPoints.FrontendPoints
- actionpoint
- parent_id4
- lft2054
- rght2055
- route/en/hotel-allgaeu-sonne-oberstaufen
- 0(array)
- TeaserImageUpload(array)
- 0(array)
- id14444
- hashc67843523de1c85854af1b33a31288b0
- created2020-03-30 21:31:54
- updated2020-03-30 21:33:04
- modelPoint
- fieldteaser_image
- foreign_key150
- aliashotel-allgaeu-sonne-fitnesswelt-daemmerung-1.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/5e824970cd94c.jpg
- size924787
- ext.jpg
- mimeimage/jpeg
- width1620
- height1080
- 1(array)
- id14445
- hashfe2800b62f893021cb1719550af2d208
- created2020-03-30 21:33:04
- updated2020-03-30 21:33:04
- modelPoint
- fieldteaser_image
- foreign_key150
- aliashotel-allgaeu-sonne-fitnesswelt-daemmerung-1-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id14444
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5e824970cfc68.jpg
- size64612
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 1(array)
- id151
- hash4837ab41818fd17d2f7745cd0729d1e8
- created2020-03-30 22:08:34
- updated2021-06-21 11:48:55
- statusactive
- titleHotel-Restaurant Adler
- content_typehotel
- category(null)
- teaser_titleHotel Restaurant Adler
- top_tip(false)
- map_lat47.553696
- map_long10.021847
- streetKirchplatz 6
- zip_code87534
- cityOberstaufen
- phoneTel. +49 (0)8386 93 210
- website_urlhttp://www.adler-oberstaufen.de
- emailinfo@adler-oberstaufen.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_linkhttps://onepagebooking.com/restadler?module=public&ratetype=bar&lang=de
- gmap_urlhttps://g.page/Hotel-Adler-Oberstaufen?share
- external_id(null)
- gmap_zoom7
- faxTel. +49 (0)8386 4763
- weather_widget_code
- hotels_gastronomy15
- hotels_wellness496
- hotels_parking5
- hotels_car_rental1
- hotels_oldtimer0
- hotels_transferfree
- hotels_car_charging_possibility(true)
- hotels_distance_to_nearest_train_station0.200000
- hotels_bike_rental0
- hotels_car_rental_other_de
- hotels_car_rental_other_it
- hotels_car_rental_other_nl
- hotels_car_rental_other_en
- hotels_emobil(true)
- map47.553696;10.021847
- PointsRegionsForHotel(array)
- id307
- region_id2
- point_id151
- position2
- PointI18n(array)
- 0(array)
- id272
- hash3e6f8abc8ed3cb04450d2d1d3fe6e3b7
- created2020-03-31 20:37:43
- updated2020-07-13 11:24:38
- language_id4
- point_id151
- country
- introduction_text
- detail_text<p>Hotel-Restaurant Adler offers traditional regional cuisine and a modern, alpine décor. Locals and guests can relax and while away the hours in the informal restaurant or on the large sun terrace.</p> <p>Hotel-Restaurant Adler is the ideal base for a spot of shopping and for enjoying Oberstaufen's night life.</p> <p>Hotel guests are provided with the Oberstaufen PLUS GOLF card, which offers free travel on buses, cable cars and the summer toboggan run, free parking and free admission to the panorama pool, museums and the high ropes course. In winter, it includes free passes for three ski resorts; in summer, it includes free green fees on five courses and 90 holes.</p>
- teaser_text<p>Oberstaufen</p> <p>Tel. +49(0) 8386 93 210</p> <p>www.adler-oberstaufen.de</p>
- image_title_1
- image_title_2
- image_title_3
- image_title_4
- image_title_5
- image_title_6
- image_title_7
- titleHotel Restaurant Adler Oberstaufen
- teaser_buttonread more
- previous_url(null)
- Route(array)
- id814
- hashddefb0d89761c4eab60e6ab195347a17
- created2020-03-31 20:37:43
- updated2020-07-13 11:24:38
- modelPointI18n
- foreign_key272
- base/en/
- aliashotel-restaurant-adler-oberstaufen
- controllerFrontendPoints.FrontendPoints
- actionpoint
- parent_id4
- lft2056
- rght2057
- route/en/hotel-restaurant-adler-oberstaufen
- 0(array)
- TeaserImageUpload(array)
- 0(array)
- id14462
- hash0f1f29fbbb56ed042754b3caa96b288f
- created2020-03-31 20:31:50
- updated2020-03-31 20:32:02
- modelPoint
- fieldteaser_image
- foreign_key151
- aliashotel-restaurant-adler-aussenansicht-sommer-2.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/5e838ca28e7c1.jpg
- size419130
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id14470
- hash823a9ecd489599bcfe00146dbfc0572f
- created2020-03-31 20:32:02
- updated2020-03-31 20:32:02
- modelPoint
- fieldteaser_image
- foreign_key151
- aliashotel-restaurant-adler-aussenansicht-sommer-2-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id14462
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5e838ca28f75e.jpg
- size99621
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 2(array)
- id169
- hash3ce5ad0604ddda76171ec6410547b78a
- created2021-03-13 13:10:45
- updated2021-05-30 14:00:59
- statusactive
- titleBerg- und Aktivhotel Edelsberg GmbH
- content_typehotel
- category(null)
- teaser_titleBerg- und Aktivhotel Edelsberg
- top_tip(false)
- map_lat47.543144
- map_long10.415392
- streetAm Edelsberg 10
- zip_code87541
- cityBad Hindelang
- phone+49 8324 980000
- website_urlhttp://www.hotel-edelsberg.de
- emailinfo@hotel-edelsberg.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_linkhttps://edelsberg.direct-reservation.net/de/accommodation
- gmap_urlhttps://goo.gl/maps/2vWc48LDkujTBU1v5
- external_id(null)
- gmap_zoom7
- fax
- weather_widget_code
- hotels_gastronomy9
- hotels_wellness113
- hotels_parking1
- hotels_car_rental0
- hotels_oldtimer0
- hotels_transfernone
- hotels_car_charging_possibility(true)
- hotels_distance_to_nearest_train_station16.000000
- hotels_bike_rental(null)
- hotels_car_rental_other_de(null)
- hotels_car_rental_other_it(null)
- hotels_car_rental_other_nl(null)
- hotels_car_rental_other_en(null)
- hotels_emobil(null)
- map47.543144;10.415392
- PointsRegionsForHotel(array)
- id308
- region_id2
- point_id169
- position3
- PointI18n(array)
- 0(array)
- id307
- hashf7ace152104bcb0539e531748422a6df
- created2021-03-13 13:18:40
- updated2021-03-20 18:42:20
- language_id4
- point_id169
- country
- introduction_text
- detail_text<p>The hotel is idyllically situated at an altitude of 1,013m, surrounded by a beautiful Alpine landscape in the Allgäu region. In our restaurant, which is furnished in the Alpine style, you can get a real taste of the Allgäu way of life. The best way to enjoy the glorious views across the mountains is from the conservatory or the sun terrace.</p> <p>A wide range of activities are on offer during your stay, including an on-site swimming pool with a sauna, steamroom and infrared cabin. During the hiking season, there are numerous mountain railways to explore in the immediate vicinity and in nearby Tannheim Valley.</p> <p>Free parking is available right outside the hotel.</p> <p>And not to forget the many options for excursions, for example to the royal castles and to the many traditional events such as the <em>Viehscheid</em> cattle drive, the Jochpass classic car rally and many more.</p>
- teaser_text<p>Bad Hindelang</p> <p>Tel. +49 (0)8324 980000</p> <p>www.hotel-edelsberg.de</p>
- image_title_1Berg- und Aktivhotel Edelsberg
- image_title_2Berg- und Aktivhotel Edelsberg
- image_title_3Berg- und Aktivhotel Edelsberg
- image_title_4Berg- und Aktivhotel Edelsberg
- image_title_5Berg- und Aktivhotel Edelsberg
- image_title_6Berg- und Aktivhotel Edelsberg
- image_title_7Berg- und Aktivhotel Edelsberg
- titleBerg- und Aktivhotel Edelsberg
- teaser_buttonweiterlesen
- previous_url(null)
- Route(array)
- id1068
- hashaaed016b2da86ff84f881547322d8fe2
- created2021-03-13 13:18:40
- updated2021-03-20 18:42:21
- modelPointI18n
- foreign_key307
- base/en/
- aliasberg-und-aktivhotel-edelsberg
- controllerFrontendPoints.FrontendPoints
- actionpoint
- parent_id4
- lft2066
- rght2067
- route/en/berg-und-aktivhotel-edelsberg
- 0(array)
- TeaserImageUpload(array)
- 0(array)
- id16804
- hash05500676a3363e260a7cf2201dadad73
- created2021-03-13 13:12:50
- updated2021-03-13 13:13:13
- modelPoint
- fieldteaser_image
- foreign_key169
- aliashotel-edelsberg-aussen-0819-teaser-1.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/604cac59746db.jpg
- size899639
- ext.jpg
- mimeimage/jpeg
- width1400
- height788
- 1(array)
- id16812
- hashabb7be657f8fceb059f1e8575978329e
- created2021-03-13 13:13:13
- updated2021-03-13 13:13:13
- modelPoint
- fieldteaser_image
- foreign_key169
- aliashotel-edelsberg-aussen-0819-teaser-1-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id16804
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/604cac5975720.jpg
- size98721
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 0(array)
- RegionPointsForPOIs(array)
- 0(array)
- id160
- hash469c36dce31fdaa0be7c1ca448a8ae1b
- created2021-03-11 11:53:15
- updated2021-12-16 15:14:27
- statusactive
- titleBergbahnen Oberjoch
- content_typepoi
- category(null)
- teaser_titleBergbahnen Oberjoch
- top_tip(false)
- map_lat47.514397
- map_long10.411186
- streetPassstraße 44
- zip_code87541
- cityBad Hindelang
- phone+49 8324 93399-0
- website_urlhttp://www.bergbahnen-hindelang-oberjoch.de
- region1Allgäu
- region2Allgäu Gipfelwelten
- region3
- booking_link
- gmap_urlhttps://goo.gl/maps/q4uQzYEYiAGYeqGC7
- external_id(null)
- gmap_zoom7
- fax
- weather_widget_code
- hotels_gastronomy0
- hotels_wellness0
- hotels_parking0
- hotels_car_rental0
- hotels_oldtimer0
- hotels_transfernone
- hotels_car_charging_possibility(false)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental0
- hotels_car_rental_other_de
- hotels_car_rental_other_it
- hotels_car_rental_other_nl
- hotels_car_rental_other_en
- hotels_emobil(false)
- map47.514397;10.411186
- PointsRegionsForPois(array)
- id988
- region_id2
- point_id160
- position1
- PointI18n(empty)
- TeaserImageUpload(array)
- 0(array)
- id16703
- hashd31df27eec604cdbb28a339de71a4fb2
- created2021-03-11 11:58:52
- updated2021-03-11 11:59:46
- modelPoint
- fieldteaser_image
- foreign_key160
- aliasbad-hindelang-iselerklettersteig-09221-kopie-teaser.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/6049f82250d43.jpg
- size361905
- ext.jpg
- mimeimage/jpeg
- width1400
- height935
- 1(array)
- id16705
- hash987ca4ac1ce0f0fc9db5c17f63187b4c
- created2021-03-11 11:59:46
- updated2021-03-11 11:59:46
- modelPoint
- fieldteaser_image
- foreign_key160
- aliasbad-hindelang-iselerklettersteig-09221-kopie-teaser-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id16703
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/6049f82252005.jpg
- size67928
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 1(array)
- id171
- hash4cc114c853092b17f9b14a72b094b453
- created2021-07-05 09:27:38
- updated2021-07-05 15:08:53
- statusactive
- titleDie Kräuterquelle
- content_typepoi
- category(null)
- teaser_titleDie Kräuterquelle
- top_tip(true)
- map_lat47.506439
- map_long10.381221
- streetWinkelleitenweg 9
- zip_code87541
- cityBad Hindelang
- phone+49 (0)8324 9738991
- website_urlhttps://www.die-kraeuterquelle.de/
- emaildie-kraeuterquelle@web.de
- region1Allgäu
- region2Allägu Gipfelwelten
- region3
- booking_link
- gmap_url
- external_id(null)
- gmap_zoom7
- fax
- weather_widget_code
- hotels_gastronomy0
- hotels_wellness0
- hotels_parking0
- hotels_car_rental0
- hotels_oldtimer0
- hotels_transfernone
- hotels_car_charging_possibility(false)
- hotels_distance_to_nearest_train_station(null)
- hotels_bike_rental0
- hotels_car_rental_other_de
- hotels_car_rental_other_it
- hotels_car_rental_other_nl
- hotels_car_rental_other_en
- hotels_emobil(false)
- map47.506439;10.381221
- PointsRegionsForPois(array)
- id989
- region_id2
- point_id171
- position2
- PointI18n(empty)
- TeaserImageUpload(array)
- 0(array)
- id17372
- hashb74c13761ae73cc3b33155d0183c90a8
- created2021-07-05 15:06:10
- updated2021-07-05 15:06:12
- modelPoint
- fieldteaser_image
- foreign_key171
- aliaskraeuterquelle-1.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Point/TeaserImage/60e303c4d3f51.jpg
- size1043003
- ext.jpg
- mimeimage/jpeg
- width1697
- height1309
- 1(array)
- id17375
- hash62143ad9b3feb3a8efca7a05672de659
- created2021-07-05 15:06:13
- updated2021-07-05 15:06:13
- modelPoint
- fieldteaser_image
- foreign_key171
- aliaskraeuterquelle-1-thpointteaserresponsive.jpg
- thumbnailth-point-teaser-responsive
- parent_id17372
- filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/60e303c4d5d7b.jpg
- size121419
- ext.jpg
- mimeimage/jpeg
- width750
- height462
- 0(array)
- 0(array)
- Language(array)
- id4
- hash5fdcab58cbf42c343cfcd5bf2d59aa4a
- created2016-07-11 13:49:59
- updated2016-07-11 13:49:59
- titleEnglish
- langiden
- default(false)
- Route(array)
- id214
- hashb55597bbc6f63ccfb8f76a0f7c6b0a77
- created2016-10-26 13:43:14
- updated2019-07-22 11:39:35
- modelContent
- foreign_key94
- base/en/route/allgaeu-alps/
- aliasallgaeu-alps
- controllerFrontendContents.FrontendContents
- actionregions
- parent_id176
- lft1823
- rght1824
- route/en/route/allgaeu-alps/allgaeu-alps
- Seo(array)
- id188
- hash2ebeec234c0455dbfda49e784dda10e9
- created2016-10-26 13:43:14
- updated2019-07-22 11:39:35
- modelContent
- foreign_key94
- title
- description
- author
- tw_creator
- fb_author
- robots3
- internal_keywords
- Content(array)
- allPoints(array)
- 0(array)
- PointI18n(array)
- titleHotel Bayerischer Hof - Reutemann - Seegarten Lindau
- Point(array)
- streetBahnhofplatz 2
- zip_code88131
- cityLindau
- map_lat47.544353
- map_long9.682249
- content_typehotel
- id121
- Route(array)
- route/en/hotel-bayerischer-hof-reutemann-seegarten-lindau
- PointI18n(array)
- 1(array)
- PointI18n(array)
- titleRomantik Hotel Böld Oberammergau
- Point(array)
- streetKönig-Ludwig-Straße 10
- zip_code82487
- cityOberammergau
- map_lat47.594547
- map_long11.064853
- content_typehotel
- id122
- Route(array)
- route/en/romantik-hotel-boeld-oberammergau
- PointI18n(array)
- 2(array)
- PointI18n(array)
- titleParkhotel Egerner Höfe Rottach-Egern
- Point(array)
- streetAribostraße 19–26
- zip_code83700
- cityRottach-Egern
- map_lat47.694313
- map_long11.753752
- content_typehotel
- id123
- Route(array)
- route/en/parkhotel-egerner-hoefe-rottach-egern
- PointI18n(array)
- 3(array)
- PointI18n(array)
- titleRelais & Châteaux Hotel Gut Steinbach Reit im Winkl
- Point(array)
- streetSteinbachweg 10
- zip_code83242
- cityReit im Winkl
- map_lat47.667137
- map_long12.481460
- content_typehotel
- id124
- Route(array)
- route/en/relais-chateaux-hotel-gut-steinbach-reit-im-winkl
- PointI18n(array)
- 4(array)
- PointI18n(array)
- titleLuitpoldpark-Hotel Füssen
- Point(array)
- streetBahnhofstraße 1-3
- zip_code87629
- cityFüssen
- map_lat47.569782
- map_long10.699116
- content_typehotel
- id125
- Route(array)
- route/en/luitpoldpark-hotel-fuessen
- PointI18n(array)
- 5(array)
- PointI18n(array)
- titleNaturhotel Reissenlehen Bischofswiesen
- Point(array)
- streetReissenpoint 11
- zip_code83483
- cityBischofswiesen
- map_lat47.650517
- map_long12.959543
- content_typehotel
- id126
- Route(array)
- route/en/naturhotel-reissenlehen-bischofswiesen
- PointI18n(array)
- 6(array)
- PointI18n(array)
- titleHotel feuriger Tatzlwurm Oberaudorf
- Point(array)
- streetTatzlwurm 1
- zip_code83080
- cityOberaudorf
- map_lat47.672035
- map_long12.084188
- content_typehotel
- id128
- Route(array)
- route/en/hotel-feuriger-tatzlwurm-oberaudorf
- PointI18n(array)
- 7(array)
- PointI18n(array)
- titleStaudacherhof Garmisch-Partenkirchen
- Point(array)
- streetHöllentalstraße 48
- zip_code82467
- cityGarmisch-Partenkirchen
- map_lat47.490105
- map_long11.083594
- content_typehotel
- id129
- Route(array)
- route/en/staudacherhof-garmisch-partenkirchen
- PointI18n(array)
- 8(array)
- PointI18n(array)
- titleHotel Garni Alte Schule Lindau
- Point(array)
- streetAlter Schulplatz 2
- zip_code88131
- cityLindau
- map_lat47.547718
- map_long9.685509
- content_typehotel
- id131
- Route(array)
- route/en/hotel-garni-alte-schule-lindau
- PointI18n(array)
- 9(array)
- PointI18n(array)
- titleHotel Sommer Füssen
- Point(array)
- streetWeidachstraße 74
- zip_code87629
- cityFüssen
- map_lat47.579575
- map_long10.709792
- content_typehotel
- id127
- Route(array)
- route/en/hotel-sommer-fuessen
- PointI18n(array)
- 10(array)
- PointI18n(array)
- titleLindau im Bodensee
- Point(array)
- streetAlfred-Nobel-Platz 1
- zip_code88131
- cityLindau
- map_lat47.544437
- map_long9.681535
- content_typecity
- id106
- Route(array)
- route/en/lindau-im-bodensee
- PointI18n(array)
- 11(array)
- PointI18n(array)
- titleBad Hindelang
- Point(array)
- streetUnterer Buigenweg 2
- zip_code87541
- cityBad Hindelang
- map_lat47.505192
- map_long10.372417
- content_typecity
- id110
- Route(array)
- route/en/bad-hindelang
- PointI18n(array)
- 12(array)
- PointI18n(array)
- titlePfronten
- Point(array)
- streetVilstalstraße 2
- zip_code87459
- cityPfronten
- map_lat47.581738
- map_long10.557170
- content_typecity
- id117
- Route(array)
- route/en/pfronten
- PointI18n(array)
- 13(array)
- PointI18n(array)
- titleFüssen
- Point(array)
- streetKaiser-Maximilian-Platz 1
- zip_code87629
- cityFüssen
- map_lat47.569592
- map_long10.701510
- content_typecity
- id118
- Route(array)
- route/en/fuessen
- PointI18n(array)
- 14(array)
- PointI18n(array)
- titleOberammergau
- Point(array)
- streetEugen-Papst-Str. 9a
- zip_code82487
- cityOberammergau
- map_lat47.596966
- map_long11.063093
- content_typecity
- id77
- Route(array)
- route/en/oberammergau
- PointI18n(array)
- 15(array)
- PointI18n(array)
- titleGarmisch-Partenkirchen
- Point(array)
- streetRichard-Strauss-Platz 2
- zip_code82467
- cityGarmisch-Partenkirchen
- map_lat47.495358
- map_long11.092353
- content_typecity
- id74
- Route(array)
- route/en/garmisch-partenkirchen
- PointI18n(array)
- 16(array)
- PointI18n(array)
- titleBad Tölz
- Point(array)
- streetMax-Höfler-Platz 1
- zip_code83646
- cityBad Tölz
- map_lat47.759148
- map_long11.552682
- content_typecity
- id61
- Route(array)
- route/en/bad-toelz
- PointI18n(array)
- 17(array)
- PointI18n(array)
- titleOberaudorf
- Point(array)
- streetKufsteiner Straße 6
- zip_code83080
- cityOberaudorf
- map_lat47.647148
- map_long12.173195
- content_typecity
- id97
- Route(array)
- route/en/oberaudorf
- PointI18n(array)
- 18(array)
- PointI18n(array)
- titleReit im Winkl
- Point(array)
- streetDorfstraße 38
- zip_code83242
- cityReit im Winkl
- map_lat47.675552
- map_long12.475287
- content_typecity
- id100
- Route(array)
- route/en/reit-im-winkl
- PointI18n(array)
- 19(array)
- PointI18n(array)
- titleScheidegg
- Point(array)
- streetRathausplatz 8
- zip_code88175
- cityScheidegg
- map_lat47.582458
- map_long9.848836
- content_typecity
- id109
- Route(array)
- route/en/scheidegg
- PointI18n(array)
- 20(array)
- PointI18n(array)
- titleRottach-Egern
- Point(array)
- streetNördliche Hauptstraße 9
- zip_code83700
- cityRottach-Egern
- map_lat47.690235
- map_long11.770528
- content_typecity
- id88
- Route(array)
- route/en/rottach-egern
- PointI18n(array)
- 21(array)
- PointI18n(array)
- titleAschau i.Chiemgau
- Point(array)
- streetKampenwandstraße 38
- zip_code83229
- cityAschau i. Chiemgau
- map_lat47.772877
- map_long12.324515
- content_typecity
- id90
- Route(array)
- route/en/aschau-i-chiemgau
- PointI18n(array)
- 22(array)
- PointI18n(array)
- titleAlpenhotel Wittelsbach Ruhpolding
- Point(array)
- streetHauptstraße 48
- zip_code83324
- cityRuhpolding
- map_lat47.762508
- map_long12.646185
- content_typehotel
- id144
- Route(array)
- route/en/alpenhotel-wittelsbach-ruhpolding
- PointI18n(array)
- 23(array)
- PointI18n(array)
- titleReindl´s Partenkirchner Hof
- Point(array)
- streetBahnhofstraße 15
- zip_code82467
- cityGarmisch-Partenkirchen
- map_lat47.492176
- map_long11.101029
- content_typehotel
- id136
- Route(array)
- route/en/reindl-s-partenkirchner-hof
- PointI18n(array)
- 24(array)
- PointI18n(array)
- titleArabella Brauneck Hotel Lenggries
- Point(array)
- streetMünchner Straße 25
- zip_code83661
- cityLenggries
- map_lat47.686405
- map_long11.572733
- content_typehotel
- id140
- Route(array)
- route/en/arabella-brauneck-hotel-lenggries
- PointI18n(array)
- 25(array)
- PointI18n(array)
- titleArabella Alpenhotel am Spitzingsee
- Point(array)
- streetSeeweg 7
- zip_code83727
- citySchliersee-Spitzingsee
- map_lat47.662464
- map_long11.887603
- content_typehotel
- id141
- Route(array)
- route/en/arabella-alpenhotel-am-spitzingsee
- PointI18n(array)
- 26(array)
- PointI18n(array)
- titleHotel zur Post Rohrdorf
- Point(array)
- streetDorfplatz 14
- zip_code83101
- cityRordorf
- map_lat47.797050
- map_long12.169342
- content_typehotel
- id142
- Route(array)
- route/en/hotel-zur-post-rohrdorf
- PointI18n(array)
- 27(array)
- PointI18n(array)
- titleResidenz Heinz Winkler Aschau i.Chiemgau
- Point(array)
- streetKirchplatz 1
- zip_code83229
- cityAschau i. Chiemgau
- map_lat47.779118
- map_long12.321541
- content_typehotel
- id143
- Route(array)
- route/en/residenz-heinz-winkler-aschau-i-chiemgau
- PointI18n(array)
- 28(array)
- PointI18n(array)
- titleHotel Edelweiss Berchtesgaden
- Point(array)
- streetMaximilianstraße 2
- zip_code83471
- cityBerchtesgaden
- map_lat47.631687
- map_long13.002211
- content_typehotel
- id145
- Route(array)
- route/en/hotel-edelweiss-berchtesgaden
- PointI18n(array)
- 29(array)
- PointI18n(array)
- titleBerchtesgaden
- Point(array)
- streetMaximilianstraße 9
- zip_code83471
- cityBerchtesgaden
- map_lat47.631641
- map_long13.002307
- content_typecity
- id66
- Route(array)
- route/en/berchtesgaden
- PointI18n(array)
- 30(array)
- PointI18n(array)
- titleHotel Allgäu Sonne Oberstaufen
- Point(array)
- streetStießberg 1
- zip_code87534
- cityOberstaufen
- map_lat47.550827
- map_long10.013640
- content_typehotel
- id150
- Route(array)
- route/en/hotel-allgaeu-sonne-oberstaufen
- PointI18n(array)
- 31(array)
- PointI18n(array)
- titleHotel Restaurant Adler Oberstaufen
- Point(array)
- streetKirchplatz 6
- zip_code87534
- cityOberstaufen
- map_lat47.553696
- map_long10.021847
- content_typehotel
- id151
- Route(array)
- route/en/hotel-restaurant-adler-oberstaufen
- PointI18n(array)
- 32(array)
- PointI18n(array)
- titleBiohotel Eggensberger Hopfen am See
- Point(array)
- streetEnzensbergstraße 5
- zip_code87629
- cityFüssen-Hopfen am See
- map_lat47.609219
- map_long10.681864
- content_typehotel
- id152
- Route(array)
- route/en/biohotel-eggensberger-hopfen-am-see
- PointI18n(array)
- 33(array)
- PointI18n(array)
- titleHotel Edita Scheidegg
- Point(array)
- streetAm Hammerweiher 3
- zip_code88175
- cityScheidegg
- map_lat47.574139
- map_long9.844586
- content_typehotel
- id154
- Route(array)
- route/en/hotel-edita-scheidegg
- PointI18n(array)
- 34(array)
- PointI18n(array)
- titleAlpenresidenz Buchenhöhe Berchtesgaden
- Point(array)
- streetBuchenhöhe 34-36
- zip_code83471
- cityBerchtesgaden
- map_lat47.630993
- map_long13.065500
- content_typehotel
- id156
- Route(array)
- route/en/alpenresidenz-buchenhoehe-berchtesgaden
- PointI18n(array)
- 35(array)
- PointI18n(array)
- titleMünchen
- Point(array)
- streetHerzog-Wilhelm-Straße 15
- zip_code80331
- cityMünchen
- map_lat48.137627
- map_long11.575748
- content_typecity
- id157
- Route(array)
- route/en/muenchen
- PointI18n(array)
- 36(array)
- PointI18n(array)
- titleBerg- und Aktivhotel Edelsberg
- Point(array)
- streetAm Edelsberg 10
- zip_code87541
- cityBad Hindelang
- map_lat47.543144
- map_long10.415392
- content_typehotel
- id169
- Route(array)
- route/en/berg-und-aktivhotel-edelsberg
- PointI18n(array)
- 0(array)
- isGerman(false)
- $request->data(empty)
- $this->validationErrors(array)
- Route(empty)
- MountPoint(empty)
- Redirect(empty)
- Language(empty)
- Menu(empty)
- MemberGroup(empty)
- Member(empty)
- Parent(empty)
- HeaderImagesMedia(empty)
- MediaEntity(empty)
- LogoIconImageMedia(empty)
- Seo(empty)
- ImageMedia(empty)
- Teaser(empty)
- FileUpload(empty)
- Setting(empty)
- ValueUpload(empty)
- Content(empty)
- ArticleContentMedia(empty)
- GalleryMedia(empty)
- DownloadFileMedia(empty)
- Point(empty)
- CityHotels(empty)
- CityPois(empty)
- Points(empty)
- Region(empty)
- RegionContentMedia(empty)
- RegionContentIntroMedia(empty)
- RegionPointsForLocations(empty)
- RegionPointsForHotels(empty)
- RegionPointsForPOIs(empty)
- RegionI18n(empty)
- PointI18n(empty)
- TeaserImageUpload(empty)
- PrevWestRegion(empty)
- NextEastRegion(empty)
- PointsRegionsForLocation(empty)
- PointsRegionsForHotel(empty)
- PointsRegionsForPois(empty)
- FlagUpload(empty)
- Loaded Helpers(array)
- 0Html
- 1Tree
- 2Upload
- 3Media
- 4Route
- 5Bs3Html
- 6Form
- 7SocialMedia
- 8Embed
- 9Layout
- 10ThirdPartyCookies
- 11Maps
- 12Recaptcha
- 13Number
- 14SimpleGraph
- 15DebugTimer
- 16Toolbar
- 17Session
- 18Js
- 19HtmlToolbar
==== - row(array)
-
Environment +
App Constants
Constant Value MH MH_IP BACKEND_APP_DIR contrance UPLOADS_APP /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/contrance/ UPLOAD_TMP_DIR tmp/uploads/ CakePHP Constants
Constant Value APP /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/ APP_DIR httpdocs APPLIBS /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/Lib/ CACHE /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/tmp/cache/ CAKE /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/contrance/Vendor/Cake/lib/Cake/ CAKE_CORE_INCLUDE_PATH /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/contrance/Vendor/Cake/lib CORE_PATH /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/contrance/Vendor/Cake/lib/ CAKE_VERSION 2.9.0 CSS /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/webroot/css/ CSS_URL css/ DS / FULL_BASE_URL https://www.deutsche-alpenstrasse.de IMAGES /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/webroot/img/ IMAGES_URL img/ JS /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/webroot/js/ JS_URL js/ LOGS /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/tmp/logs/ ROOT /var/www/vhosts/deutsche-alpenstrasse.de TESTS /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/Test/ TMP /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/tmp/ VENDORS /var/www/vhosts/deutsche-alpenstrasse.de/vendors/ WEBROOT_DIR webroot WWW_ROOT /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/webroot/ PHP Environment
Environment Variable Value Php Version 5.6.40 User u884587394958 Home /var/www/vhosts/deutsche-alpenstrasse.de Fcgi Role RESPONDER Redirect Redirect Unique Id YrfxB@eAVJ0MOsG4d4U6uwAAAAo Redirect Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Redirect Redirect Https on Redirect Redirect Status 200 Redirect Unique Id YrfxB@eAVJ0MOsG4d4U6uwAAAAo Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Redirect Https on Redirect Status 200 Unique Id YrfxB@eAVJ0MOsG4d4U6uwAAAAo Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Https on Proxy-nokeepalive 1 Http Host www.deutsche-alpenstrasse.de Http X Real Ip 44.200.40.195 Http X Accel Internal /internal-nginx-static-location Http Connection close Http User Agent CCBot/2.0 (https://commoncrawl.org/faq/) Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Http Accept Language en-US,en;q=0.5 Http If Modified Since Mon, 24 Jan 2022 14:33:06 GMT Http Accept Encoding br,gzip Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin Server Signature Server Software Apache Server Name www.deutsche-alpenstrasse.de Server Addr 85.236.63.140 Server Port 443 Remote Addr 44.200.40.195 Document Root /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs Request Scheme https Context Prefix Context Document Root /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs Server Admin root@localhost Script Filename /var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/webroot/index.php Remote Port 47096 Redirect Url /webroot/en/route/allgaeu-alps/allgaeu-alps Gateway Interface CGI/1.1 Server Protocol HTTP/1.0 Request Method GET Query String Request Uri /en/route/allgaeu-alps/allgaeu-alps Script Name /webroot/index.php Php Self /webroot/index.php Request Time Float 1656221959.0967 Request Time 1656221959 ==== -
Include +
Included Files
Include Paths
- 1/opt/plesk/php/5.6/share/pear
- 2-> /var/www/vhosts/deutsche-alpenstrasse.de/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
- 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
- Config(array)
- 0APP/Config/core.php
- 1APP/Config/bootstrap.php
- 2APP/Config/routes.php
- 3APP/Config/database.php
- 4APP/contrance/Config/database.php
- 5APP/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/Database/Mysql.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.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
- Network(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Network/Http/HttpSocket.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Network/CakeSocket.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
- 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
- View(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- Behavior(array)
- plugins(array)
- Audit(array)
- Behavior(array)
- 0Audit/Model/Behavior/AuditableBehavior.php
- Behavior(array)
- 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/ListBehavior.php
- 11BaseData/Model/Behavior/HabtmBehavior.php
- Model(array)
- BaseTree(array)
- Model(array)
- 0BaseTree/Model/BaseTreeAppModel.php
- Model(array)
- Contents(array)
- Component(array)
- 0Contents/Controller/Component/EyepinApiComponent.php
- Model(array)
- 0Contents/Model/Content.php
- 1Contents/Model/ContentsAppModel.php
- Component(array)
- 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
- Component(array)
- FrontendContents(array)
- Config(array)
- 0FrontendContents/Config/routes.php
- Controller(array)
- 0FrontendContents/Controller/FrontendContentsController.php
- 1FrontendContents/Controller/FrontendContentsAppController.php
- Config(array)
- FrontendMembers(array)
- Config(array)
- 0FrontendMembers/Config/routes.php
- Config(array)
- FrontendUtils(array)
- Config(array)
- 0FrontendUtils/Config/bootstrap.php
- 1FrontendUtils/Config/routes.php
- Plugin(array)
- 0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
- 1FrontendUtils/Vendor/Swiftype/SwiftypeClient.php
- Component(array)
- 0FrontendUtils/Controller/Component/SwiftypeComponent.php
- 1FrontendUtils/Controller/Component/GoogleAnalyticsComponent.php
- 2FrontendUtils/Controller/Component/RecaptchaComponent.php
- Config(array)
- Languages(array)
- Behavior(array)
- 0Languages/Model/Behavior/LanguageBehavior.php
- Model(array)
- 0Languages/Model/Language.php
- 1Languages/Model/LanguagesAppModel.php
- Behavior(array)
- Maps(array)
- Behavior(array)
- 0Maps/Model/Behavior/GeoPositionBehavior.php
- Behavior(array)
- Media(array)
- Behavior(array)
- 0Media/Model/Behavior/MediaBehavior.php
- Model(array)
- 0Media/Model/Media.php
- 1Media/Model/MediaAppModel.php
- 2Media/Model/MediaEntity.php
- Behavior(array)
- Members(array)
- Model(array)
- 0Members/Model/MemberGroup.php
- 1Members/Model/MembersAppModel.php
- 2Members/Model/Member.php
- Model(array)
- Menus(array)
- Model(array)
- 0Menus/Model/Menu.php
- 1Menus/Model/MenusAppModel.php
- Model(array)
- MountPoints(array)
- Model(array)
- 0MountPoints/Model/MountPoint.php
- 1MountPoints/Model/MountPointsAppModel.php
- Model(array)
- 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
- Config(array)
- Points(array)
- Model(array)
- 0Points/Model/Point.php
- 1Points/Model/PointAppModel.php
- 2Points/Model/PointI18n.php
- Model(array)
- Regions(array)
- Config(array)
- 0Regions/Config/bootstrap.php
- Model(array)
- 0Regions/Model/Region.php
- 1Regions/Model/RegionsAppModel.php
- 2Regions/Model/RegionI18n.php
- Config(array)
- 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
- Model(array)
- Seo(array)
- Behavior(array)
- 0Seo/Model/Behavior/SeoBehavior.php
- Model(array)
- 0Seo/Model/Seo.php
- 1Seo/Model/SeoAppModel.php
- Behavior(array)
- Settings(array)
- Component(array)
- 0Settings/Controller/Component/SettingsComponent.php
- Model(array)
- 0Settings/Model/Setting.php
- 1Settings/Model/SettingsAppModel.php
- Component(array)
- Tags(array)
- Behavior(array)
- 0Tags/Model/Behavior/TaggableBehavior.php
- Behavior(array)
- Teasers(array)
- Behavior(array)
- 0Teasers/Model/Behavior/TeaserBehavior.php
- Model(array)
- 0Teasers/Model/Teaser.php
- 1Teasers/Model/TeasersAppModel.php
- Behavior(array)
- 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
- Config(array)
- Audit(array)
====