musicbrainz_db=> select * from (select e.id, jsonb_array_elements(ed.data#>'{old,attributes}') as attr from edit e join edit_data ed on ed.edit = e.id where e.type = 95) x where not exists (select 1 from link_attribute_type where id::text = x.attr->>'type');
 id | attr 
----------+-----------------------------------------
 14464944 | {"max": "1", "min": "1", "type": "253"}
 14464945 | {"max": "1", "min": "1", "type": "253"}
 14464946 | {"max": "1", "min": "1", "type": "253"}
 15773142 | {"max": "1", "min": "1", "type": "253"}
 16745649 | {"max": "1", "min": "1", "type": "253"}
 23193205 | {"max": 1, "min": 0, "type": 243}
 23727699 | {"max": 1, "min": 0, "type": 545}
 24273496 | {"max": 1, "min": 0, "type": 545}
 24273497 | {"max": 1, "min": 0, "type": 545}
 24273502 | {"max": 1, "min": 0, "type": 545}
 25853591 | {"max": 1, "min": 0, "type": 243}
 25680528 | {"max": 1, "min": 0, "type": 243}
 32291940 | {"max": 1, "min": 0, "type": 545}
 27524186 | {"max": 1, "min": 0, "type": 545}
 27524194 | {"max": 1, "min": 0, "type": 545}
 27524197 | {"max": 1, "min": 0, "type": 545}
 27772805 | {"max": 1, "min": 0, "type": 545}
(17 rows)