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_objecttype_mm` `mm_object_type` ON `r`.`uid` = `mm_object_type`.`uid_local` WHERE (`mm_object_type`.`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` <= 1776414480) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1776414480))))) ORDER BY FIELD(r.foreign_id,:dcValue13, :dcValue14, :dcValue15, :dcValue16, :dcValue17, :dcValue18, :dcValue19, :dcValue20, :dcValue21, :dcValue22, :dcValue23, :dcValue24, :dcValue25 ) ASC LIMIT 4
array(25 items) dcValue1 => array(4 items) 0 => '42' (2 chars) 1 => '25' (2 chars) 2 => '18' (2 chars) 3 => '36' (2 chars) dcValue2 => array(13 items) 0 => '811995' (6 chars) 1 => '120184803' (9 chars) 2 => '811988' (6 chars) 3 => '121292352' (9 chars) 4 => '121499984' (9 chars) 5 => '121245467' (9 chars) 6 => '121667729' (9 chars) 7 => '121662297' (9 chars) 8 => '121499983' (9 chars) 9 => '1696048' (7 chars) 10 => '812003' (6 chars) 11 => '91591562' (8 chars) 12 => '115404847' (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 => '811995' (6 chars) dcValue14 => '120184803' (9 chars) dcValue15 => '811988' (6 chars) dcValue16 => '121292352' (9 chars) dcValue17 => '121499984' (9 chars) dcValue18 => '121245467' (9 chars) dcValue19 => '121667729' (9 chars) dcValue20 => '121662297' (9 chars) dcValue21 => '121499983' (9 chars) dcValue22 => '1696048' (7 chars) dcValue23 => '812003' (6 chars) dcValue24 => '91591562' (8 chars) dcValue25 => '115404847' (9 chars)