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 (`foreign_id` IN (: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`.`object_type` <> :dcValue11) AND (`r`.`sys_language_uid` = :dcValue12) AND (((`r`.`deleted` = 0) AND (`r`.`hidden` = 0) AND (`r`.`starttime` <= 1780766580) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780766580))))) ORDER BY FIELD(r.foreign_id,:dcValue13, :dcValue14, :dcValue15 ) ASC LIMIT 10

Extbase Variable Dump

array(15 items)
   dcValue1 => array(2 items)
      0 => '90' (2 chars)
      1 => '94' (2 chars)
   dcValue2 => array(3 items)
      0 => '84329095' (8 chars)
      1 => '812460' (6 chars)
      2 => '121263920' (9 chars)
   dcValue3 => 'sportclimbing_2018_route' (24 chars)
   dcValue4 => 'sportclimbing_2018_sector' (25 chars)
   dcValue5 => 'sportclimbing_2018' (18 chars)
   dcValue6 => 'gdi_piste' (9 chars)
   dcValue7 => 'gdi_lift' (8 chars)
   dcValue8 => 'climbing_route_2018_route' (25 chars)
   dcValue9 => 'climbing_route_2018_sector' (26 chars)
   dcValue10 => 'event' (5 chars)
   dcValue11 => 'event_phoenix' (13 chars)
   dcValue12 => 0 (integer)
   dcValue13 => '84329095' (8 chars)
   dcValue14 => '812460' (6 chars)
   dcValue15 => '121263920' (9 chars)

Eislaufen & Eisstockschießen am Achensee | Winterzauber in Tirol

Unterkünfte

Erlebnisse

Einzigartige Winter-Momente auf Eis!

Eislaufen & Eisstockschießen

Junge Mädchen kurven übers Eis, Pärchen ziehen Hand in Hand ihre Runden, kleine Kinder machen zögerlich erste kleine Schritte und werden dabei von rüstigen Senioren überholt: Eislaufen ist ein wunderbares Wintererlebnis für alle. Am schönsten ist es natürlich – wie am Achensee – in freier Natur, wo verschneite Berge im Publikum sitzen und euch zuschauen, wie ihr in der kühlen Winterluft genüsslich eure Runden dreht.

3 Suchergebnisse