Kirchenwirt
The Kirchenwirt in Eben is located opposite the church St. Notburgakirche and the Notburga Museum. The typical Tirolean inn serves regional cuisine and Austrian home cooking.
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
array(11 items) dcValue1 => array(1 item) 0 => '114' (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 => 1 (integer)
The Kirchenwirt in Eben is located opposite the church St. Notburgakirche and the Notburga Museum. The typical Tirolean inn serves regional cuisine and Austrian home cooking.