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

Achenseehof | Holiday Region Achensee

Achenseehof

Infrastruktur vor Ort

Seekarspitze

Hochplatte

Hohe Gans

Guffertspitze

Feilkopf

Kotalmjoch

Schreckenspitze

Juifen

Rosskopf

Montscheinspitze

Unnutz

Bärenkopf

Dristenkopf

Rotspitze

Rofanspitze

Seebergspitze

Sonnjoch

Haidachstellwand

Ebner Joch

Hochiss

Auf Karte anzeigen

Infrastruktur vor Ort

Seekarspitze

Hochplatte

Hohe Gans

Guffertspitze

Feilkopf

Kotalmjoch

Schreckenspitze

Juifen

Rosskopf

Montscheinspitze

Unnutz

Bärenkopf

Dristenkopf

Rotspitze

Rofanspitze

Seebergspitze

Sonnjoch

Haidachstellwand

Ebner Joch

Hochiss