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` <= 1780773060) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780773060))))) 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)

Gramai Alm - Gramai Hochleger - Gramai Alm | Holiday Region Achensee

Unterkünfte

Erlebnisse

Gramai Alm - Gramai Hochleger - Gramai Alm

Der Gramai Hochleger auf 1.756 Metern Höhe. © Achensee Tourismus

die Gramai Alm - der markante Berg in der Bildmitte ist die Lamsenspitze © Achensee Tourismus

Gramai Alm am Schluss des Falzthurntales © Achensee Tourismus

Ausblick vom Gramai Hochleger © Karwendelmarsch

Von der Gramai Alm führt der Weg über die Brücke bis zum Schotterbett und von dort rechts auf dem steilen Steig hinauf zum Gramai Hochleger. Der Rückweg erfolgt über dieselbe Strecke.

mehr

weniger