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` <= 1776442320) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1776442320))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '46' (2 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 => 1 (integer)
Achenseehof | Holiday Region Achensee
Accommodations
Experiences

Achenseehof

Infrastructure on site

Hochplatte
to resources
Rosskopf
to resources
Juifen
to resources
Unnutz
to resources
Seekarspitze
to resources
Bärenkopf
to resources
Montscheinspitze
to resources
Rofanspitze
to resources
Schreckenspitze
to resources
Guffertspitze
to resources
Haidachstellwand
to resources
Dristenkopf
to resources
Seebergspitze
to resources
Ebner Joch
to resources
Feilkopf
to resources
Kotalmjoch
to resources
Hohe Gans
to resources
Rotspitze
to resources
Sonnjoch
to resources
Hochiss
to resources
Open
GPX File

Infrastructure on site

Hochplatte
to resources
Rosskopf
to resources
Juifen
to resources
Unnutz
to resources
Seekarspitze
to resources
Bärenkopf
to resources
Montscheinspitze
to resources
Rofanspitze
to resources
Schreckenspitze
to resources
Guffertspitze
to resources
Haidachstellwand
to resources
Dristenkopf
to resources
Seebergspitze
to resources
Ebner Joch
to resources
Feilkopf
to resources
Kotalmjoch
to resources
Hohe Gans
to resources
Rotspitze
to resources
Sonnjoch
to resources
Hochiss
to resources
EN

The item cannot be displayed. To see the item, accept the marketing cookies.

Open cookie settings
TVB Achensee KI Assist