asn neighbours table (sql)

-- SELECT ts,JSON_value(jdoc,CONCAT('$.names.',SUBSTRING_INDEX(k,':',-1))) _name, cast(SUBSTRING_INDEX(k,':',-1) AS  UNSIGNED) asn,rid FROM bh_cache WHERE k LIKE 'as-name:%'  oRDER BY 4 DESC;
-- SELECT rid,ts,r.*  FROM bh_cache a ,json_table(jdoc,'$' COLUMNS( holder VARCHAR(256) path '$.holder', announced BOOL path '$.announced', asn int UNSIGNED path '$.resource', lastChecked DATE path '$.query_endtime'   ) )r  WHERE k LIKE 'as-overview:%' ORDER BY 5 DESC;
SELECT * FROM (
sELECT rid,ts,cast(json_value(jdoc,'$.resource') AS UNSIGNED) asn, r.*, JSON_VALUE(jdoc,'$.query_endtime')lastChecked FROM bh_cache a , json_table(jdoc,'$.neighbours[*]' COLUMNS( peer int UNSIGNED path '$.asn', TYPE VARCHAR(15) path '$.type',POWER INT path '$.power',v4 INT path '$.v4_peers' ,v6 INT path '$.v6_peers' ) )r  WHERE k LIKE 'asn-neighbours:%'
) a WHERE asn=8075
ORDER BY type,v4 desc