create table tbl (id int, home json, away json, status int);
insert into tbl values
(1, '[{"id":10, "value":0}]', '{"id":11, "value":0}', 3),
(2, '{"id":11, "value":0}', '{"id":10, "value":0}', 3),
(3, '{"id":10, "value":0}', '{"id":20, "value":0}', 3),
(4, '{"id":40, "value":0}', '{"id":10, "value":0}', 2);
select *
from tbl
where status = 3 and not json_contains(home, '11', '$.id') and not json_contains(away, '11', '$.id');;
Telegram: DB developers channel