SELECT DISTINCT r.uid, r.foreign_id, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.difficulty')) AS metadata_string, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.route_length')) AS metadata_string FROM `tx_webxgsmap_domain_model_resource` `r` INNER JOIN `tx_webxgsmap_resource_category_mm` `mm_category` ON `r`.`uid` = `mm_category`.`uid_local` WHERE (`mm_category`.`uid_foreign` IN (:dcValue1)) AND (`r`.`object_type` <> :dcValue2) AND (`r`.`object_type` <> :dcValue3) AND (`r`.`object_type` <> :dcValue4) AND (`r`.`object_type` <> :dcValue5) AND (`r`.`object_type` <> :dcValue6) AND (`r`.`object_type` <> :dcValue7) AND (`r`.`object_type` <> :dcValue8) AND (`r`.`object_type` <> :dcValue9) AND (`r`.`object_type` <> :dcValue10) AND (`r`.`sys_language_uid` = :dcValue11) AND (((`r`.`deleted` = 0) AND (`r`.`hidden` = 0) AND (`r`.`starttime` <= 1780769520) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780769520))))) ORDER BY RAND() ASC LIMIT 10

Extbase Variable Dump

array(11 items)
   dcValue1 => array(2 items)
      0 => '2' (1 chars)
      1 => '509' (3 chars)
   dcValue2 => 'sportclimbing_2018_route' (24 chars)
   dcValue3 => 'sportclimbing_2018_sector' (25 chars)
   dcValue4 => 'sportclimbing_2018' (18 chars)
   dcValue5 => 'gdi_piste' (9 chars)
   dcValue6 => 'gdi_lift' (8 chars)
   dcValue7 => 'climbing_route_2018_route' (25 chars)
   dcValue8 => 'climbing_route_2018_sector' (26 chars)
   dcValue9 => 'event' (5 chars)
   dcValue10 => 'event_phoenix' (13 chars)
   dcValue11 => 0 (integer)

Gern Alm - Plumssattel - Plumsjochhütte - Gern Alm | Holiday Region Achensee

Unterkünfte

Erlebnisse

Gern Alm - Plumssattel - Plumsjochhütte - Gern Alm

Plumsjochhütte © Plumsjochhütte

am 1.669 Meter hohen Plumssattel © Achensee Tourismus

Gimp'l Park - Spielplatz bei der Gernalm © Gern Alm

auf der Mautstraße in Richtung Gern Alm - Blick zurück in Richtung Pletzachalm © Achensee Tourismus

Mautstraße in Richtung Gern Alm © Achensee Tourismus

Von der Gern Alm führt ein steiler Anstieg hinauf zum Plumssattel (1.669 Meter). Anschließend verläuft der Weg mäßig abfallend weiter zur Plumsjochhütte (1.630 Meter). Der Rückweg erfolgt auf derselben Strecke.

mehr

weniger