khnshn

select t2.* from (select json_extract(replace(value, "'",'"'),'$[*]') as arr from rh23_game_session inner join rh23_property_instance on rh23_game_session.id=rh23_property_instance.game_session where property_tk='PPG_LOG') as t1,
JSON_TABLE(cast(t1.arr as NCHAR), '$[*]' COLUMNS (
                li INT PATH '$.li', ts BIGINT PATH '$.ts')
     ) t2