-
- History
-
Session +
Session
- Config(array)
- userAgentbb9a308b4a34371b6683a620bd245ed7
- time1755202456
- countdown10
- _Token(array)
- keybea9294ed3cb2a62bf8bde260d498ba019b29a03349e9bc7407078623ddc465ebfa802f1cb6e1f9a22f096b25b4cb8ffaf30181cd2d340b26d38c616eb4c9f79
- allowedControllers(empty)
- allowedActions(empty)
- unlockedFields(empty)
- csrfTokens(array)
- bea9294ed3cb2a62bf8bde260d498ba019b29a03349e9bc7407078623ddc465ebfa802f1cb6e1f9a22f096b25b4cb8ffaf30181cd2d340b26d38c616eb4c9f791752612256
==== - Config(array)
-
Request +
Request
Cake Params
- pluginFrontendContents
- controllerFrontendContents
- actionmountain_guide_index
- named(empty)
- pass(array)
- 0905
- ids(array)
- Menu325
- Content905
- Language3
- route(array)
- id1787
- hashaa404e820c3fb5a5477eb542c75e3f2b
- created2017-03-01 15:17:14
- updated2020-12-28 16:33:23
- modelContent
- foreign_key905
- base/wf/watzmannfuehrer/die-watzmannfuehrer/
- aliasstaatl-gepr-berg-und-skifuehrer-ivbv
- controllerFrontendContents.FrontendContents
- actionmountain_guide_index
- parent_id1364
- lft4544
- rght4545
- route/wf/watzmannfuehrer/die-watzmannfuehrer/staatl-gepr-berg-und-skifuehrer-ivbv
- isAjax(false)
- _Token(array)
- keybea9294ed3cb2a62bf8bde260d498ba019b29a03349e9bc7407078623ddc465ebfa802f1cb6e1f9a22f096b25b4cb8ffaf30181cd2d340b26d38c616eb4c9f79
- unlockedFields(empty)
Post data
No post data.
Query string
No querystring data.
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
- keys(empty)
- options(empty)
- defaults(array)
- plugin(null)
- actionindex
- template/*
==== -
Sql Log +
Sql Logs
default
Total Time: 10 ms
Total Queries: 140 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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/watzmannfuehrer/die-watzmannfuehrer/staatl-gepr-berg-und-skifuehrer-ivbv' LIMIT 1 1 1 0 SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 4544 AND `Route`.`rght` >= 4545 ORDER BY `Route`.`lft` asc 6 6 0 SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`languages` AS `Language` WHERE `Language`.`title` = 'www.bergsteigerschule-watzmann.de' LIMIT 1 1 1 0 SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'down_payment_reminder' LIMIT 1 0 0 0 SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'remaining_payment_reminder' LIMIT 1 1 1 0 SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 16 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags' 0 0 0 SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'default' AND `EmailTemplate`.`status_value` = 'warning' LIMIT 1 1 1 0 SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 26 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags' 0 0 0 SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `alpinewelten`.`settings` AS `Setting` LEFT JOIN `alpinewelten`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id` 54 54 0 SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `alpinewelten`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC 1 1 0 SELECT `Menu`.`id`, `Language`.`id` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 325 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL 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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 325 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`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`seo` AS `Seo` WHERE `Seo`.`foreign_key` = 325 AND `Seo`.`model` = 'Menu' 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1346 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`, `Teaser`.`subtitle` FROM `alpinewelten`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 325 AND `Teaser`.`model` = 'Menu' 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 978 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2493) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 9 9 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (325) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 1 1 0 SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (325) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 325 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3575) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 14 14 0 SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 325 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC 0 0 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'faq' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 555 AND `Menu`.`rght` < 556 ORDER BY `Menu`.`lft` asc 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`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, `Content`.`travel_report_id`, `Content`.`travel_report_category`, `Content`.`placeholder_text`, `Content`.`direction`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 905 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1 1 1 1 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1752 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `MountainGuideQualification`.`id`, `MountainGuideQualification`.`hash`, `MountainGuideQualification`.`created`, `MountainGuideQualification`.`updated`, `MountainGuideQualification`.`position`, `MountainGuideQualification`.`title`, `MountainGuideQualification`.`category`, `ContentsMountainGuideQualification`.`id`, `ContentsMountainGuideQualification`.`content_id`, `ContentsMountainGuideQualification`.`mountain_guide_qualification_id` FROM `alpinewelten`.`mountain_guide_qualifications` AS `MountainGuideQualification` JOIN `alpinewelten`.`contents_mountain_guide_qualifications` AS `ContentsMountainGuideQualification` ON (`ContentsMountainGuideQualification`.`content_id` = 905 AND `ContentsMountainGuideQualification`.`mountain_guide_qualification_id` = `MountainGuideQualification`.`id`) ORDER BY `MountainGuideQualification`.`position` ASC 2 2 0 SELECT `MountainGuide`.`id`, `MountainGuide`.`hash`, `MountainGuide`.`created`, `MountainGuide`.`updated`, `MountainGuide`.`mountain_guide_type`, `MountainGuide`.`mountain_guide_salutation`, `MountainGuide`.`mountain_guide_name`, `MountainGuide`.`mountain_guide_lastname`, `MountainGuide`.`mountain_guide_street`, `MountainGuide`.`mountain_guide_zip`, `MountainGuide`.`mountain_guide_city`, `MountainGuide`.`mountain_guide_country`, `MountainGuide`.`mountain_guide_nationality`, `MountainGuide`.`mountain_guide_language`, `MountainGuide`.`mountain_guide_mobile`, `MountainGuide`.`mountain_guide_phone`, `MountainGuide`.`mountain_guide_email`, `MountainGuide`.`mountain_guide_birthday`, `MountainGuide`.`bank_account_holder_lastname`, `MountainGuide`.`bank_account_holder_name`, `MountainGuide`.`bank_account_number`, `MountainGuide`.`bank_code`, `MountainGuide`.`bank_name`, `MountainGuide`.`bank_iban`, `MountainGuide`.`bank_bic`, `MountainGuide`.`tax_number`, `MountainGuide`.`vat_number`, `MountainGuide`.`mountain_guide_education`, `MountainGuide`.`height`, `MountainGuide`.`clothing_comment`, `MountainGuide`.`passport_number`, `MountainGuide`.`id_number`, `MountainGuide`.`comment`, `MountainGuide`.`alpine_club_number`, `MountainGuide`.`adac_number`, `MountainGuide`.`other_insurances`, `MountainGuide`.`youtube`, `MountainGuide`.`emergency_contact_relation`, `MountainGuide`.`emergency_contact_salutation`, `MountainGuide`.`emergency_contact_name`, `MountainGuide`.`emergency_contact_lastname`, `MountainGuide`.`emergency_contact_street`, `MountainGuide`.`emergency_contact_zip`, `MountainGuide`.`emergency_contact_city`, `MountainGuide`.`emergency_contact_country`, `MountainGuide`.`emergency_contact_language`, `MountainGuide`.`emergency_contact_mobile`, `MountainGuide`.`emergency_contact_phone`, `MountainGuide`.`emergency_contact_email`, `MountainGuide`.`firm_id`, `MountainGuide`.`ws_text_content`, `MountainGuide`.`ws_text_motivation`, `MountainGuide`.`ws_text_out_of_apline_hobbies`, `MountainGuide`.`ws_text_personal_information`, `MountainGuide`.`ws_text_additional_qualifications`, `MountainGuide`.`member_id`, `MountainGuide`.`previous_url`, `MountainGuide`.`status`, `MountainGuide`.`exact_shoe_size`, `MountainGuide`.`exact_trousers_size`, `MountainGuide`.`exact_trousers_large`, `MountainGuide`.`exact_jacket_size`, `MountainGuide`.`exact_shirt_size`, `MountainGuide`.`last_api_call`, `MountainGuide`.`tax_country`, `MountainGuide`.`tax_obligation`, `MountainGuide`.`aspirant_contract_hh`, `MountainGuide`.`aspirant_contract_hs`, `MountainGuide`.`wise_card`, `MountainGuide`.`clothing_package_2022`, `MountainGuide`.`clothing_package_2023`, `MountainGuide`.`importance`, `MountainGuide`.`clothing_package_planning_2022`, `MountainGuide`.`clothing_package_planning_2023`, (SELECT GROUP_CONCAT(`Region`.`title`, " ", `MountainGuideDailyRate`.`daily_rate`, " €" SEPARATOR " | ") FROM `alpinewelten`.`mountain_guide_daily_rates` AS `MountainGuideDailyRate` JOIN `alpinewelten`.`regions` AS `Region` ON (`MountainGuideDailyRate`.`region_id` = `Region`.`id`) WHERE `MountainGuideDailyRate`.`mountain_guide_id` = `MountainGuide`.`id`) AS `MountainGuide__daily_rates`, (CONCAT(`MountainGuide`.`mountain_guide_name`, " ", `MountainGuide`.`mountain_guide_lastname`)) AS `MountainGuide__fullname`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`mountain_guides` AS `MountainGuide` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `MountainGuide`.`id` AND `Route`.`model` = 'MountainGuide') JOIN `alpinewelten`.`firms_mountain_guides` AS `FirmsMountainGuide` ON (`FirmsMountainGuide`.`mountain_guide_id` = `MountainGuide`.`id` AND `FirmsMountainGuide`.`firm_id` = '3') WHERE `MountainGuide`.`status` = 'active' AND (SELECT `Qualification`.`mountain_guide_qualification_id` FROM mountain_guide_qualifications_mountain_guides AS Qualification JOIN mountain_guide_qualifications AS Q ON `Q`.`id` = `Qualification`.`mountain_guide_qualification_id` WHERE `Qualification`.`mountain_guide_id` = `MountainGuide`.`id` ORDER BY `Q`.`position` ASC LIMIT 1) IN ('1', '7') GROUP BY `MountainGuide`.`id` ORDER BY FIELD(`MountainGuide`.`mountain_guide_type`, 'core', 'close_circle', 'occasional', 'none'), `MountainGuide`.`mountain_guide_name` ASC 9 9 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1, 43, 111, 8, 34, 196, 153, 140, 167) AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'MountainGuide' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 9 9 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (6525, 9501, 6698, 2778, 6579, 7437, 7432, 3030, 3412) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 88 88 0 SELECT `MountainGuideQualifications`.`id`, `MountainGuideQualifications`.`hash`, `MountainGuideQualifications`.`created`, `MountainGuideQualifications`.`updated`, `MountainGuideQualifications`.`position`, `MountainGuideQualifications`.`title`, `MountainGuideQualifications`.`category`, `MountainGuideQualificationsMountainGuide`.`id`, `MountainGuideQualificationsMountainGuide`.`mountain_guide_qualification_id`, `MountainGuideQualificationsMountainGuide`.`mountain_guide_id`, `MountainGuideQualificationsMountainGuide`.`position` FROM `alpinewelten`.`mountain_guide_qualifications` AS `MountainGuideQualifications` JOIN `alpinewelten`.`mountain_guide_qualifications_mountain_guides` AS `MountainGuideQualificationsMountainGuide` ON (`MountainGuideQualificationsMountainGuide`.`mountain_guide_id` IN (1, 43, 111, 8, 34, 196, 153, 140, 167) AND `MountainGuideQualificationsMountainGuide`.`mountain_guide_qualification_id` = `MountainGuideQualifications`.`id`) ORDER BY `MountainGuideQualifications`.`position` ASC 19 19 0 SELECT `Parent`.`id` FROM `alpinewelten`.`menus` AS `Menu` JOIN `alpinewelten`.`menus` AS `Parent` ON (`Parent`.`lft` <= `Menu`.`lft` AND `Parent`.`rght` >= `Menu`.`rght`) JOIN `alpinewelten`.`media_entities` AS `Media` ON (`Media`.`foreign_key` = `Parent`.`id` AND `Media`.`model` = 'Menu' AND `Media`.`field` = 'header_images') WHERE `Menu`.`id` = 325 ORDER BY `Parent`.`lft` DESC LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll` FROM `alpinewelten`.`menus` AS `Menu` WHERE `Menu`.`id` = 325 LIMIT 1 1 1 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 608 AND `Menu`.`rght` < 653 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 22 22 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (705, 338, 195, 709, 696, 194, 327, 326, 532, 554, 686, 687, 707, 689, 337, 351, 544, 545, 685, 688, 697, 698) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_more' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 654 AND `Menu`.`rght` < 667 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 6 6 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (354, 356, 570, 355, 199, 357) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'wf' LIMIT 1 0 0 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 0 0 0 SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Firm`.`id`, `Firm`.`hash`, `Firm`.`created`, `Firm`.`updated`, `Firm`.`title`, `Firm`.`abbreviation`, `Firm`.`oa_offerer_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`languages` AS `Language` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Language`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1 4 4 0 SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2, 3, 4) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Content' AND `Seo`.`foreign_key` = 905 LIMIT 1 1 1 1 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 600 AND `Menu`.`rght` >= 601 AND `Menu`.`id` NOT IN (32, 2, 3, 33, 165, 167, 168, 169, 183, 188, 196, 197, 654, 702, 704) ORDER BY `Menu`.`lft` asc 2 2 0 SELECT `TourType`.`id`, `TourType`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) WHERE 1 = 1 GROUP BY `TourType`.`id` ORDER BY `TourType`.`title` ASC 40 40 0 SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 184 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 976 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3735) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 9 9 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 621 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (184) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (184) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 184 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 184 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC 0 0 0 SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'text_search' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 740 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5141 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3879 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (740) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (740) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 740 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 740 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC 0 0 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 554 AND `Menu`.`rght` < 559 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 2 2 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (712, 684) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 2 2 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'tour_list' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 560 AND `Menu`.`rght` < 607 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 23 23 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (201, 203, 634, 339, 204, 340, 341, 202, 342, 343, 344, 345, 346, 347, 348, 536, 738, 542, 543, 736, 325, 353, 476) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 20 20 0 SELECT `Highlight`.`id`, `Highlight`.`hash`, `Highlight`.`created`, `Highlight`.`updated`, `Highlight`.`status`, `Highlight`.`type`, `Highlight`.`tour_id`, `Highlight`.`manually_title`, `Highlight`.`manually_text`, `Highlight`.`manually_button_label`, `Highlight`.`manually_link`, `Highlight`.`position`, `Highlight`.`language_id`, `Highlight`.`manually_target_blank`, `Highlight`.`menu_id`, `Highlight`.`teaser_home_header`, `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, `Tour`.`recommendation_extra_overnight_stays`, `Tour`.`backpack_total_weight`, `Tour`.`taxation`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight` FROM `alpinewelten`.`highlights` AS `Highlight` LEFT JOIN `alpinewelten`.`tours` AS `Tour` ON (`Highlight`.`tour_id` = `Tour`.`id`) WHERE `Highlight`.`type` = 'tour' AND `Highlight`.`teaser_home_header` = '1' AND `Highlight`.`language_id` = 3 ORDER BY `position` ASC 6 6 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 146 AND `Route`.`model` = 'Tour' 1 1 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 146 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1526) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 18 18 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 122 AND `Route`.`model` = 'Tour' 1 1 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 122 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2049) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 13 13 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 418 AND `Route`.`model` = 'Tour' 1 1 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 418 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3000) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 16 16 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 125 AND `Route`.`model` = 'Tour' 1 1 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 125 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (7596) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 12 12 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 235 AND `Route`.`model` = 'Tour' 1 1 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 235 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3573) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 15 15 0 SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 293 AND `Route`.`model` = 'Tour' 1 1 0 SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 293 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5549) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 11 11 0 SELECT `TourMainTypes`.`id`, `TourMainTypes`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) JOIN `alpinewelten`.`tour_main_types` AS `TourMainTypes` ON (`TourMainTypes`.`id` = `TourType`.`tour_main_type_id`) WHERE 1 = 1 ORDER BY `TourMainTypes`.`position` ASC 659 659 0 SELECT `Microsite`.`id`, `Microsite`.`hash`, `Microsite`.`created`, `Microsite`.`updated`, `Microsite`.`status`, `Microsite`.`title`, `Microsite`.`url`, `Microsite`.`position`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`microsites` AS `Microsite` LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Microsite`.`id` AND `Teaser`.`model` = 'Microsite') WHERE 1 = 1 5 5 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2951 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (52) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 14 14 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2952 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (459) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 12 12 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2953 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (688) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 9 9 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2954 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5427) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 11 11 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2955 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2275) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 14 14 0 SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'wf' LIMIT 1 0 0 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'wf' LIMIT 1 0 0 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE 1 != 1 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 0 0 0 SELECT `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`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, `Content`.`travel_report_id`, `Content`.`travel_report_category`, `Content`.`placeholder_text`, `Content`.`direction`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 325 AND `Content`.`status` = 'active' LIMIT 1 1 1 8 maybe slow SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1748 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1380 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`abbreviation`, `Country`.`subtitle`, `Country`.`link_embassy_german`, `Country`.`link_embassy_austrian`, `Country`.`link_embassy_swiss`, `Country`.`link_embassy_italian`, `Country`.`best_travel_season`, `Country`.`general`, `Country`.`security`, `Country`.`nature_climate`, `Country`.`travel_info`, `Country`.`entry_customs`, `Country`.`visa`, `Country`.`health`, `Country`.`tours_summer`, `Country`.`tours_winter`, `Country`.`microsite_id`, `ContentsCountry`.`id`, `ContentsCountry`.`content_id`, `ContentsCountry`.`country_id` FROM `alpinewelten`.`countries` AS `Country` JOIN `alpinewelten`.`contents_countries` AS `ContentsCountry` ON (`ContentsCountry`.`content_id` = 901 AND `ContentsCountry`.`country_id` = `Country`.`id`) 0 0 0 SELECT `TourType`.`id`, `TourType`.`hash`, `TourType`.`created`, `TourType`.`updated`, `TourType`.`title`, `TourType`.`oa_categories`, `TourType`.`use_for_mountain_guide_tour_search`, `TourType`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `TourType`.`id`) AS `TourType__tour_count`, `ContentsTourType`.`id`, `ContentsTourType`.`content_id`, `ContentsTourType`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `TourType` JOIN `alpinewelten`.`contents_tour_types` AS `ContentsTourType` ON (`ContentsTourType`.`content_id` = 901 AND `ContentsTourType`.`tour_type_id` = `TourType`.`id`) 0 0 0 SELECT `TourMainType`.`id`, `TourMainType`.`hash`, `TourMainType`.`created`, `TourMainType`.`updated`, `TourMainType`.`title`, `TourMainType`.`position`, `TourMainType`.`packing_list_text_start`, `TourMainType`.`packing_list_text_end`, `ContentsTourMainType`.`id`, `ContentsTourMainType`.`content_id`, `ContentsTourMainType`.`tour_main_type_id` FROM `alpinewelten`.`tour_main_types` AS `TourMainType` JOIN `alpinewelten`.`contents_tour_main_types` AS `ContentsTourMainType` ON (`ContentsTourMainType`.`content_id` = 901 AND `ContentsTourMainType`.`tour_main_type_id` = `TourMainType`.`id`) 0 0 0 SELECT `MountainGuideQualification`.`id`, `MountainGuideQualification`.`hash`, `MountainGuideQualification`.`created`, `MountainGuideQualification`.`updated`, `MountainGuideQualification`.`position`, `MountainGuideQualification`.`title`, `MountainGuideQualification`.`category`, `ContentsMountainGuideQualification`.`id`, `ContentsMountainGuideQualification`.`content_id`, `ContentsMountainGuideQualification`.`mountain_guide_qualification_id` FROM `alpinewelten`.`mountain_guide_qualifications` AS `MountainGuideQualification` JOIN `alpinewelten`.`contents_mountain_guide_qualifications` AS `ContentsMountainGuideQualification` ON (`ContentsMountainGuideQualification`.`content_id` = 901 AND `ContentsMountainGuideQualification`.`mountain_guide_qualification_id` = `MountainGuideQualification`.`id`) 0 0 0 SELECT `TourDate`.`id`, `TourDate`.`hash`, `TourDate`.`created`, `TourDate`.`updated`, `TourDate`.`status`, `TourDate`.`tour_id`, `TourDate`.`tour_date_number`, `TourDate`.`title`, `TourDate`.`subtitle`, `TourDate`.`participants_min`, `TourDate`.`participants_max`, `TourDate`.`duration_days`, `TourDate`.`tour_price`, `TourDate`.`down_payment`, `TourDate`.`saison`, `TourDate`.`travel_insurance_certificate`, `TourDate`.`rating_condition`, `TourDate`.`rating_technique`, `TourDate`.`rating_experience`, `TourDate`.`rating_difficulty_category`, `TourDate`.`start_zip`, `TourDate`.`start_city`, `TourDate`.`start_street`, `TourDate`.`start_country`, `TourDate`.`start_meeting_point`, `TourDate`.`start_time`, `TourDate`.`end_alternate_address`, `TourDate`.`end_time`, `TourDate`.`flight`, `TourDate`.`flight_details`, `TourDate`.`region_id`, `TourDate`.`date_start`, `TourDate`.`mountain_guide_status`, `TourDate`.`manual_booking_status`, `TourDate`.`participant_list_visible`, `TourDate`.`speciality`, `TourDate`.`special_features`, `TourDate`.`mountain_guide_tour_info`, `TourDate`.`customer_tour_info`, `TourDate`.`ws_text_requirements`, `TourDate`.`ws_text_travel_program`, `TourDate`.`ws_text_accomodation`, `TourDate`.`ws_text_services`, `TourDate`.`rating_seriousness`, `TourDate`.`rating_overall_score`, `TourDate`.`infotext_booking`, `TourDate`.`last_minute`, `TourDate`.`travel_information`, `TourDate`.`meeting_point_map_lat`, `TourDate`.`meeting_point_map_marker`, `TourDate`.`meeting_point_map_type`, `TourDate`.`meeting_point_map_zoom`, `TourDate`.`meeting_point_map_long`, `TourDate`.`participant_list_visible2`, `TourDate`.`cancelled`, `TourDate`.`days_before_start_for_last_notice`, `TourDate`.`execution_feasibility`, `TourDate`.`days_before_start_for_cancellation`, `TourDate`.`ws_text_overview`, `TourDate`.`mountain_guide_tour_search_information`, `TourDate`.`allow_double_assignment`, `TourDate`.`customer_tour_material_info`, `TourDate`.`material_list_link`, `TourDate`.`minimum_reached_notification`, `TourDate`.`c19_cancellation`, `TourDate`.`ws_text_course_content`, `TourDate`.`ws_text_information`, `TourDate`.`gmap_marker`, `TourDate`.`ws_text_short_description`, `TourDate`.`gmap_type`, `TourDate`.`gmap_zoom`, `TourDate`.`ws_text_location_description`, `TourDate`.`ws_text_detail_description`, `TourDate`.`gmap_lat`, `TourDate`.`gmap_long`, `TourDate`.`callout_icon_multiple`, `TourDate`.`ws_text_advantages`, `TourDate`.`ws_text_detail_description_new`, `TourDate`.`ws_text_information_new`, `TourDate`.`ws_text_accomodation_new`, `TourDate`.`rental_equipment_checked`, `TourDate`.`rental_equipment_check_notice`, `TourDate`.`ws_text_arrival`, (CONCAT_WS (',',`TourDate`.`gmap_lat`,`TourDate`.`gmap_long`)) AS `TourDate__gmap`, (CONCAT_WS (',',`TourDate`.`meeting_point_map_lat`,`TourDate`.`meeting_point_map_long`)) AS `TourDate__meeting_point_map`, (COALESCE(`TourDate`.`end_zip`, `TourDate`.`start_zip`)) AS `TourDate__end_zip`, (COALESCE(`TourDate`.`end_city`, `TourDate`.`start_city`)) AS `TourDate__end_city`, (COALESCE(`TourDate`.`end_street`, `TourDate`.`start_street`)) AS `TourDate__end_street`, (COALESCE(`TourDate`.`end_country`, `TourDate`.`start_country`)) AS `TourDate__end_country`, (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) AS `TourDate__date_end`, (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')) AS `TourDate__count_participants`, (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`) AS `TourDate__count_mountain_guides`, (`TourDate`.`date_start` <= "2025-09-30" AND (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) >= "2025-06-01") AS `TourDate__peak_season`, (SELECT `TourForServiceEvent`.`is_service_event` FROM tours AS TourForServiceEvent WHERE `TourForServiceEvent`.`id` = `TourDate`.`tour_id`) AS `TourDate__is_service_event`, (CONCAT((SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')), " + " , (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`))) AS `TourDate__participants_booked`, (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "bookings_present" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= 1 ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = 0 ) THEN 0 END)))WHEN 0 THEN "places_free" WHEN 1 THEN "bookings_present" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" END) AS `TourDate__booking_status`, ( IF( `TourDate`.`cancelled`, 'canceled', IF((SELECT SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) > 0 AND SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) = SUM(IF(`Booking`.`status` NOT IN ('new_from_website', 'waiting_list', 'called_off', 'canceled'), 1, 0)) FROM bookings AS Booking WHERE `Booking`.`tour_date_id` = `TourDate`.`id`), 'completed', 'in_process') )) AS `TourDate__processing_status`, (`TourDate`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tour_dates AS TourTravelOptionXTourDates inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTourDates`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTourDates`.`tour_date_id` = `TourDate`.`id`), 0)) AS `TourDate__price_excl_flight`, `ContentsTourDate`.`id`, `ContentsTourDate`.`content_id`, `ContentsTourDate`.`tour_date_id`, `ContentsTourDate`.`position` FROM `alpinewelten`.`tour_dates` AS `TourDate` JOIN `alpinewelten`.`contents_tour_dates` AS `ContentsTourDate` ON (`ContentsTourDate`.`content_id` = 901 AND `ContentsTourDate`.`tour_date_id` = `TourDate`.`id`) 0 0 0 SELECT `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, `Tour`.`recommendation_extra_overnight_stays`, `Tour`.`backpack_total_weight`, `Tour`.`taxation`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight`, `ContentsTour`.`id`, `ContentsTour`.`content_id`, `ContentsTour`.`tour_id`, `ContentsTour`.`position` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`contents_tours` AS `ContentsTour` ON (`ContentsTour`.`content_id` = 901 AND `ContentsTour`.`tour_id` = `Tour`.`id`) 0 0 0 SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ArticleContentMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 901 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC 1 1 0 SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9332) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 1 1 0 SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `GalleryMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 901 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `MosaicGalleryMedia`.`id`, `MosaicGalleryMedia`.`hash`, `MosaicGalleryMedia`.`created`, `MosaicGalleryMedia`.`updated`, `MosaicGalleryMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `MosaicGalleryMedia`.`id`) AS `MosaicGalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `MosaicGalleryMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 901 AND `MediaEntity`.`media_id` = `MosaicGalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'mosaic_gallery' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `BackgroundImageMedia`.`id`, `BackgroundImageMedia`.`hash`, `BackgroundImageMedia`.`created`, `BackgroundImageMedia`.`updated`, `BackgroundImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) AS `BackgroundImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `BackgroundImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 901 AND `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'background_image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 901 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `PlaceholderImageMedia`.`id`, `PlaceholderImageMedia`.`hash`, `PlaceholderImageMedia`.`created`, `PlaceholderImageMedia`.`updated`, `PlaceholderImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) AS `PlaceholderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `PlaceholderImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 901 AND `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'placeholder_image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `FaqItems`.`id`, `FaqItems`.`hash`, `FaqItems`.`created`, `FaqItems`.`updated`, `FaqItems`.`title`, `FaqItems`.`target_group`, `FaqItems`.`tags`, `FaqItems`.`question`, `FaqItems`.`answer`, `FaqItems`.`login_required`, `FaqItems`.`highlight`, `FaqItems`.`always_show`, `FaqItems`.`mountainguide_information`, `ContentsFaqItem`.`id`, `ContentsFaqItem`.`content_id`, `ContentsFaqItem`.`faq_item_id`, `ContentsFaqItem`.`position` FROM `alpinewelten`.`faq_items` AS `FaqItems` JOIN `alpinewelten`.`contents_faq_items` AS `ContentsFaqItem` ON (`ContentsFaqItem`.`content_id` = 901 AND `ContentsFaqItem`.`faq_item_id` = `FaqItems`.`id`) ORDER BY `ContentsFaqItem`.`position` ASC 0 0 0 SELECT `Users`.`id`, `Users`.`hash`, `Users`.`created`, `Users`.`updated`, `Users`.`activity`, `Users`.`group_id`, `Users`.`status`, `Users`.`username`, `Users`.`password`, `Users`.`name`, `Users`.`lastname`, `Users`.`email`, `Users`.`limit`, `Users`.`language`, `Users`.`email_signature`, `Users`.`telephone`, `Users`.`dept_for_trigger_mail`, `Users`.`expert_text`, `Users`.`token`, `Users`.`password_reset_token`, `Users`.`password_reset_token_expire_date`, `Users`.`qonto_oauth2_access_token`, `Users`.`qonto_membership_id`, (CONCAT(`Users`.`name`, " ", `Users`.`lastname`)) AS `Users__fullname`, `ContentsUser`.`id`, `ContentsUser`.`content_id`, `ContentsUser`.`user_id`, `ContentsUser`.`position` FROM `alpinewelten`.`users` AS `Users` JOIN `alpinewelten`.`contents_users` AS `ContentsUser` ON (`ContentsUser`.`content_id` = 901 AND `ContentsUser`.`user_id` = `Users`.`id`) ORDER BY `ContentsUser`.`position` ASC 0 0 0 SELECT `Tags`.`id`, `Tags`.`hash`, `Tags`.`created`, `Tags`.`updated`, `Tags`.`title`, `Tags`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `Tags`.`id`) AS `Tags__cross_reference_count`, `ContentsTag`.`id`, `ContentsTag`.`content_id`, `ContentsTag`.`tag_id`, `ContentsTag`.`position` FROM `alpinewelten`.`tags` AS `Tags` JOIN `alpinewelten`.`contents_tags` AS `ContentsTag` ON (`ContentsTag`.`content_id` = 901 AND `ContentsTag`.`tag_id` = `Tags`.`id`) ORDER BY `ContentsTag`.`position` ASC 0 0 0 SELECT `ExclusionTags`.`id`, `ExclusionTags`.`hash`, `ExclusionTags`.`created`, `ExclusionTags`.`updated`, `ExclusionTags`.`title`, `ExclusionTags`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `ExclusionTags`.`id`) AS `ExclusionTags__cross_reference_count`, `ContentsExclusionTag`.`id`, `ContentsExclusionTag`.`content_id`, `ContentsExclusionTag`.`tag_id`, `ContentsExclusionTag`.`position` FROM `alpinewelten`.`tags` AS `ExclusionTags` JOIN `alpinewelten`.`contents_exclusion_tags` AS `ContentsExclusionTag` ON (`ContentsExclusionTag`.`content_id` = 901 AND `ContentsExclusionTag`.`tag_id` = `ExclusionTags`.`id`) ORDER BY `ContentsExclusionTag`.`position` ASC 0 0 0 SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage_mountainguides' AND `Language`.`langid` = 'wf' LIMIT 1 0 0 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 325 LIMIT 1 1 1 0 SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_partner' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 674 AND `Menu`.`rght` < 689 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc 7 7 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (1022, 1024, 1025, 1035, 1062, 1063, 1064) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 7 7 0 SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'wf' LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 185 LIMIT 1 1 1 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 977 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 622 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (185) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (185) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC 0 0 0 SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 185 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0 SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 185 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC 0 0 0 SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 1 1 0 SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'myclimate' LIMIT 1 1 1 0 SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1 1 1 0 SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1 1 1 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 20.37 MB
Message Memory use Component initialization 2.52 MB Controller action start 7.86 MB Controller render start 8.57 MB View render complete 11.41 MB Timers
Total Request Time: 589 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 164.44 Event: Controller.initialize 8.19 Event: Controller.startup 1.27 Controller action 11.43 Event: Controller.beforeRender 115.04 » Processing toolbar data 55.25 Rendering View 179.17 » Event: View.beforeRender 0.03 » Rendering APP/Plugin/FrontendContents/View/FrontendContents/mountain_guide_index.php 1.88 » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php 0.34 » Event: View.afterRender 0.29 » Event: View.beforeLayout 0.02 » Rendering APP/View/Layouts/3.php 174.10 » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php 0.68 » » Rendering APP/View/Elements/header/header.php 55.37 » » » Rendering APP/View/Elements/header/header_navbar.php 54.83 » » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php 0.24 » » » » Rendering APP/View/Elements/navigation_secondary.php 31.42 » » » » » Rendering APP/View/Elements/icon.php 13.82 » » » » » Rendering APP/View/Elements/icon.php #2 0.68 » » » » » Rendering APP/View/Elements/icon.php #3 0.60 » » » » » Rendering APP/View/Elements/icon.php #4 13.88 » » » » Rendering APP/View/Elements/navigation.php 20.79 » » » » » Rendering APP/View/Elements/icon.php #5 0.69 » » » » » Rendering APP/View/Elements/icon.php #6 0.60 » » » » » Rendering APP/View/Elements/icon.php #7 0.59 » » » » » Rendering APP/View/Elements/icon.php #8 0.59 » » » » » Rendering APP/View/Elements/icon.php #9 0.59 » » » » » Rendering APP/View/Elements/icon.php #10 0.64 » » » » » Rendering APP/View/Elements/icon.php #11 0.43 » » » » » Rendering APP/View/Elements/icon.php #12 0.59 » » » » » Rendering APP/View/Elements/icon.php #13 0.68 » » » » » Rendering APP/View/Elements/icon.php #14 0.58 » » » » » Rendering APP/View/Elements/icon.php #15 0.58 » » » » » Rendering APP/View/Elements/icon.php #16 0.44 » » » » » Rendering APP/View/Elements/icon.php #17 0.58 » » » » » Rendering APP/View/Elements/icon.php #18 0.58 » » » » » Rendering APP/View/Elements/icon.php #19 0.63 » » » » » Rendering APP/View/Elements/icon.php #20 0.60 » » » » » Rendering APP/View/Elements/icon.php #21 0.59 » » » » » Rendering APP/View/Elements/icon.php #22 0.59 » » » » » Rendering APP/View/Elements/icon.php #23 0.64 » » » » » Rendering APP/View/Elements/icon.php #24 0.61 » » » » » Rendering APP/View/Elements/icon.php #25 0.57 » » » » » Rendering APP/View/Elements/icon.php #26 0.57 » » » » » Rendering APP/View/Elements/icon.php #27 0.42 » » Rendering APP/View/Elements/breadcrumb.php 0.26 » » Rendering APP/View/Elements/footer/footer.php 33.96 » » » Rendering APP/View/Elements/icon.php #28 13.64 » » » Rendering APP/View/Elements/icon.php #29 13.53 » » » Rendering APP/View/Elements/logos/logo-instagram.php 0.23 » » » Rendering APP/View/Elements/logos/logo-youtube.php 0.21 » » » Rendering APP/View/Elements/logos/logo-facebook.php 0.20 » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php 0.21 » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php 0.20 » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php #2 0.21 » » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php 0.32 » » Rendering APP/View/Elements/contact_widget.php 79.69 » » » Rendering APP/View/Elements/icon.php #30 13.56 » » » Rendering APP/View/Elements/icon.php #31 13.89 » » » Rendering APP/View/Elements/icon.php #32 18.87 » » » Rendering APP/View/Elements/icon.php #33 15.78 » » » Rendering APP/View/Elements/icon.php #34 15.25 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- mountainGuides(array)
- 0(array)
- MountainGuide(array)
- id1
- hash92d0efd1b3677c2c8d7b41bcf1adf88c
- created2015-09-09 07:30:06
- updated2025-07-15 16:11:52
- mountain_guide_typecore
- mountain_guide_salutationmr
- mountain_guide_nameHansi
- mountain_guide_lastnameStöckl
- mountain_guide_streetKierngassweg 14
- mountain_guide_zip83471
- mountain_guide_citySchönau
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede, en
- mountain_guide_mobile+491717188894
- mountain_guide_phone+4986529772569
- mountain_guide_emailstoeckl@alpinewelten.com
- mountain_guide_birthday1981-07-07
- bank_account_holder_lastnameStöckl
- bank_account_holder_nameHansi
- bank_account_number3418820
- bank_code71090000
- bank_nameVr Bank Oberbayern
- bank_ibanDE96710900000003418820
- bank_bicGENODEF1BGL
- tax_number10527810766
- vat_number
- mountain_guide_education5
- height183
- clothing_comment<p>Einkleidung 22 erhalten</p> <p>Teileinkleidung 24 Tshirt + kurze Hose</p>
- passport_numberCF210TZZ4
- id_numberLF21041LW
- comment<p>Geschäftsführer Alpine Welten / Spezialgebiet Berchtesgaden und Norwegen</p>
- alpine_club_number029/00/073571
- adac_number341259878
- other_insurancesWürttembergische KV 33211182726 Privat + Ausland
- youtubehttps://youtu.be/6AqB2_Jxf38
- emergency_contact_relationFrau
- emergency_contact_salutationmrs
- emergency_contact_nameStöckl
- emergency_contact_lastnameEvi
- emergency_contact_streetKierngassweg 14
- emergency_contact_zip83471
- emergency_contact_citySchönau
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile+4915756101565
- emergency_contact_phone+4986529772569
- emergency_contact_emailevi.stoeckl@gmx.de
- firm_id1
- ws_text_content<h2>Bergführer Hansi Stöckl</h2> <p>Hansi wohnt mit seiner Familie in Schönau am Königssee und betreibt gemeinsam mit Hans die Bergschule.</p> <p>Nach seiner aktiven Zeit als Leistungssportler im Biathlon widmete er sich voll und ganz dem Bergsteigen. Hierbei ist auch der Wunsch gereift, Bergführer zu werden sowie Hobby & Beruf zu verbinden. Auf Tour findet man ihn meistens bei unseren Hochtouren und Skitouren in der Schweiz, ganz sicher aber in der Watzmann Ostwand und im heimischen Berchtesgadener Land...</p> <p>Jedes Jahr erkundet Hansi neue Touren für unsere Gäste, wobei sein Herz ein wenig in Norwegen in den Lyngenalpen hängen geblieben ist! Spitzbergen, Island, Kirgistan sind weitere Ziele von Hansi. Expeditionen außerhalb Europas führten ihn in die Big Walls des Yosemite Valleys, zum Bergsteigen nach Südamerika auf den Alpamayo sowie auf den Gipfel des weltberühmten Fiz Roy in Patagonien.</p>
- ws_text_motivation<p>Das gemeinsame Bergerlebnis macht einfach unheimlich Spaß! Ich verbinde mit meinem Beruf Freude und Glück, aber zugleich auch große Verantwortung! Die Steigerung von einer "guten Tour" zu einer Traumtour liegt im Detail und ist meine große Herausforderung, jedes Mal aufs Neue.</p>
- ws_text_out_of_apline_hobbies<ul> <li>Klettern & Bergsteigen</li> <li>Arbeiten mit Holz als Schreiner</li> <li>Reisen mit der Familie</li> </ul>
- ws_text_personal_information<ul> <li>Verheiratet</li> <li>Eine Tochter und ein Sohn</li> </ul>
- ws_text_additional_qualifications<ul> <li>Geschäftsführer Alpine Welten Die Bergführer</li> <li>PSA Sachverständiger</li> </ul>
- member_id6005
- previous_urlhttp://www.alpinewelten.com/de/hansi-stoeckl-bergfuehrer/
- statusactive
- exact_shoe_size10.5
- exact_trousers_size50
- exact_trousers_large(false)
- exact_jacket_size52
- exact_shirt_size52
- last_api_call2025-07-14 08:17:03
- tax_countryDE
- tax_obligation(true)
- aspirant_contract_hh(false)
- aspirant_contract_hs(false)
- wise_card(true)
- clothing_package_2022
- clothing_package_2023
- importanceplatinum
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 430.00 € | Bergführer Ostalpen 390.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Trekking & Expeditionen 280.00 € | Kletterreisen (Flug) 270.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameHansi Stöckl
- Route(array)
- id216
- hash8709ae73e2da25e47b0a30131d04c40e
- created2016-08-12 17:21:07
- updated2025-07-15 16:11:53
- modelMountainGuide
- foreign_key1
- base/
- aliashansi-stoeckl
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft3203
- rght3204
- route/hansi-stoeckl
- TeaserImageMedia(array)
- 0(array)
- id3030
- hashdcafb0f79edb394d8c540542fe31c41a
- created2016-10-14 16:21:06
- updated2016-10-14 16:21:06
- titlehansi-stoeckl-bergfuehrer-watzmann-ostwand
- cross_reference_count4
- MediaEntity(array)
- id678058
- pos1
- media_id3030
- modelMountainGuide
- fieldteaser_image
- foreign_key1
- FileUpload(array)
- 0(array)
- id39599
- hashe3f690297d810ead67867a05e766485c
- created2016-10-14 16:20:53
- updated2016-10-14 16:21:06
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5800e9d20e42e.jpg
- size258409
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id449847
- hash32c854e04b071e99161d93a6b974adec
- created2020-10-28 00:31:30
- updated2020-10-28 00:31:30
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thteaserimageresponsive.jpg
- thumbnailth-teaser-image-responsive
- parent_id39599
- filewebroot/files/Media/File/ThTeaserImageResponsive/5f98add232dac.jpg
- size60437
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id449850
- hash1289c55fea85db75445930f1233856c7
- created2020-10-28 00:31:30
- updated2020-10-28 00:31:30
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thteaserimageresponsivedesaturated.jpg
- thumbnailth-teaser-image-responsive-desaturated
- parent_id39599
- filewebroot/files/Media/File/ThTeaserImageResponsiveDesaturated/5f98add275059.jpg
- size54625
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 3(array)
- id912554
- hash8ef7f7cb549f119b72efa0adbefef807
- created2025-07-15 16:11:52
- updated2025-07-15 16:11:52
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id39599
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/687661a873f30.jpg
- size60437
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 4(array)
- id912555
- hash920630ace38e21ddf64be16bd8ddf48f
- created2025-07-15 16:11:52
- updated2025-07-15 16:11:52
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id39599
- filewebroot/files/Media/File/ThMountainGuideAvatar/687661a891fe7.jpg
- size1582
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 5(array)
- id912556
- hash25a4f8738e6b4c0fe7f86951d95291a1
- created2025-07-15 16:11:52
- updated2025-07-15 16:11:52
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id39599
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/687661a8b7242.jpg
- size60437
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 6(array)
- id912565
- hashdb67abd94763483ec382b87215882547
- created2025-07-15 16:11:53
- updated2025-07-15 16:11:53
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thseoimagefacebook.png
- thumbnailth-seo-image-facebook
- parent_id39599
- filewebroot/files/Media/File/ThSeoImageFacebook/687661a95d46a.png
- size499681
- ext.png
- mimeimage/png
- width720
- height405
- 7(array)
- id912566
- hash61f9b8dc36a013824ea7657df344115d
- created2025-07-15 16:11:53
- updated2025-07-15 16:11:53
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thseoimagegoogle.png
- thumbnailth-seo-image-google
- parent_id39599
- filewebroot/files/Media/File/ThSeoImageGoogle/687661a9969f9.png
- size499681
- ext.png
- mimeimage/png
- width720
- height405
- 8(array)
- id912567
- hash580902154171a7b808c0f0a274e3227e
- created2025-07-15 16:11:53
- updated2025-07-15 16:11:53
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thseoimagetwitter.png
- thumbnailth-seo-image-twitter
- parent_id39599
- filewebroot/files/Media/File/ThSeoImageTwitter/687661a9cc45d.png
- size157904
- ext.png
- mimeimage/png
- width375
- height210
- 9(array)
- id452805
- hash76f9b724b4d8b24ccd037991e7eaeb5c
- created2020-10-28 00:41:24
- updated2020-10-28 00:41:24
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id39599
- filewebroot/files/Media/File/ThMediaFileIndex/5f98b024ac83b.jpg
- size15423
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 10(array)
- id452806
- hashea2e2a1f9671fc12f8ae7e1f0c24feb2
- created2020-10-28 00:41:25
- updated2020-10-28 00:41:25
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id39599
- filewebroot/files/Media/File/CkeditorXs/5f98b024e56ee.jpg
- size4746
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 11(array)
- id452807
- hash49839d280fee945284a55dbd47ebeec7
- created2020-10-28 00:41:25
- updated2020-10-28 00:41:25
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id39599
- filewebroot/files/Media/File/CkeditorSm/5f98b02536a6d.jpg
- size15423
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 12(array)
- id452808
- hash9f6963c518d282c3ff7ccca6d3a6b0da
- created2020-10-28 00:41:25
- updated2020-10-28 00:41:25
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id39599
- filewebroot/files/Media/File/CkeditorMd/5f98b02572658.jpg
- size24678
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 13(array)
- id452809
- hashae62e86c73f147fac9399d5ad3f4f9f3
- created2020-10-28 00:41:25
- updated2020-10-28 00:41:25
- modelMedia
- fieldfile
- foreign_key3030
- aliashansi-stoeckl-bergfuehrer-watzmann-ostwand-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id39599
- filewebroot/files/Media/File/CkeditorLg/5f98b025a89ec.jpg
- size51918
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id9915
- mountain_guide_qualification_id1
- mountain_guide_id1
- position1
- 1(array)
- id2
- hash8474b4210a3c47611d3bca708c40832d
- created2016-09-11 14:08:16
- updated2019-04-24 09:47:08
- position5
- titleHeeresbergführer
- categoryhbf_pbf
- MountainGuideQualificationsMountainGuide(array)
- id9917
- mountain_guide_qualification_id2
- mountain_guide_id1
- position3
- 2(array)
- id6
- hasha27cb8b3f6b77e6eabe31c2b479c4b9b
- created2016-09-11 14:10:20
- updated2019-04-24 09:48:25
- position13
- titleSkilehrer (LSV-Landesskilehrer)
- categoryski_instructor
- MountainGuideQualificationsMountainGuide(array)
- id9916
- mountain_guide_qualification_id6
- mountain_guide_id1
- position2
- 3(array)
- id35
- hash9e3180e660d0e4fe24c5e3272047a8c7
- created2020-02-28 12:07:33
- updated2020-02-28 12:07:33
- position35
- titleEntwicklungsteam Wanderakademie
- categorynone
- MountainGuideQualificationsMountainGuide(array)
- id9918
- mountain_guide_qualification_id35
- mountain_guide_id1
- position4
- 0(array)
- MountainGuide(array)
- 1(array)
- MountainGuide(array)
- id43
- hash3f218ac04b1388f55da6de4d06696535
- created2015-12-28 10:33:46
- updated2025-06-30 11:25:51
- mountain_guide_typecore
- mountain_guide_salutationmr
- mountain_guide_nameJörg
- mountain_guide_lastnameRauschenberger
- mountain_guide_streetMoserweg 7
- mountain_guide_zip83435
- mountain_guide_cityBad Reichenhall
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede
- mountain_guide_mobile+491739818616
- mountain_guide_phone+498651716808
- mountain_guide_emailjrauschenberger@gmx.de
- mountain_guide_birthday1972-11-11
- bank_account_holder_lastnameRauschenberger
- bank_account_holder_nameJörg
- bank_account_number
- bank_code
- bank_namePostbank Stuttgart
- bank_ibanDE91600100700298845703
- bank_bicPBNKDEFF
- tax_number94 062 180 754
- vat_number
- mountain_guide_education9
- height172
- clothing_comment
- passport_number
- id_numberLF1MP6ZXJ
- comment
- alpine_club_number220/00/909000 1000 1985 2007 11111972
- adac_number
- other_insurances
- youtube
- emergency_contact_relationEhefrau
- emergency_contact_salutationmrs
- emergency_contact_nameMonika
- emergency_contact_lastnameRauschenberger
- emergency_contact_streetMoserweg 7
- emergency_contact_zip83435
- emergency_contact_cityBad Reichenhall
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile+4915110181129
- emergency_contact_phone+498651716808
- emergency_contact_email
- firm_id3
- ws_text_content<h2>Bergführer Jörg Rauschenberger</h2> <p>Jörg wohnt mit seiner Familie in Bad Reichenhall im Berchtesgadener Land und ist unser Spezialist für alle Freeridetouren und Skitouren. Kein Wunder wenn man Mitglied in der Nationalmannschaft Skibergsteigen war. Expeditionen führten ihn bisher nach Asien, Südamerika, an den Denali und den Muztagh Ata.</p>
- ws_text_motivation
- ws_text_out_of_apline_hobbies<ul> <li>Keine....</li> </ul>
- ws_text_personal_information<ul> <li>Verheiratet</li> <li>2 Töchter</li> </ul>
- ws_text_additional_qualifications<ul> <li>ehem. Ausbilder am Heeresbergführerlehrgang</li> <li>Internationaler Rettungsspezialist (IRS)</li> <li>Mehrfacher Expeditionsleiter an Sechs- und Siebentausendern</li> </ul>
- member_id6181
- previous_urlhttp://www.alpinewelten.com/de/joerg-rauschenberger-bergfuehrer/
- statusactive
- exact_shoe_size7.5
- exact_trousers_size48
- exact_trousers_large(false)
- exact_jacket_size46
- exact_shirt_size46
- last_api_call2025-07-08 14:09:53
- tax_country(null)
- tax_obligation(false)
- aspirant_contract_hh(false)
- aspirant_contract_hs(false)
- wise_card(true)
- clothing_package_2022
- clothing_package_2023
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 430.00 € | Bergführer Ostalpen 390.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameJörg Rauschenberger
- Route(array)
- id254
- hashfa5f2a34afb323d48c42bb9f9b62665a
- created2016-08-12 17:21:07
- updated2025-06-30 11:25:52
- modelMountainGuide
- foreign_key43
- base/
- aliasjoerg-rauschenberger-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft3271
- rght3272
- route/joerg-rauschenberger-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id2778
- hash80366392fb5cb69160a59053351e22bf
- created2016-10-13 04:58:42
- updated2016-10-13 04:58:42
- titleBergfuehrer Joerg Rauschenberger auf dem Tafeltinden in den Lyngen Alpen Skitourenreise Norwegen
- cross_reference_count2
- MediaEntity(array)
- id675896
- pos1
- media_id2778
- modelMountainGuide
- fieldteaser_image
- foreign_key43
- FileUpload(array)
- 0(array)
- id34705
- hash9f4a09504a4113e2ebff38cbd6ce900c
- created2016-10-13 04:58:36
- updated2016-10-13 04:58:42
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/57fef862f1703.jpg
- size281403
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id908877
- hash48f9949dca472c65441c9f6e3a9004e9
- created2025-06-30 11:25:51
- updated2025-06-30 11:25:51
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id34705
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/6862581f8d67d.jpg
- size52640
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id908878
- hash8888a6ff97034cea24ee5212c505c6fd
- created2025-06-30 11:25:51
- updated2025-06-30 11:25:51
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id34705
- filewebroot/files/Media/File/ThMountainGuideAvatar/6862581fa3691.jpg
- size1225
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 3(array)
- id908879
- hash13430e80fc444baa2a7158ba353d5d71
- created2025-06-30 11:25:51
- updated2025-06-30 11:25:51
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id34705
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/6862581fc76a7.jpg
- size52640
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 4(array)
- id451210
- hashc95eadc3e32ff020d752756002aeb76d
- created2020-10-28 00:35:53
- updated2020-10-28 00:35:53
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id34705
- filewebroot/files/Media/File/ThMediaFileIndex/5f98aed936419.jpg
- size12972
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 5(array)
- id451212
- hashd60fbbdbc864c7d6849a8b53ba7c8814
- created2020-10-28 00:35:53
- updated2020-10-28 00:35:53
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id34705
- filewebroot/files/Media/File/CkeditorXs/5f98aed976951.jpg
- size4177
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 6(array)
- id451214
- hash26f2459b511a0f8268705a7a4d184903
- created2020-10-28 00:35:54
- updated2020-10-28 00:35:54
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id34705
- filewebroot/files/Media/File/CkeditorSm/5f98aed9c47a9.jpg
- size12972
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id451215
- hash3abe725360c5e4327b38e92e163112e2
- created2020-10-28 00:35:54
- updated2020-10-28 00:35:54
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id34705
- filewebroot/files/Media/File/CkeditorMd/5f98aeda1204e.jpg
- size20644
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 8(array)
- id451216
- hashbd2361b155ce470d2c8abd554f5b9e8e
- created2020-10-28 00:35:54
- updated2020-10-28 00:35:54
- modelMedia
- fieldfile
- foreign_key2778
- aliasbergfuehrer-joerg-rauschenberger-auf-dem-tafeltinden-in-den-lyngen-alpen-skitourenreise-norwegen-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id34705
- filewebroot/files/Media/File/CkeditorLg/5f98aeda53763.jpg
- size44570
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id9873
- mountain_guide_qualification_id1
- mountain_guide_id43
- position1
- 1(array)
- id2
- hash8474b4210a3c47611d3bca708c40832d
- created2016-09-11 14:08:16
- updated2019-04-24 09:47:08
- position5
- titleHeeresbergführer
- categoryhbf_pbf
- MountainGuideQualificationsMountainGuide(array)
- id9875
- mountain_guide_qualification_id2
- mountain_guide_id43
- position3
- 2(array)
- id22
- hash8f3a745311085071d4918c77f7d35b21
- created2016-09-15 06:22:55
- updated2019-04-24 09:56:51
- position23
- titleDSV Skilehrer
- categoryski_instructor
- MountainGuideQualificationsMountainGuide(array)
- id9874
- mountain_guide_qualification_id22
- mountain_guide_id43
- position2
- 0(array)
- MountainGuide(array)
- 2(array)
- MountainGuide(array)
- id111
- hash7a703592929e314b7999486643c3b794
- created2016-10-30 08:52:17
- updated2025-05-20 14:56:33
- mountain_guide_typecore
- mountain_guide_salutationmr
- mountain_guide_nameJosef
- mountain_guide_lastnameNeumeier
- mountain_guide_streetEberweinweg 1
- mountain_guide_zip83471
- mountain_guide_cityBerchtesgaden
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede
- mountain_guide_mobile+491702132541
- mountain_guide_phone086523573
- mountain_guide_emailjosef.neumeier@gmx.de
- mountain_guide_birthday1983-07-22
- bank_account_holder_lastnameNeumeier
- bank_account_holder_nameJosef
- bank_account_number
- bank_code
- bank_nameSparkasse Berchtesgadener Land
- bank_ibanDE907105000020111191
- bank_bicBYLADEM1BGL
- tax_number105/254/90365
- vat_number
- mountain_guide_education0
- height178
- clothing_comment
- passport_number
- id_numberLF2103P2T
- comment
- alpine_club_number029/00/061650
- adac_number254790966
- other_insurances
- youtube
- emergency_contact_relationEhefrau
- emergency_contact_salutationmrs
- emergency_contact_nameNeumeier
- emergency_contact_lastnameMonika
- emergency_contact_streetEberweinweg 1
- emergency_contact_zip83471
- emergency_contact_cityBerchtesgaden
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile+491708938503
- emergency_contact_phone086523573
- emergency_contact_emailmonika.walch@web.de
- firm_id3
- ws_text_content<h2>Bergführer Josef (Sepp) Neumeier</h2> <p>Sepp ist ein original Hallertauer Hopfenbauer. Seit 2004 lebt er aber in seiner Wahlheimat, dem Berchtesgadener Land. Auf Tour findet man Sepp nicht nur in den Berchtesgadener Bergen, den Dolomiten und den Westalpen. Auch 6.000er in Südamerika und einige Kletterreisen zu den verschiedensten europäischen Inseln darf er zu seinen Erlebnissen zählen.</p>
- ws_text_motivation<p>Für mich ist jeder Moment, den ich draußen in den Bergen verbringen darf, sehr wertvoll. Genauso arbeite ich gerne mit Menschen. Als Bergführer hat man beides und für mich ist es das Schönste, mit netten Gästen diese Momente zu teilen. Egal, ob in den Bergen der Welt, auf den 4.000ern der Alpen oder auf den ersten Schritten mit Steigeisen.</p>
- ws_text_out_of_apline_hobbies<ul> <li>Musik</li> <li>Schreinern</li> </ul>
- ws_text_personal_information<ul> <li>Verheiratet</li> <li>1 Kind</li> </ul>
- ws_text_additional_qualifications
- member_id6142
- previous_urlhttp://www.alpinewelten.com/de/sepp-neumeier-bergfuehrer/
- statusactive
- exact_shoe_size8.5
- exact_trousers_size50
- exact_trousers_large(false)
- exact_jacket_size50
- exact_shirt_size50
- last_api_call2025-06-27 12:34:32
- tax_countryDE
- tax_obligation(false)
- aspirant_contract_hh(false)
- aspirant_contract_hs(false)
- wise_card(false)
- clothing_package_2022
- clothing_package_2023
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 430.00 € | Bergführer Ostalpen 390.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameJosef Neumeier
- Route(array)
- id855
- hash17d5b9218d44258aaf5477fd7b3f000d
- created2016-10-30 08:52:17
- updated2025-05-20 14:56:34
- modelMountainGuide
- foreign_key111
- base/
- aliasjosef-neumeier-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft3407
- rght3408
- route/josef-neumeier-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id3412
- hash3bd8f4461a42e3b75a3ff992b89f1cb8
- created2016-10-30 08:49:42
- updated2016-10-30 08:49:42
- titlebergfuehrer-sepp-neumeier-watzmann-ostwand
- cross_reference_count2
- MediaEntity(array)
- id567996
- pos1
- media_id3412
- modelMountainGuide
- fieldteaser_image
- foreign_key111
- FileUpload(array)
- 0(array)
- id96310
- hashf22627bae4b4b45a0329e6da6ccd5f7a
- created2016-10-30 08:49:23
- updated2016-10-30 08:49:42
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5815a6169f64c.jpg
- size276064
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id765485
- hash903956941c9738fa42bc2b896b63e03d
- created2024-05-07 09:32:09
- updated2024-05-07 09:32:09
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id96310
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/6639d8f91371d.jpg
- size79997
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id765486
- hashbb86e719c3864505febb412cc161fc4f
- created2024-05-07 09:32:09
- updated2024-05-07 09:32:09
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id96310
- filewebroot/files/Media/File/ThMountainGuideAvatar/6639d8f94b2ef.jpg
- size1598
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 3(array)
- id765487
- hashc97ce20bdfdd2896784c132f1de94f77
- created2024-05-07 09:32:09
- updated2024-05-07 09:32:09
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id96310
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/6639d8f984f60.jpg
- size79997
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 4(array)
- id455082
- hashbc377612de50354cbe5d3866acf3f8a4
- created2020-10-28 00:48:10
- updated2020-10-28 00:48:10
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id96310
- filewebroot/files/Media/File/ThMediaFileIndex/5f98b1ba731f6.jpg
- size15606
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 5(array)
- id455085
- hashe61cf672de1335e42a44a75b5a08ba57
- created2020-10-28 00:48:10
- updated2020-10-28 00:48:10
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id96310
- filewebroot/files/Media/File/CkeditorXs/5f98b1baa3799.jpg
- size4695
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 6(array)
- id455086
- hash1c5c7e28521a54ea648873febc5f56d1
- created2020-10-28 00:48:11
- updated2020-10-28 00:48:11
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id96310
- filewebroot/files/Media/File/CkeditorSm/5f98b1bae751f.jpg
- size15606
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id455088
- hashd593864d2f93cff0ccbccc9e2d386a5f
- created2020-10-28 00:48:11
- updated2020-10-28 00:48:11
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id96310
- filewebroot/files/Media/File/CkeditorMd/5f98b1bb34e8c.jpg
- size25479
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 8(array)
- id455090
- hash972d2527fcf758dd37c923cf1ee2028c
- created2020-10-28 00:48:11
- updated2020-10-28 00:48:11
- modelMedia
- fieldfile
- foreign_key3412
- aliasbergfuehrer-sepp-neumeier-watzmann-ostwand-1-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id96310
- filewebroot/files/Media/File/CkeditorLg/5f98b1bb62e2b.jpg
- size56149
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id8932
- mountain_guide_qualification_id1
- mountain_guide_id111
- position2
- 1(array)
- id2
- hash8474b4210a3c47611d3bca708c40832d
- created2016-09-11 14:08:16
- updated2019-04-24 09:47:08
- position5
- titleHeeresbergführer
- categoryhbf_pbf
- MountainGuideQualificationsMountainGuide(array)
- id8931
- mountain_guide_qualification_id2
- mountain_guide_id111
- position1
- 2(array)
- id6
- hasha27cb8b3f6b77e6eabe31c2b479c4b9b
- created2016-09-11 14:10:20
- updated2019-04-24 09:48:25
- position13
- titleSkilehrer (LSV-Landesskilehrer)
- categoryski_instructor
- MountainGuideQualificationsMountainGuide(array)
- id8933
- mountain_guide_qualification_id6
- mountain_guide_id111
- position3
- 0(array)
- MountainGuide(array)
- 3(array)
- MountainGuide(array)
- id8
- hash84e2249ca1f12ebaeaf7e69dbb3dfb1a
- created2015-12-10 10:27:49
- updated2025-05-20 14:56:25
- mountain_guide_typecore
- mountain_guide_salutationmr
- mountain_guide_nameMarkus
- mountain_guide_lastnameBeck
- mountain_guide_streetSeelauerweg 13
- mountain_guide_zip83458
- mountain_guide_citySchneizlreuth
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede, en
- mountain_guide_mobile+491772896050
- mountain_guide_phone+498665218550
- mountain_guide_emailmackei@gmx.de
- mountain_guide_birthday1977-04-28
- bank_account_holder_lastnameBeck
- bank_account_holder_nameMarkus
- bank_account_number
- bank_code
- bank_nameSparkasse BGL
- bank_ibanDE15710500000000052068
- bank_bicBYLADEM1BGL
- tax_number105/203/60005
- vat_number
- mountain_guide_education6
- height190
- clothing_comment<p>Text</p>
- passport_numberCF20933FK 29.10 2024
- id_numberLF20XXMVO
- comment
- alpine_club_number220/00/913090
- adac_number
- other_insurancesHV 14528
- youtube
- emergency_contact_relationEhefrau
- emergency_contact_salutationmrs
- emergency_contact_nameNada
- emergency_contact_lastnameBeck
- emergency_contact_streetSeelauerweg 13
- emergency_contact_zip83458
- emergency_contact_citySchneizlreuth
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile00491777725351
- emergency_contact_phone+498665218550
- emergency_contact_emailmackei@gmx.de
- firm_id3
- ws_text_content<h2>Bergführer Markus Beck</h2> <p>Markus wohnt mit seiner Familie in Weissbach im Berchtesgadener Land. Schon seit seiner Kindheit dreht sich bei ihm alles um die Welt der Berge. Im Hauptberuf arbeitet Markus bei der Berufsfeuerwehr München als Rettungssanitäter. Diese Erfahrung lässt er auch in seine Arbeit als Bergführer einfliesen, was ihn zu einem sehr umsichtigen Führer macht. Einen wesentlichen Teil seiner freien Zeit verbringt Markus beim Bergführen in den heimischen Berchtesgadener Bergen, den Dolomiten und an den Dreitausendern und Viertausendern in Österreich und der Schweiz.</p> <p>Kletterexpeditionen führten ihn an die Big Walls des Yosemite Valley in den USA und an den Seven Summit Kilimanjaro. Zusätzlich ist Markus Teil des Polarteams von Alpine Welten. Hier ist er in die Ausbildung der Schiffsbesatzung des deutschen Forschungsschiffs Polarstern auf Spitzbergen eingebunden und begleitete während der<a href="https://mosaic-expedition.org/" target="_blank"> internationalen arktischen Drift Expedition Mosaic</a> rund 4 Monate Wissenschaftler auf der Polarstern bei deren Forschungen zum Klimawandel in der Arktis.</p>
- ws_text_motivation<p>Was gibt es schöneres, als das Hobby zum Beruf zu machen? Der Beruf des Bergführers ist für mich sicher der eindrücklichste Arbeitsplatz der Welt!</p>
- ws_text_out_of_apline_hobbies<ul> <li>Gleitschirmfliegen & Familie</li> </ul>
- ws_text_personal_information<ul> <li>Verheiratet</li> <li>zwei Töchter</li> </ul>
- ws_text_additional_qualifications<ul> <li>Rettungssanitäter</li> <li>Basic Safety + Security Awarness</li> </ul>
- member_id5976
- previous_urlhttp://www.alpinewelten.com/de/markus-beck-bergfuehrer/
- statusactive
- exact_shoe_size12
- exact_trousers_size52
- exact_trousers_large(true)
- exact_jacket_size52
- exact_shirt_size52
- last_api_call2025-07-15 08:39:38
- tax_countryDE
- tax_obligation(true)
- aspirant_contract_hh(true)
- aspirant_contract_hs(false)
- wise_card(true)
- clothing_package_2022
- clothing_package_2023<p><a href="https://admin.shopify.com/store/08f459/orders/5984665076046 " target="_blank">Kleidungspaket24</a></p>
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(true)
- daily_ratesBergführer Westalpen 430.00 € | Bergführer Ostalpen 390.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameMarkus Beck
- Route(array)
- id219
- hashd98f64803f5f10f91219fa02653175f6
- created2016-08-12 17:21:07
- updated2025-05-20 14:56:25
- modelMountainGuide
- foreign_key8
- base/
- aliasmarkus-beck
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft3207
- rght3208
- route/markus-beck
- TeaserImageMedia(array)
- 0(array)
- id9501
- hash1c19be72def3e53b2ad76d87b3573c43
- created2020-11-02 13:42:41
- updated2020-11-02 13:42:41
- titlemarkus-beck-ist-bergfuerher-am-Watzmann
- cross_reference_count1
- MediaEntity(array)
- id664358
- pos1
- media_id9501
- modelMountainGuide
- fieldteaser_image
- foreign_key8
- FileUpload(array)
- 0(array)
- id493544
- hashc93f452d232ca8af8323b2dd1d6fab10
- created2020-11-02 13:42:36
- updated2020-11-02 13:42:41
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5f9ffec1f38a0.jpg
- size179233
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id892329
- hash8c5ec4076163675e32ff21126ce2f530
- created2025-05-08 15:38:57
- updated2025-05-08 15:38:57
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id493544
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/681cb3f0f0c0b.jpg
- size39586
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id892330
- hashffc2233403ea184a037969f9f4ff8911
- created2025-05-08 15:38:57
- updated2025-05-08 15:38:57
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id493544
- filewebroot/files/Media/File/ThMountainGuideAvatar/681cb3f11a405.jpg
- size1605
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 3(array)
- id493545
- hash2730c0f85890a1f6036a04a3079b04c9
- created2020-11-02 13:42:42
- updated2020-11-02 13:42:42
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id493544
- filewebroot/files/Media/File/ThMediaFileIndex/5f9ffec2005a4.jpg
- size13468
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 4(array)
- id493546
- hash009afda5f65ee802605c68bac925a971
- created2020-11-02 13:42:42
- updated2020-11-02 13:42:42
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id493544
- filewebroot/files/Media/File/CkeditorXs/5f9ffec233dd7.jpg
- size4805
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 5(array)
- id493547
- hash8f76026f212738109e44a07fb80d1aea
- created2020-11-02 13:42:42
- updated2020-11-02 13:42:42
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id493544
- filewebroot/files/Media/File/CkeditorSm/5f9ffec27725d.jpg
- size13468
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 6(array)
- id493548
- hashde7554a22770c809a8c956e651160f5a
- created2020-11-02 13:42:43
- updated2020-11-02 13:42:43
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id493544
- filewebroot/files/Media/File/CkeditorMd/5f9ffec2b89b1.jpg
- size21153
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 7(array)
- id493549
- hash1bf4de418dbb141863482a8d814df4c0
- created2020-11-02 13:42:43
- updated2020-11-02 13:42:43
- modelMedia
- fieldfile
- foreign_key9501
- aliasmarkus-beck-ist-bergfuerher-am-watzmann-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id493544
- filewebroot/files/Media/File/CkeditorLg/5f9ffec317ccd.jpg
- size41858
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id9735
- mountain_guide_qualification_id1
- mountain_guide_id8
- position1
- 1(array)
- id2
- hash8474b4210a3c47611d3bca708c40832d
- created2016-09-11 14:08:16
- updated2019-04-24 09:47:08
- position5
- titleHeeresbergführer
- categoryhbf_pbf
- MountainGuideQualificationsMountainGuide(array)
- id9737
- mountain_guide_qualification_id2
- mountain_guide_id8
- position3
- 2(array)
- id6
- hasha27cb8b3f6b77e6eabe31c2b479c4b9b
- created2016-09-11 14:10:20
- updated2019-04-24 09:48:25
- position13
- titleSkilehrer (LSV-Landesskilehrer)
- categoryski_instructor
- MountainGuideQualificationsMountainGuide(array)
- id9736
- mountain_guide_qualification_id6
- mountain_guide_id8
- position2
- 0(array)
- MountainGuide(array)
- 4(array)
- MountainGuide(array)
- id34
- hash5c6f67e0377b91bfcd3fc0900da1b634
- created2015-12-22 08:38:26
- updated2025-05-20 14:56:26
- mountain_guide_typecore
- mountain_guide_salutationmr
- mountain_guide_nameMartin
- mountain_guide_lastnameBauregger
- mountain_guide_streetPeilsteinstraße 5
- mountain_guide_zip83435
- mountain_guide_cityBad Reichenhall
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede
- mountain_guide_mobile+491709800707
- mountain_guide_phone+498651770973
- mountain_guide_emailsunside@gmx.de
- mountain_guide_birthday1969-10-03
- bank_account_holder_lastnameBauregger
- bank_account_holder_nameMartin
- bank_account_number
- bank_code
- bank_nameSparkasse BGL
- bank_ibanDE71710500000000143016
- bank_bicBYLADEM1BGL
- tax_number10520330602
- vat_number
- mountain_guide_education1
- height179
- clothing_comment
- passport_number
- id_number806404612
- comment<p>+491709800707</p>
- alpine_club_number22000914543
- adac_number146307892
- other_insurancesunfallversicherung Gotthaer
- youtube
- emergency_contact_relationEhefrau
- emergency_contact_salutationmrs
- emergency_contact_nameBauregger
- emergency_contact_lastnameKarin
- emergency_contact_streetPeilsteinstraße 5
- emergency_contact_zip83435
- emergency_contact_cityBad Reichenhall
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile00491711756901
- emergency_contact_phone+498651770973
- emergency_contact_emailkarenbee@gmx.de
- firm_id3
- ws_text_content<h2>Bergführer Martin Bauregger "Cheesy"</h2> <p>Martin wohnt mit seiner Familie in Bad Reichenhall. Noch vor dem Abi begann er mit der Bergführerausbildung und ist nach wie vor begeistert, diesen Beruf ausführen zu dürfen. Sowohl privat als auch beruflich unterliegt er dem Wechsel der Jahreszeiten und ist so das ganze Jahr unterwegs. Im Winter ist er am liebsten auf seinen Telemark-Ski oder mit zwei "Nomic" bewaffnet, im Sommer in seinen Kletterpatschen oder unter seinem Gleitschirm hängend.</p> <p>Persönliche Träume konnte er sich auf zwei Telemark-Expeditionen am Aconcagua, Huascaran, Toclaraju, Pisco und Artesonraju in Peru und bei zahlreichen Erstbegehungen in Fels und Eis in den Heimatbergen erfüllen. Am Ogre in Pakistan gelang ihm die Route No rope - No hope 1.100 m, 7 Ao, 70 Grad und auch am Shivling kann er auf einen Erstbegehungsversuch zurück blicken.</p>
- ws_text_motivation<p>Mein damaliger Ausbilder sagte uns, wir sollten uns immer bewusst sein, das es ein Privileg ist, als Bergführer arbeiten zu dürfen. Und diese Einstellung konnte ich mir durch alle Höhen und Tiefen der Bergführerarbeit bewahren.</p>
- ws_text_out_of_apline_hobbies<ul> <li>Klassische Zithermusik</li> <li>Bogenschießen</li> <li>High- und Slacklinen</li> </ul>
- ws_text_personal_information<ul> <li>Verheiratet</li> <li>eine Tochter</li> </ul>
- ws_text_additional_qualifications<ul> <li>Langjähriges Mitglied im Bundeslehrteam DAV</li> <li>Systemischer Familientherapeut (DGSF)</li> <li>Diplomsozialpädagoge (FH)</li> </ul>
- member_id6072
- previous_urlhttp://www.alpinewelten.com/de/martin-bauregger-bergfuehrer/
- statusactive
- exact_shoe_size9
- exact_trousers_size50
- exact_trousers_large(false)
- exact_jacket_size52
- exact_shirt_size52
- last_api_call2025-07-15 20:50:49
- tax_countryDE
- tax_obligation(false)
- aspirant_contract_hh(false)
- aspirant_contract_hs(false)
- wise_card(false)
- clothing_package_2022
- clothing_package_2023
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 430.00 € | Bergführer Ostalpen 390.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameMartin Bauregger
- Route(array)
- id245
- hashec0ed8fb04e7c9aec9ede5612741cf5a
- created2016-08-12 17:21:07
- updated2025-05-20 14:56:27
- modelMountainGuide
- foreign_key34
- base/
- aliasmartin-bauregger-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft3255
- rght3256
- route/martin-bauregger-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id6698
- hashfcf84e72c934ea04be5ed09acf329d56
- created2019-06-07 14:21:54
- updated2019-06-07 14:21:54
- titlemit-bergfuehrer-martin-bauregger-am-hochtourenkurs.jpg
- cross_reference_count2
- MediaEntity(array)
- id600882
- pos1
- media_id6698
- modelMountainGuide
- fieldteaser_image
- foreign_key34
- FileUpload(array)
- 0(array)
- id270187
- hash52b35cae97e667b9c647a24f5d0b98ec
- created2019-06-07 14:21:39
- updated2019-06-07 14:21:54
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5cfa56e2d2eae.jpg
- size359280
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id806411
- hashf194f9eddd41477150e238c20d66b79a
- created2024-09-10 07:49:14
- updated2024-09-10 07:49:14
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id270187
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/66dfddda188e7.jpg
- size39128
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id806412
- hash1a32d30ffa847aaaaf8b78008858e403
- created2024-09-10 07:49:14
- updated2024-09-10 07:49:14
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id270187
- filewebroot/files/Media/File/ThMountainGuideAvatar/66dfddda3d3fb.jpg
- size1482
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 3(array)
- id806413
- hash6d87386aa8905291f1953bafb2778121
- created2024-09-10 07:49:14
- updated2024-09-10 07:49:14
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id270187
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/66dfddda64507.jpg
- size39128
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 4(array)
- id474653
- hashd289c5fdb4cb4583032189959232cc6c
- created2020-10-28 01:57:43
- updated2020-10-28 01:57:43
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id270187
- filewebroot/files/Media/File/ThMediaFileIndex/5f98c2078f5c1.jpg
- size18009
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 5(array)
- id474654
- hash3c3120ea75e897152dd4d831ee1c0da9
- created2020-10-28 01:57:44
- updated2020-10-28 01:57:44
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id270187
- filewebroot/files/Media/File/CkeditorXs/5f98c207c2e67.jpg
- size6137
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 6(array)
- id474655
- hash0b0e575ddda7c718548c06dab5b104e8
- created2020-10-28 01:57:44
- updated2020-10-28 01:57:44
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id270187
- filewebroot/files/Media/File/CkeditorSm/5f98c2080c456.jpg
- size18009
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id474657
- hash18d11c073e58efb77ba8f624ce156c3a
- created2020-10-28 01:57:44
- updated2020-10-28 01:57:44
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id270187
- filewebroot/files/Media/File/CkeditorMd/5f98c2084874c.jpg
- size28174
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 8(array)
- id474658
- hashdfe85293140d06e2e98dc4aba8cb58f8
- created2020-10-28 01:57:44
- updated2020-10-28 01:57:44
- modelMedia
- fieldfile
- foreign_key6698
- aliasmit-bergfuehrer-martin-bauregger-am-hochtourenkurs-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id270187
- filewebroot/files/Media/File/CkeditorLg/5f98c2086d814.jpg
- size57817
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id9102
- mountain_guide_qualification_id1
- mountain_guide_id34
- position1
- 0(array)
- MountainGuide(array)
- 5(array)
- MountainGuide(array)
- id196
- hashe9013373f21db27d9abe1e1c6cdb17be
- created2018-08-01 09:23:39
- updated2025-05-20 14:56:40
- mountain_guide_typeclose_circle
- mountain_guide_salutationmr
- mountain_guide_nameGeorg
- mountain_guide_lastnameSchwarzenberger
- mountain_guide_streetAm Barmsee 26
- mountain_guide_zip82494
- mountain_guide_cityKrün
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede
- mountain_guide_mobile+4915111090427
- mountain_guide_phone08825
- mountain_guide_email
- mountain_guide_birthday1978-03-21
- bank_account_holder_lastnameSchwarzenberger
- bank_account_holder_nameGeorg
- bank_account_number
- bank_code
- bank_nameVR-Bank Burghausen-Mühldorf eG
- bank_ibanDE12710610090005806720
- bank_bicGENODEF1AOE
- tax_number119/191/62998
- vat_number
- mountain_guide_education0
- height191
- clothing_comment
- passport_number
- id_number
- comment
- alpine_club_number
- adac_number
- other_insurances
- youtube
- emergency_contact_relationPartner
- emergency_contact_salutationmrs
- emergency_contact_nameLucia
- emergency_contact_lastnameSchrallhammer
- emergency_contact_streetHausbergstrasse 3
- emergency_contact_zip82467
- emergency_contact_cityGarmisch-Partenkirchen
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile+4917632244583
- emergency_contact_phone
- emergency_contact_emaillucia.schrallhammer@gmail.com
- firm_id3
- ws_text_content<h2>Bergführer Georg Schwarzenberger</h2> <p><span>Im oberbayrischen Krün aufgewachsen, sind Georg´s Heimatberge nach wie vor das Karwendel- und das Wettersteingebirge. Seit frühester Kindheit am Berg sind seine Heimatberge das Karwendel und das Wettersteingebirge. Seit dem 16. Lebensjahr ist Georg aktives Mitglied der Bergwacht Bayern und motiviert durch sein Umfeld seit 2003 staatl. gepr. Berg- und Skiführer. Durch sein zweites Standbein als Informatiker konnte er sich durch diese Abwechslung stets seinen Spaß und seine Begeisterung am Bergführen erhalten. </span></p>
- ws_text_motivation<p><span>Natürlich will ich auch den Gipfelerfolg. Aber der Weg ist das Ziel und dabei ist mir wichtig, meinen Gästen ein bleibendes Gesamterlebnis zu bieten und sie dabei auch für die kleinen Dinge am Wegesrand zu begeistern.</span></p>
- ws_text_out_of_apline_hobbies<ul> <li>Landwirtschaft</li> <li>Musik</li> </ul>
- ws_text_personal_information<ul> <li>4 Kinder</li> </ul>
- ws_text_additional_qualifications<ul> <li>Bergwachtmann</li> </ul>
- member_id10623
- previous_url
- statusactive
- exact_shoe_size10.5
- exact_trousers_size54
- exact_trousers_large(false)
- exact_jacket_size52
- exact_shirt_size54
- last_api_call2025-07-15 03:31:32
- tax_countryDE
- tax_obligation(false)
- aspirant_contract_hh(false)
- aspirant_contract_hs(false)
- wise_card(false)
- clothing_package_2022(null)
- clothing_package_2023(null)
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 390.00 € | Bergführer Ostalpen 330.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameGeorg Schwarzenberger
- Route(array)
- id2622
- hash23b99ff86a997261775a6941a94a7e77
- created2018-08-01 09:23:39
- updated2025-05-20 14:56:40
- modelMountainGuide
- foreign_key196
- base/
- aliasgeorg-schwarzenberger-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft5127
- rght5128
- route/georg-schwarzenberger-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id6579
- hash85a3ce728ecff3f059a47c7bd3ea34f1
- created2019-05-08 14:41:32
- updated2019-05-08 15:40:07
- titleBergfuehrer Georg Schwarzenberger auf Bergtour in den Berchtesgadener Alpen
- cross_reference_count3
- MediaEntity(array)
- id528000
- pos1
- media_id6579
- modelMountainGuide
- fieldteaser_image
- foreign_key196
- FileUpload(array)
- 0(array)
- id251529
- hash385cf793269dad884dad2c1d18f4fc8c
- created2019-05-08 14:41:18
- updated2019-05-08 14:41:32
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5cd2ce7cceb5a.jpg
- size394874
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id709962
- hash3e5b28d029c27ee8223acc31de5f98a4
- created2023-08-07 17:03:03
- updated2023-08-07 17:03:03
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id251529
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/64d107a76961b.jpg
- size89602
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id709963
- hash3002d61bf37897198a58cea842d811f6
- created2023-08-07 17:03:03
- updated2023-08-07 17:03:03
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id251529
- filewebroot/files/Media/File/ThMountainGuideAvatar/64d107a796b61.jpg
- size1380
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 3(array)
- id709964
- hashd2d066e19519daa6c1da2f3b6789f2c0
- created2023-08-07 17:03:03
- updated2023-08-07 17:03:03
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id251529
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/64d107a7cf522.jpg
- size89602
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 4(array)
- id709965
- hashf5ca7c7ac8d2a273347babf7c78789d6
- created2023-08-07 17:03:04
- updated2023-08-07 17:03:04
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thseoimagefacebook.png
- thumbnailth-seo-image-facebook
- parent_id251529
- filewebroot/files/Media/File/ThSeoImageFacebook/64d107a7f2b63.png
- size573772
- ext.png
- mimeimage/png
- width720
- height405
- 5(array)
- id709966
- hash6d7111adac212f8591e56fc8fed5a1e4
- created2023-08-07 17:03:04
- updated2023-08-07 17:03:04
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thseoimagegoogle.png
- thumbnailth-seo-image-google
- parent_id251529
- filewebroot/files/Media/File/ThSeoImageGoogle/64d107a82eaf1.png
- size573772
- ext.png
- mimeimage/png
- width720
- height405
- 6(array)
- id709967
- hash49164ab43c635b0455bcf76926462c21
- created2023-08-07 17:03:04
- updated2023-08-07 17:03:04
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thseoimagetwitter.png
- thumbnailth-seo-image-twitter
- parent_id251529
- filewebroot/files/Media/File/ThSeoImageTwitter/64d107a86b8a1.png
- size154025
- ext.png
- mimeimage/png
- width375
- height210
- 7(array)
- id473949
- hashf35d6dafd4deee8f5c00b883e67e6b03
- created2020-10-28 01:55:20
- updated2020-10-28 01:55:20
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id251529
- filewebroot/files/Media/File/ThMediaFileIndex/5f98c17807cf5.jpg
- size14377
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 8(array)
- id473950
- hashb83b3c3b48962562aa63241045780034
- created2020-10-28 01:55:20
- updated2020-10-28 01:55:20
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id251529
- filewebroot/files/Media/File/CkeditorXs/5f98c17841108.jpg
- size4501
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 9(array)
- id473951
- hash55cee51ed0926c5ba0e15a535015107a
- created2020-10-28 01:55:20
- updated2020-10-28 01:55:20
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id251529
- filewebroot/files/Media/File/CkeditorSm/5f98c17887444.jpg
- size14377
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 10(array)
- id473952
- hash6ec5bd31a96c7eba7794b685dcbd8e7e
- created2020-10-28 01:55:20
- updated2020-10-28 01:55:20
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id251529
- filewebroot/files/Media/File/CkeditorMd/5f98c178bc52e.jpg
- size23093
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 11(array)
- id473953
- hash102b970c5b6143060b6f32cff163ce05
- created2020-10-28 01:55:21
- updated2020-10-28 01:55:21
- modelMedia
- fieldfile
- foreign_key6579
- aliasbergfuehrer-schwarzenberger-in-den-berchtesgadener-alpen-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id251529
- filewebroot/files/Media/File/CkeditorLg/5f98c178eedfb.jpg
- size50996
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id8218
- mountain_guide_qualification_id1
- mountain_guide_id196
- position(null)
- 0(array)
- MountainGuide(array)
- 6(array)
- MountainGuide(array)
- id153
- hash19309ac6291da6a2d5b68692bc2658ce
- created2017-06-16 17:06:12
- updated2025-05-20 14:56:37
- mountain_guide_typeclose_circle
- mountain_guide_salutationmr
- mountain_guide_nameMichael
- mountain_guide_lastnameAigner
- mountain_guide_streetHemerach 19
- mountain_guide_zip5583
- mountain_guide_cityMuhr
- mountain_guide_countryAT
- mountain_guide_nationalityAT
- mountain_guide_languagede
- mountain_guide_mobile+436602130699
- mountain_guide_phone
- mountain_guide_email
- mountain_guide_birthday1973-09-09
- bank_account_holder_lastnameAigner
- bank_account_holder_nameMichael
- bank_account_number
- bank_code
- bank_nameRaiffeisenbank St. Michael Oberlungau
- bank_ibanAT263506100001019785
- bank_bicRVSAAT2S061
- tax_number90040/6554
- vat_number
- mountain_guide_education0
- height178
- clothing_comment
- passport_numberP 5352754
- id_number
- comment
- alpine_club_numberMitglied Nr. /Kateg./EJ 515-006370/A/12
- adac_numberÖAMTC Card Nr: 17990557
- other_insurancesDienstausweis BMLVS S/001717
- youtube
- emergency_contact_relationFreundin
- emergency_contact_salutationmrs
- emergency_contact_nameCarmen
- emergency_contact_lastnameSchulz
- emergency_contact_streetAn der Schanz 4
- emergency_contact_zip83435
- emergency_contact_cityBad Reichenhall
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile004915222916949
- emergency_contact_phone004986519514083
- emergency_contact_emailschulzcarmen@hotmail.com
- firm_id1
- ws_text_content<h2>Bergführer Michael Aigner</h2> <p>Geboren und aufgewachsen ist Michael im schönen Salzburger Lungau und hat so schon früh die Begeisterung und Liebe zu den Bergen entdeckt. Durch den berufsbedingten Umzug nach Bad Reichenhall hat sich eine besondere Beziehung zu den Berchtesgadener Bergen entwickelt. Ob rund um den Watzmann oder in den Wänden am Untersberg beim Klettern, da fühlt er sich wohl. Aber auch die kombinierten Touren in den Ost- und Westalpen üben einen ganz besonderen Reiz auf ihn aus. Als Heeresbergführer hat er auch hauptberuflich hohes Verantwortungsbewusstsein gegenüber seinen Soldaten und konnte mit dem Abschluss der zivilen Bergführerausbildung seinen alpinistischen Horizont erweitern! Er ist begeisterter Kletterer und Alpinist, egal ob Skitouren, Hochtouren, besonders fasziniert vom Eisklettern - er ist immer offen für neue Erfahrungen und Herausforderungen.</p>
- ws_text_motivation<div style="text-align:start">Ich schätze das Arbeiten in der freien Natur! Ein kleines, aber intensives Stück Glück oben in den Bergen, das ist es was mich so faziniert! Der Weg dorthin ist Schweiß, ist Fels, ist Eis, übersät mit Stolpersteinen und Glücksperlen. Ich habe diese Momente gerne für mich und teile sie natürlich mit netten, motivierten Leuten!</div>
- ws_text_out_of_apline_hobbies<ul> <li>Jagd</li> <li>Triathlon</li> <li>Langlauf</li> </ul>
- ws_text_personal_information
- ws_text_additional_qualifications
- member_id7501
- previous_url
- statusactive
- exact_shoe_size10
- exact_trousers_size48
- exact_trousers_large(false)
- exact_jacket_size48
- exact_shirt_size48
- last_api_call2025-07-15 21:04:38
- tax_countryAT
- tax_obligation(true)
- aspirant_contract_hh(false)
- aspirant_contract_hs(false)
- wise_card(false)
- clothing_package_2022
- clothing_package_2023
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 390.00 € | Bergführer Ostalpen 330.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameMichael Aigner
- Route(array)
- id2080
- hash8522cd751a68e16ae170fef4d9eaaaf9
- created2017-06-16 17:06:12
- updated2025-05-20 14:56:37
- modelMountainGuide
- foreign_key153
- base/
- aliasmichael-aigner-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft4971
- rght4972
- route/michael-aigner-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id7432
- hashbe7171ea901979170902db32c1d82c15
- created2020-05-14 10:29:30
- updated2020-05-14 10:30:31
- titleBergführer Michael Aigner am Berner Dreigestirn
- cross_reference_count2
- MediaEntity(array)
- id565406
- pos1
- media_id7432
- modelMountainGuide
- fieldteaser_image
- foreign_key153
- FileUpload(array)
- 0(array)
- id353228
- hash97cabe9aaaeae20c145f9c6969f1e105
- created2020-05-14 10:29:00
- updated2020-05-14 10:29:30
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5ebd016aabdd5.jpg
- size395032
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id762074
- hash8d3d53f0abf642dc7d8c596c69ecbc6f
- created2024-04-15 15:28:16
- updated2024-04-15 15:28:16
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id353228
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/661d2b6feff98.jpg
- size37119
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 2(array)
- id762075
- hash07ec233c811ab84b4667c6f43215f96b
- created2024-04-15 15:28:16
- updated2024-04-15 15:28:16
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id353228
- filewebroot/files/Media/File/ThMountainGuideAvatar/661d2b7032927.jpg
- size1700
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 3(array)
- id762078
- hash0984ebab8dfc2715b148fbbf1c91e2bd
- created2024-04-15 15:28:16
- updated2024-04-15 15:28:16
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id353228
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/661d2b70c7c26.jpg
- size37119
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 4(array)
- id478457
- hash14bb6d86ecd19d17a7af4dd4e31241d7
- created2020-10-28 02:10:32
- updated2020-10-28 02:10:32
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id353228
- filewebroot/files/Media/File/ThMediaFileIndex/5f98c507d820f.jpg
- size17657
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 5(array)
- id478458
- hashfde0907ba5810e2d1de48e084d8fe526
- created2020-10-28 02:10:32
- updated2020-10-28 02:10:32
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id353228
- filewebroot/files/Media/File/CkeditorXs/5f98c5081d151.jpg
- size6449
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 6(array)
- id478459
- hashe98ceec2487f63f007b621414d47bfff
- created2020-10-28 02:10:32
- updated2020-10-28 02:10:32
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id353228
- filewebroot/files/Media/File/CkeditorSm/5f98c508606d4.jpg
- size17657
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 7(array)
- id478460
- hashdbac1a77a3b1e6f16c915a257c477eb1
- created2020-10-28 02:10:32
- updated2020-10-28 02:10:32
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id353228
- filewebroot/files/Media/File/CkeditorMd/5f98c5089342c.jpg
- size26610
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 8(array)
- id478461
- hash89b2ffbadd98c259290758ab9da2f4be
- created2020-10-28 02:10:32
- updated2020-10-28 02:10:32
- modelMedia
- fieldfile
- foreign_key7432
- aliasbergfuehrer-michael-aigner-am-berner-dreigestirn-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id353228
- filewebroot/files/Media/File/CkeditorLg/5f98c508c4650.jpg
- size52483
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id8787
- mountain_guide_qualification_id1
- mountain_guide_id153
- position1
- 1(array)
- id2
- hash8474b4210a3c47611d3bca708c40832d
- created2016-09-11 14:08:16
- updated2019-04-24 09:47:08
- position5
- titleHeeresbergführer
- categoryhbf_pbf
- MountainGuideQualificationsMountainGuide(array)
- id8788
- mountain_guide_qualification_id2
- mountain_guide_id153
- position2
- 0(array)
- MountainGuide(array)
- 7(array)
- MountainGuide(array)
- id140
- hash1c780f2f078a13816b9e6d3aaacdfc57
- created2017-05-08 13:44:59
- updated2025-05-20 14:56:36
- mountain_guide_typeoccasional
- mountain_guide_salutationmr
- mountain_guide_nameMartin
- mountain_guide_lastnameSchidlowski
- mountain_guide_streetAmpfererstraße 50
- mountain_guide_zip6020
- mountain_guide_cityInnsbruck
- mountain_guide_countryAT
- mountain_guide_nationalityDE
- mountain_guide_languagede
- mountain_guide_mobile+4369918179957
- mountain_guide_phone+49865464777
- mountain_guide_email
- mountain_guide_birthday1990-07-13
- bank_account_holder_lastnameSchidlowski
- bank_account_holder_nameMartin
- bank_account_number
- bank_code
- bank_nameSparda-Bank München eG
- bank_ibanDE54700905000001969820
- bank_bicGENODEF1S04
- tax_number46390235783
- vat_number
- mountain_guide_education0
- height180
- clothing_comment
- passport_numberCF1KOWXP6
- id_numberLF1K056YM
- comment
- alpine_club_number081/00/012970
- adac_number
- other_insurances
- youtube
- emergency_contact_relationVater
- emergency_contact_salutationmr
- emergency_contact_namePeter
- emergency_contact_lastnameSchidlowski
- emergency_contact_streetRömerstraße 40
- emergency_contact_zip83404
- emergency_contact_cityAinring
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile+4917667979647
- emergency_contact_phone+49865464777
- emergency_contact_emailp.schidlowski@gmx.de
- firm_id3
- ws_text_content<h2><span>Bergführer Martin Schidlowski</span></h2> <p><span>Martin ist im Berchtesgadener Land aufgewachsen, wo ihn seine Eltern schon früh für die verschiedenen Spielformen des Bergsports begeistern konnten. Im Jugendalter war er häufig mit der Jugendgruppe des DAV Freilassing unterwegs, u. a. auf den ersten Hochtouren in den Westalpen. </span></p> <p><span>Im Jahr 2010 haben ihn die Berge (und das Bachelorstudium der Erdwissenschaften) in die Tiroler Hauptstadt Innsbruck verschlagen, wo er derzeit seinen Master im Fach Material- und Nanowissenschaften macht. Bevorzugt ist Martin beim Sport- und Alpinklettern sowie auf Skitouren und in kombinierten Wänden unterwegs. </span></p> <p><span>Expeditionen und Auslandsreisen zum Klettern und Bergsteigen haben ihn u. a. nach Peru, Kirgistan und Südafrika gebracht.</span></p>
- ws_text_motivation<div> <div> <div> <p>Als Bergführer unterwegs zu sein, ist die logische Konsequenz aus meinen bisherigen alpinen Touren. Es kann doch nichts Schöneres geben als das Hobby zum Beruf zu machen und alpine Erlebnisse mit Gästen zu teilen.</p> </div> </div> </div>
- ws_text_out_of_apline_hobbies<p><span>Klettern, Skitouren, Berglaufen, alpine Literatur und Reisen</span></p>
- ws_text_personal_information
- ws_text_additional_qualifications<ul> <li><span>MSc Material- und Nanowissenschaften</span></li> </ul>
- member_id7198
- previous_url
- statusactive
- exact_shoe_size9.5
- exact_trousers_size46
- exact_trousers_large(false)
- exact_jacket_size48
- exact_shirt_size48
- last_api_call2025-06-22 16:27:11
- tax_countryAT
- tax_obligation(false)
- aspirant_contract_hh(true)
- aspirant_contract_hs(false)
- wise_card(false)
- clothing_package_2022
- clothing_package_2023
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 390.00 € | Bergführer Ostalpen 330.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameMartin Schidlowski
- Route(array)
- id1985
- hash2126d989fab381d04cccef90547d1d5e
- created2017-05-08 13:44:59
- updated2025-05-20 14:56:37
- modelMountainGuide
- foreign_key140
- base/
- aliasmartin-schidlowski-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft4939
- rght4940
- route/martin-schidlowski-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id6525
- hasha9656714c38cedd7f0d3d6d9d0349fab
- created2019-03-19 12:03:15
- updated2019-03-19 12:03:15
- titleMartin_Schidlowski_Bergführer_Zugspitze
- cross_reference_count2
- MediaEntity(array)
- id545055
- pos1
- media_id6525
- modelMountainGuide
- fieldteaser_image
- foreign_key140
- FileUpload(array)
- 0(array)
- id245792
- hasha7dc5d7cb1a7b8ce5d94cc4f2ce0d3f4
- created2019-03-19 12:02:50
- updated2019-03-19 12:03:15
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5c90cc73376cf.jpg
- size227669
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id473703
- hash99ac9db982c8c44187aef6aa7a1675d3
- created2020-10-28 01:54:28
- updated2020-10-28 01:54:28
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id245792
- filewebroot/files/Media/File/ThMediaFileIndex/5f98c14459118.jpg
- size14396
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 2(array)
- id473704
- hash3bddebed4df3ff488b06f716eb3727dc
- created2020-10-28 01:54:28
- updated2020-10-28 01:54:28
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id245792
- filewebroot/files/Media/File/CkeditorXs/5f98c1449333d.jpg
- size4487
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 3(array)
- id473705
- hashc534bdd4e2cdc08fc6723568c036315c
- created2020-10-28 01:54:29
- updated2020-10-28 01:54:29
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id245792
- filewebroot/files/Media/File/CkeditorSm/5f98c144d807c.jpg
- size14396
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 4(array)
- id473706
- hash11e38e9452737b6295f77b46824f94a2
- created2020-10-28 01:54:29
- updated2020-10-28 01:54:29
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id245792
- filewebroot/files/Media/File/CkeditorMd/5f98c1451aa82.jpg
- size23290
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 5(array)
- id473707
- hash5efeca8c527ecd77da3aea498a4e34d4
- created2020-10-28 01:54:29
- updated2020-10-28 01:54:29
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id245792
- filewebroot/files/Media/File/CkeditorLg/5f98c1454a968.jpg
- size50759
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 6(array)
- id732891
- hashc811d7cebb2fbd5444e70b6b881943b2
- created2023-11-29 09:53:01
- updated2023-11-29 09:53:01
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id245792
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/6566fbecc043e.jpg
- size71609
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 7(array)
- id732892
- hash8fdd844ada6f8eac9f0d115cf7f7070d
- created2023-11-29 09:53:01
- updated2023-11-29 09:53:01
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id245792
- filewebroot/files/Media/File/ThMountainGuideAvatar/6566fbed11145.jpg
- size1369
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 8(array)
- id732896
- hashb7c2efeb0543b34c57b031babc55c0c5
- created2023-11-29 09:53:02
- updated2023-11-29 09:53:02
- modelMedia
- fieldfile
- foreign_key6525
- aliasmartin-schidlowski-bergfu-hrer-zugspitze-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id245792
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/6566fbee02a31.jpg
- size71609
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id8541
- mountain_guide_qualification_id1
- mountain_guide_id140
- position1
- 0(array)
- MountainGuide(array)
- 8(array)
- MountainGuide(array)
- id167
- hash022f7ca9e5168155afa16dc4bfe3733c
- created2017-10-26 16:50:16
- updated2025-05-22 16:54:09
- mountain_guide_typenone
- mountain_guide_salutationmr
- mountain_guide_nameMarkus
- mountain_guide_lastnameDillmann
- mountain_guide_streetHendenham 22
- mountain_guide_zip83112
- mountain_guide_cityFrasdorf
- mountain_guide_countryDE
- mountain_guide_nationalityDE
- mountain_guide_languagede
- mountain_guide_mobile+491798642862
- mountain_guide_phone+4980528249765
- mountain_guide_email
- mountain_guide_birthday1986-08-25
- bank_account_holder_lastnameDillmann
- bank_account_holder_nameMarkus
- bank_account_number
- bank_code
- bank_namePostbank
- bank_ibanDE 83 7601 0085 0435 1828 58
- bank_bicPBNKDEFF
- tax_number67592051349
- vat_number
- mountain_guide_education0
- height178
- clothing_comment
- passport_number
- id_numberLF08RZZ3Z
- comment
- alpine_club_number181/00/605541
- adac_number
- other_insurances
- youtube
- emergency_contact_relationFreundin
- emergency_contact_salutationmrs
- emergency_contact_nameReiter
- emergency_contact_lastnameVreni
- emergency_contact_streetWaschau 12
- emergency_contact_zip83317
- emergency_contact_cityTeisendorf
- emergency_contact_countryDE
- emergency_contact_languagede
- emergency_contact_mobile+4915156146159
- emergency_contact_phone+4986667916
- emergency_contact_email
- firm_id1
- ws_text_content<h2>Bergführer Markus Dillmann</h2> <p>Markus ist in München aufgewachsen und zog nach dem Abschluss seines Studiums für das Lehramt in Mathe und Sport ins Berchtesgadener Land. Seine große Leidenschaft fürs Freeriden und Skitourengehen sowie Alpin- und Sportklettern haben ihn schon in die verschiedensten Länder gebracht.</p>
- ws_text_motivation<p>Die Erlebnisse in den Bergen und das was man selbst am liebsten macht, mit anderen Menschen teilen und ihnen unvergessliche Momente schenken zu können, motiviert mich jedes Mal aufs Neue gemeinsam draußen unterwegs zu sein.</p>
- ws_text_out_of_apline_hobbies<p>Gibt es noch was anderes außer Freunde, Familie und Berge?</p>
- ws_text_personal_information
- ws_text_additional_qualifications<ul> <li>Skilehrer Level 3</li> <li>Snowboardlehrer Level 3</li> <li>Sportkletter-Trainer C</li> </ul>
- member_id8328
- previous_url
- statusactive
- exact_shoe_size8.5
- exact_trousers_size48
- exact_trousers_large(false)
- exact_jacket_size48
- exact_shirt_size48
- last_api_call2025-06-30 11:31:54
- tax_country(null)
- tax_obligation(false)
- aspirant_contract_hh(true)
- aspirant_contract_hs(false)
- wise_card(false)
- clothing_package_2022
- clothing_package_2023
- importancenone
- clothing_package_planning_2022(false)
- clothing_package_planning_2023(false)
- daily_ratesBergführer Westalpen 390.00 € | Bergführer Ostalpen 330.00 € | Skireisen (Flug/Außerhalb Alpen) 280.00 € | Kletterreisen (Flug) 270.00 € | Trekking & Expeditionen 280.00 € | Kletterkurse (Mittelgebirge) 240.00 € | Watzmann Ostwand Pauschale 650.00 € | Matterhorn Pauschale 1100.00 € | Wandern-Ostalpen 240.00 € | Wandern-Westalpen 250.00 € | Jubiläumsgrat Pauschale 420.00 €
- fullnameMarkus Dillmann
- Route(array)
- id2235
- hash4c0add298f209edf97db44810d8e5230
- created2017-10-26 16:50:16
- updated2025-05-22 16:54:10
- modelMountainGuide
- foreign_key167
- base/
- aliasmarkus-dillmann-bergfuehrer
- controllerFrontendMountainGuides.FrontendMountainGuides
- actionmountain_guide
- parent_id(null)
- lft5015
- rght5016
- route/markus-dillmann-bergfuehrer
- TeaserImageMedia(array)
- 0(array)
- id7437
- hash116294a661459a4b3a87470773c6cd71
- created2020-05-14 10:53:39
- updated2020-05-14 10:53:39
- titleBergführer Markus Dillmann auf Skitour am Wilden Kaiser
- cross_reference_count2
- MediaEntity(array)
- id670592
- pos1
- media_id7437
- modelMountainGuide
- fieldteaser_image
- foreign_key167
- FileUpload(array)
- 0(array)
- id353280
- hash4bb1bb7046c89b1a39426a3120bed81a
- created2020-05-14 10:53:13
- updated2020-05-14 10:53:39
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser.jpg
- thumbnail(null)
- parent_id(null)
- filewebroot/files/Media/File/5ebd0713affba.jpg
- size394726
- ext.jpg
- mimeimage/jpeg
- width1920
- height1080
- 1(array)
- id478482
- hash0cb01492eb891a5a7bf81cb7a0600473
- created2020-10-28 02:10:37
- updated2020-10-28 02:10:37
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-thmediafileindex.jpg
- thumbnailth-media-file-index
- parent_id353280
- filewebroot/files/Media/File/ThMediaFileIndex/5f98c50cf22bb.jpg
- size22116
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 2(array)
- id478483
- hash9a2ab0781398877cab3f7cc39b94111f
- created2020-10-28 02:10:37
- updated2020-10-28 02:10:37
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-ckeditorxs.jpg
- thumbnailckeditor_xs
- parent_id353280
- filewebroot/files/Media/File/CkeditorXs/5f98c50d2a64d.jpg
- size7251
- ext.jpg
- mimeimage/jpeg
- width80
- height45
- 3(array)
- id478484
- hash9b697da016b436639b8040be836badbe
- created2020-10-28 02:10:37
- updated2020-10-28 02:10:37
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-ckeditorsm.jpg
- thumbnailckeditor_sm
- parent_id353280
- filewebroot/files/Media/File/CkeditorSm/5f98c50d63fba.jpg
- size22116
- ext.jpg
- mimeimage/jpeg
- width150
- height84
- 4(array)
- id478485
- hash8f1b6b207dac1a6787dfd53c909ac8bd
- created2020-10-28 02:10:37
- updated2020-10-28 02:10:37
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-ckeditormd.jpg
- thumbnailckeditor_md
- parent_id353280
- filewebroot/files/Media/File/CkeditorMd/5f98c50d8e68b.jpg
- size34781
- ext.jpg
- mimeimage/jpeg
- width200
- height112
- 5(array)
- id478486
- hashb05a0c2f05d5af250ebfb10dd3c48e80
- created2020-10-28 02:10:37
- updated2020-10-28 02:10:37
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-ckeditorlg.jpg
- thumbnailckeditor_lg
- parent_id353280
- filewebroot/files/Media/File/CkeditorLg/5f98c50db5b84.jpg
- size73098
- ext.jpg
- mimeimage/jpeg
- width300
- height168
- 6(array)
- id900217
- hashe1720c290750892a049803a46ef2c461
- created2025-05-22 16:54:09
- updated2025-05-22 16:54:09
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-thmountainguideteaserimage.jpg
- thumbnailth-mountain-guide-teaser-image
- parent_id353280
- filewebroot/files/Media/File/ThMountainGuideTeaserImage/682f3a9152caf.jpg
- size55904
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 7(array)
- id900218
- hashcfc9d50743e2f178edf2e053ea1e152e
- created2025-05-22 16:54:09
- updated2025-05-22 16:54:09
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-thmountainguideavatar.jpg
- thumbnailth-mountain-guide-avatar
- parent_id353280
- filewebroot/files/Media/File/ThMountainGuideAvatar/682f3a917478c.jpg
- size1796
- ext.jpg
- mimeimage/jpeg
- width50
- height50
- 8(array)
- id900219
- hashdfe0f430fa3aeffb11392657d891d7e8
- created2025-05-22 16:54:09
- updated2025-05-22 16:54:09
- modelMedia
- fieldfile
- foreign_key7437
- aliasbergfuehrer-markus-dillmann-auf-skitour-am-wilden-kaiser-thmountainguideheaderimage.jpg
- thumbnailth-mountain-guide-header-image
- parent_id353280
- filewebroot/files/Media/File/ThMountainGuideHeaderImage/682f3a919c64f.jpg
- size55904
- ext.jpg
- mimeimage/jpeg
- width750
- height421
- 0(array)
- 0(array)
- MountainGuideQualifications(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- MountainGuideQualificationsMountainGuide(array)
- id9784
- mountain_guide_qualification_id1
- mountain_guide_id167
- position1
- 0(array)
- MountainGuide(array)
- 0(array)
- row(array)
- Content(array)
- id905
- hash006cc9fc019403f47ca3277092695334
- created2017-03-01 15:17:14
- updated2020-12-28 16:33:23
- menu_id325
- position4
- typemountain_guide_index
- statusactive
- titleStaatl. gepr. Berg- und Skiführer IVBV
- layoutcol12
- language_id3
- 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)
- gmap_lat(null)
- gmap_long(null)
- gmap_zoom(null)
- gmap_type(null)
- gmap_marker(null)
- video_type(null)
- video_url(null)
- developer_template_code(null)
- teaser_external_target(null)
- developer_template_css(null)
- teaser_external_url(null)
- teaser_menu_id(null)
- developer_template_js(null)
- mosaic_gallery_type(null)
- teaser_tour_id(null)
- mountain_guide_tour_search_show_until_days(null)
- facebook_page_id(null)
- facebook_access_token(null)
- instagram_access_token(null)
- facebook_posts_limit(null)
- instagram_posts_limit(null)
- country_id(null)
- box(false)
- gallery_grid_gutter(null)
- box_with_bar(null)
- background_color(null)
- customer_news(null)
- travel_report_id(null)
- travel_report_categoryall
- placeholder_text(null)
- directionleft
- gmap
- published1
- isActive1
- Seo(array)
- id1752
- hash95bde6be9dae234aa64027a47b230c10
- created2017-03-01 15:17:14
- updated2020-12-28 16:33:23
- modelContent
- foreign_key905
- titleStaatlich geprüfte Berg und Skiführer am Watzmann
- descriptionHier findest Du alle staatlich geprüften Bergführer und Bergführerinnen die mit der IVBV Qualifikation am Watzmann unterwegs sind. Achte auf das IVBV Zeichen und erkenne den Profi am Berg.
- internal_keywords
- author
- tw_creator
- fb_author
- robots2
- sitemap_priority0.5
- ImageMedia(empty)
- MountainGuideQualification(array)
- 0(array)
- id1
- hashef76195b871f74ad238b6c9acbde20ba
- created2016-09-11 14:07:44
- updated2019-04-24 09:46:53
- position1
- titleStaatl. gepr. Berg- und Skiführer IVBV
- categorystate_approved
- ContentsMountainGuideQualification(array)
- id108
- content_id905
- mountain_guide_qualification_id1
- 1(array)
- id7
- hash94327117efef26d284ea70a455bf62b9
- created2016-09-12 06:25:05
- updated2023-01-04 13:59:41
- position2
- titleStaatl. gepr. Berg- u. Skiführerin IVBV
- categorystate_approved
- ContentsMountainGuideQualification(array)
- id109
- content_id905
- mountain_guide_qualification_id7
- 0(array)
- Content(array)
- faq(empty)
- minimalLayoutForLayout(false)
- $request->data(empty)
- $this->validationErrors(array)
- Route(empty)
- MountPoint(empty)
- Redirect(empty)
- Language(empty)
- Customer(empty)
- InvoicesForCustomerStatus(empty)
- EmailTemplate(empty)
- TagsTag(empty)
- TagEntity(empty)
- Bookings(empty)
- Services(empty)
- Tour(empty)
- Types(empty)
- TravelReport(empty)
- Firm(empty)
- Tours(empty)
- TravelOptions(empty)
- TourDate(empty)
- MountainGuides(empty)
- TeaserImageMedia(empty)
- MediaEntity(empty)
- GalleryMedia(empty)
- VideoThumbnailMedia(empty)
- Seo(empty)
- ImageMedia(empty)
- OutputChannel(empty)
- LogoMedia(empty)
- LogoHorizontalMedia(empty)
- MountainGuideQualification(empty)
- MountainGuide(empty)
- MountainGuideQualifications(empty)
- IconMedia(empty)
- MountainGuideDailyRate(empty)
- Region(empty)
- Accomodations(empty)
- TeaserMedia(empty)
- Accomodation(empty)
- AccomodationAlternatives(empty)
- Countries(empty)
- News(empty)
- FileMedia(empty)
- Teaser(empty)
- Country(empty)
- TourMainType(empty)
- FaqItem(empty)
- FaqSet(empty)
- FaqItems(empty)
- Content(empty)
- TourType(empty)
- Menu(empty)
- MemberGroup(empty)
- Member(empty)
- Parent(empty)
- HeaderImagesMedia(empty)
- Advantage(empty)
- ArticleContentMedia(empty)
- MosaicGalleryMedia(empty)
- BackgroundImageMedia(empty)
- PlaceholderImageMedia(empty)
- User(empty)
- Aro(empty)
- Aco(empty)
- Users(empty)
- Tag(empty)
- Tags(empty)
- ExclusionTags(empty)
- FaqItemsTourMainTypesForPackingList(empty)
- RegionAreas(empty)
- PackingListItems(empty)
- PackingList(empty)
- Transfers(empty)
- Booking(empty)
- TourServices(empty)
- FellowTraveller(empty)
- Invoice(empty)
- Setting(empty)
- ValueUpload(empty)
- Co2Items(empty)
- RecommendedAccomodations(empty)
- SimilarTours(empty)
- AccomodationImagesMedia(empty)
- EmailHeadMedia(empty)
- EventIconMedia(empty)
- PartnerLogoMedia(empty)
- TourFaqItemsForCustomer(empty)
- TourFaqItemsForMountainGuide(empty)
- Job(empty)
- TourMainTypes(empty)
- Microsite(empty)
- Microsites(empty)
- DisturberMedia(empty)
- FileUpload(empty)
- IconUpload(empty)
- HeaderVideoUpload(empty)
- AdvantagesMenu(empty)
- ContentsMountainGuideQualification(empty)
- MountainGuideQualificationsMountainGuide(empty)
- Highlight(empty)
- FlagUpload(empty)
- ContentsCountry(empty)
- ContentsTourType(empty)
- ContentsTourMainType(empty)
- ContentsTourDate(empty)
- ContentsTour(empty)
- ContentsFaqItem(empty)
- ContentsUser(empty)
- ContentsTag(empty)
- ContentsExclusionTag(empty)
- Loaded Helpers(array)
- 0Html
- 1Tree
- 2Upload
- 3Media
- 4Route
- 5Bs3Html
- 6Form
- 7SocialMedia
- 8LeafletJs
- 9Leaflet
- 10GMap
- 11Embed
- 12Layout
- 13Recaptcha
- 14ThirdPartyCookies
- 15RequestContent
- 16Enum
- 17Content
- 18BitMask
- 19Captcha
- 20Number
- 21SimpleGraph
- 22DebugTimer
- 23Toolbar
- 24Js
- 25HtmlToolbar
==== - mountainGuides(array)
-
Environment +
App Constants
Constant Value MH MH_IP BACKEND_APP_DIR contrance UPLOADS_APP /var/www/vhosts/alpinewelten.com/httpdocs/contrance/ UPLOAD_TMP_DIR tmp/uploads/ CakePHP Constants
Constant Value APP /var/www/vhosts/alpinewelten.com/httpdocs/ APP_DIR httpdocs APPLIBS /var/www/vhosts/alpinewelten.com/httpdocs/Lib/ CACHE /var/www/vhosts/alpinewelten.com/httpdocs/tmp/cache/ CAKE /var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/Cake/ CAKE_CORE_INCLUDE_PATH /var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib CORE_PATH /var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/ CAKE_VERSION 2.9.0 CSS /var/www/vhosts/alpinewelten.com/httpdocs/webroot/css/ CSS_URL css/ DS / FULL_BASE_URL https://www.bergsteigerschule-watzmann.de IMAGES /var/www/vhosts/alpinewelten.com/httpdocs/webroot/img/ IMAGES_URL img/ JS /var/www/vhosts/alpinewelten.com/httpdocs/webroot/js/ JS_URL js/ LOGS /var/www/vhosts/alpinewelten.com/httpdocs/tmp/logs/ ROOT /var/www/vhosts/alpinewelten.com TESTS /var/www/vhosts/alpinewelten.com/httpdocs/Test/ TMP /var/www/vhosts/alpinewelten.com/httpdocs/tmp/ VENDORS /var/www/vhosts/alpinewelten.com/vendors/ WEBROOT_DIR webroot WWW_ROOT /var/www/vhosts/alpinewelten.com/httpdocs/webroot/ PHP Environment
Environment Variable Value Php Version 7.2.34 User u3939483948 Home /var/www/vhosts/alpinewelten.com Script Name /webroot/index.php Request Uri /wf/watzmannfuehrer/die-watzmannfuehrer/staatl-gepr-berg-und-skifuehrer-ivbv Query String Request Method GET Server Protocol HTTP/1.0 Gateway Interface CGI/1.1 Redirect Url /webroot/wf/watzmannfuehrer/die-watzmannfuehrer/staatl-gepr-berg-und-skifuehrer-ivbv Remote Port 56598 Script Filename /var/www/vhosts/alpinewelten.com/httpdocs/webroot/index.php Server Admin root@localhost Context Document Root /var/www/vhosts/alpinewelten.com/httpdocs Context Prefix Request Scheme https Document Root /var/www/vhosts/alpinewelten.com/httpdocs Remote Addr 216.73.216.201 Server Port 443 Server Addr 85.236.49.170 Server Name www.bergsteigerschule-watzmann.de Server Software Apache Server Signature Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin Http Accept Encoding gzip, br, zstd, deflate Http User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) Http Accept */* Http Connection close Http X Accel Internal /internal-nginx-static-location Http X Real Ip 216.73.216.201 Http Host www.bergsteigerschule-watzmann.de Proxy-nokeepalive 1 Https on Passenger Download Native Support Binary 0 Passenger Compile Native Support Binary 0 Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Http Authorization Unique Id aHa2mDJwxq6TGJT0rklh3wAAAUY Redirect Status 200 Redirect Https on Redirect Passenger Download Native Support Binary 0 Redirect Passenger Compile Native Support Binary 0 Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Redirect Http Authorization Redirect Unique Id aHa2mDJwxq6TGJT0rklh3wAAAUY Redirect Redirect Status 200 Redirect Redirect Https on Redirect Redirect Passenger Download Native Support Binary 0 Redirect Redirect Passenger Compile Native Support Binary 0 Redirect Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Redirect Redirect Unique Id aHa2mDJwxq6TGJT0rklh3wAAAUY Fcgi Role RESPONDER Php Self /webroot/index.php Request Time Float 1752610456.2272 Request Time 1752610456 ==== -
Include +
Included Files
Include Paths
- 1/opt/plesk/php/7.2/share/pear
- 2-> /var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
- Behavior(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/AclBehavior.php
- Cache(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
- Component(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/AuthComponent.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SecurityComponent.php
- Config(array)
- 0APP/Config/core.php
- 1APP/Config/bootstrap.php
- 2APP/Config/language_country.php
- 3APP/Config/routes.php
- 4APP/Config/database.php
- 5APP/contrance/Config/database.php
- 6APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
- Controller(array)
- 0APP/Controller/AppController.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
- Datasource(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
- Error(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
- I18n(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
- 1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
- Log(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
- 4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
- Model(array)
- 0APP/Model/AppModel.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
- 4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
- 5APP/contrance/Vendor/Cake/lib/Cake/Model/Aro.php
- 6APP/contrance/Vendor/Cake/lib/Cake/Model/AclNode.php
- 7APP/contrance/Vendor/Cake/lib/Cake/Model/Aco.php
- Network(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
- 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
- 10APP/Lib/Util/LanguageUtil.php
- Routing(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
- 4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
- 5APP/Lib/Routing/Route/AliasRoute.php
- 6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
- Utility(array)
- 0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
- 1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
- 2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
- 3APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeNumber.php
- 4APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
- 5APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
- 6APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
- 7APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeTime.php
- 8APP/contrance/Vendor/Cake/lib/Cake/Utility/Security.php
- View(array)
- 0APP/View/Helper/AppHelper.php
- 1APP/contrance/Vendor/Cake/lib/Cake/View/Helper.php
- 2APP/contrance/Vendor/Cake/lib/Cake/View/View.php
- 3APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- 4APP/contrance/Vendor/Cake/lib/Cake/View/ViewBlock.php
- 5APP/contrance/Vendor/Cake/lib/Cake/View/Helper/TimeHelper.php
- 6APP/contrance/Vendor/Cake/lib/Cake/View/Helper/HtmlHelper.php
- Behavior(array)
- plugins(array)
- Accomodations(array)
- Config(array)
- 0Accomodations/Config/bootstrap.php
- Model(array)
- 0Accomodations/Model/Accomodation.php
- 1Accomodations/Model/AccomodationsAppModel.php
- Config(array)
- Advantages(array)
- Model(array)
- 0Advantages/Model/Advantage.php
- 1Advantages/Model/AdvantagesAppModel.php
- Model(array)
- ApiLogging(array)
- Config(array)
- 0ApiLogging/Config/routes.php
- Config(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/BarcodeNumberBehavior.php
- 9BaseData/Model/Behavior/HabtmBehavior.php
- 10BaseData/Model/Behavior/BitMaskBehavior.php
- 11BaseData/Model/Behavior/ListBehavior.php
- 12BaseData/Model/Behavior/LayoutBehavior.php
- Plugin(array)
- 0BaseData/View/Helper/EnumHelper.php
- Model(array)
- BaseTree(array)
- Model(array)
- 0BaseTree/Model/BaseTreeAppModel.php
- Model(array)
- Bookings(array)
- Config(array)
- 0Bookings/Config/bootstrap.php
- Model(array)
- 0Bookings/Model/Booking.php
- 1Bookings/Model/BookingsAppModel.php
- Config(array)
- Contents(array)
- Component(array)
- 0Contents/Controller/Component/EyepinApiComponent.php
- Model(array)
- 0Contents/Model/Content.php
- 1Contents/Model/ContentsAppModel.php
- Component(array)
- Countries(array)
- Model(array)
- 0Countries/Model/Country.php
- 1Countries/Model/CountriesAppModel.php
- Model(array)
- Customers(array)
- Model(array)
- 0Customers/Model/Customer.php
- 1Customers/Model/CustomersAppModel.php
- Model(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)
- Emails(array)
- Model(array)
- 0Emails/Model/EmailTemplate.php
- 1Emails/Model/EmailsAppModel.php
- Model(array)
- Faqs(array)
- Model(array)
- 0Faqs/Model/FaqItem.php
- 1Faqs/Model/FaqsAppModel.php
- 2Faqs/Model/FaqSet.php
- Model(array)
- FellowTravellers(array)
- Model(array)
- 0FellowTravellers/Model/FellowTraveller.php
- 1FellowTravellers/Model/FellowTravellersAppModel.php
- Model(array)
- Firms(array)
- Model(array)
- 0Firms/Model/Firm.php
- 1Firms/Model/FirmsAppModel.php
- Model(array)
- FrontendApi(array)
- Config(array)
- 0FrontendApi/Config/routes.php
- 1FrontendApi/Config/new_mountain_guide_api_routes.php
- Config(array)
- FrontendContents(array)
- Config(array)
- 0FrontendContents/Config/bootstrap.php
- Controller(array)
- 0FrontendContents/Controller/FrontendContentsController.php
- 1FrontendContents/Controller/FrontendContentsAppController.php
- Config(array)
- FrontendMembers(array)
- Config(array)
- 0FrontendMembers/Config/routes.php
- Config(array)
- FrontendTours(array)
- Config(array)
- 0FrontendTours/Config/bootstrap.php
- 1FrontendTours/Config/routes.php
- Config(array)
- FrontendUploads(array)
- Config(array)
- 0FrontendUploads/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/RecaptchaComponent.php
- 1FrontendUtils/Controller/Component/SwiftypeComponent.php
- 2FrontendUtils/Controller/Component/GoogleAnalyticsComponent.php
- 3FrontendUtils/Controller/Component/CaptchaComponent.php
- 4FrontendUtils/Controller/Component/SocialWallComponent.php
- Config(array)
- Invoices(array)
- Model(array)
- 0Invoices/Model/Invoice.php
- 1Invoices/Model/InvoicesAppModel.php
- Model(array)
- Languages(array)
- Behavior(array)
- 0Languages/Model/Behavior/LanguageBehavior.php
- Model(array)
- 0Languages/Model/Language.php
- 1Languages/Model/LanguagesAppModel.php
- Behavior(array)
- Mailchimp(array)
- Component(array)
- 0Mailchimp/Controller/Component/MandrillApiComponent.php
- Plugin(array)
- 0Mailchimp/Lib/Mandrill.php
- 1Mailchimp/Lib/Mandrill/Templates.php
- 2Mailchimp/Lib/Mandrill/Exports.php
- 3Mailchimp/Lib/Mandrill/Users.php
- 4Mailchimp/Lib/Mandrill/Rejects.php
- 5Mailchimp/Lib/Mandrill/Inbound.php
- 6Mailchimp/Lib/Mandrill/Tags.php
- 7Mailchimp/Lib/Mandrill/Messages.php
- 8Mailchimp/Lib/Mandrill/Whitelists.php
- 9Mailchimp/Lib/Mandrill/Ips.php
- 10Mailchimp/Lib/Mandrill/Internal.php
- 11Mailchimp/Lib/Mandrill/Subaccounts.php
- 12Mailchimp/Lib/Mandrill/Urls.php
- 13Mailchimp/Lib/Mandrill/Webhooks.php
- 14Mailchimp/Lib/Mandrill/Senders.php
- 15Mailchimp/Lib/Mandrill/Metadata.php
- 16Mailchimp/Lib/Mandrill/Exceptions.php
- Component(array)
- Media(array)
- Plugin(array)
- 0Media/View/Helper/MediaHelper.php
- Behavior(array)
- 0Media/Model/Behavior/MediaBehavior.php
- Model(array)
- 0Media/Model/Media.php
- 1Media/Model/MediaAppModel.php
- 2Media/Model/MediaEntity.php
- Plugin(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)
- Microsites(array)
- Model(array)
- 0Microsites/Model/Microsite.php
- 1Microsites/Model/MicrositesAppModel.php
- Model(array)
- MountPoints(array)
- Model(array)
- 0MountPoints/Model/MountPoint.php
- 1MountPoints/Model/MountPointsAppModel.php
- Model(array)
- MountainGuides(array)
- Model(array)
- 0MountainGuides/Model/MountainGuide.php
- 1MountainGuides/Model/MountainGuidesAppModel.php
- 2MountainGuides/Model/MountainGuideQualification.php
- 3MountainGuides/Model/MountainGuideDailyRate.php
- Model(array)
- News(array)
- Model(array)
- 0News/Model/News.php
- 1News/Model/NewsAppModel.php
- Model(array)
- Outdooractive(array)
- Behavior(array)
- 0Outdooractive/Model/Behavior/OAGeoBehavior.php
- 1Outdooractive/Model/Behavior/CMSInterfaceBehavior.php
- Model(array)
- 0Outdooractive/Model/Job.php
- 1Outdooractive/Model/JobsAppModel.php
- Behavior(array)
- PackingLists(array)
- Model(array)
- 0PackingLists/Model/PackingListItem.php
- 1PackingLists/Model/PackingListsAppModel.php
- 2PackingLists/Model/PackingList.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)
- Regions(array)
- Model(array)
- 0Regions/Model/Region.php
- 1Regions/Model/RegionsAppModel.php
- 2Regions/Model/RegionArea.php
- Model(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
- Model(array)
- 0Tags/Model/Tag.php
- 1Tags/Model/TagsAppModel.php
- Behavior(array)
- Tasks(array)
- Behavior(array)
- 0Tasks/Model/Behavior/TaskBehavior.php
- Behavior(array)
- Teasers(array)
- Behavior(array)
- 0Teasers/Model/Behavior/TeaserBehavior.php
- Model(array)
- 0Teasers/Model/Teaser.php
- 1Teasers/Model/TeasersAppModel.php
- Behavior(array)
- TourDates(array)
- Model(array)
- 0TourDates/Model/TourDate.php
- 1TourDates/Model/TourDatesAppModel.php
- Model(array)
- Tours(array)
- Model(array)
- 0Tours/Model/TourService.php
- 1Tours/Model/ToursAppModel.php
- 2Tours/Model/Tour.php
- 3Tours/Model/TourType.php
- 4Tours/Model/TourTravelOption.php
- 5Tours/Model/TourMainType.php
- 6Tours/Model/TourCo2Item.php
- Model(array)
- Transfers(array)
- Model(array)
- 0Transfers/Model/Transfer.php
- 1Transfers/Model/TransfersAppModel.php
- Model(array)
- TravelReports(array)
- Model(array)
- 0TravelReports/Model/TravelReport.php
- 1TravelReports/Model/TravelReportsAppModel.php
- Model(array)
- Uploads(array)
- Config(array)
- 0Uploads/Config/bootstrap.php
- Behavior(array)
- 0Uploads/Model/Behavior/UploadBehavior.php
- 1Uploads/Model/Behavior/TransformationBehavior.php
- Plugin(array)
- 0Uploads/View/Helper/UploadHelper.php
- Model(array)
- 0Uploads/Model/Upload.php
- 1Uploads/Model/UploadsAppModel.php
- Config(array)
- Users(array)
- Model(array)
- 0Users/Model/User.php
- 1Users/Model/UsersAppModel.php
- Behavior(array)
- 0Users/Model/Behavior/PasswordBehavior.php
- 1Users/Model/Behavior/ActivityBehavior.php
- Model(array)
- Accomodations(array)
====