create table tbl (id int, home json, away json, status int);
insert into tbl values
(1, '[{"id":10, "value":0}, {"id":20, "value":20}]', '[{"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