with data as ( select id, count(fields->'001') as count_of_001_fields from ( select *, jsonb_array_elements((marc_records_lb.content #>> '{}')::jsonb -> 'fields') as fields from diku_mod_source_record_storage.marc_records_lb ) sub group by id having COUNT(fields->'001') > 1 ) select * from data order by count_of_001_fields desc