I have tried several things to try and fix the display. Here is the latest attempt to fix the display on one entry for the topical heading Birds Vocalization. I have attached the authorities and related bib records involved. This is the undesired display where the subfield 0 is appear. --------------------------------- birds vocalization (no link on this heading) Note: Here are entered works on the process of sound production by birds. Works on the calls or songs produced by birds are entered under Birdsongs. Musical compositions having birds as their subject are entered under Birds--Songs and music. See Also From Tracing -- Topical Term Talking birds (1) SEE Heading -- Topical Term Birds Vocalization (7) birds vocalization cwmars 98017 (no link on this entry) See Also From Tracing -- Topical Term Birds Vocalization (7) SEE Heading -- Topical Term Talking birds (1) ---------------------------------
  • birds vocalization
  • birds vocalization cwmars 98017
    • --------------------------------------------------------------------- I did the following to try and correct this. 1. Remove entry from authority.simple_heading table DELETE FROM authority.simple_heading WHERE record IN (98017,98057); 2. Remove entry from metabib.browse_entry_simple_heading _map; DELETE FROM metabib.browse_entry_simple_heading_map WHERE id IN (SELECT m.id FROM metabib.browse_entry_simple_heading_map m LEFT JOIN authority.simple_heading ash ON m.simple_heading=ash.id WHERE ash.id IS NULL); 3. Remove entries from metabib.browse_entry SELECT id, value FROM metabib.browse_entry WHERE value~*'(Birds Vocalization)' OR value~*'(talking birds)'; id value 5867331 Talking birds 8326522 Stalking birds with color camera 9858958 Stalking birds with color camera : a presentation of 331 illus. in natural color from Kodachrome and Ektachrome photos., showing 266 species of North American birds 11118410 talking birds cwmars 98057 11153190 talking birds 13156473 birds vocalization north america 13156474 birds vocalization west u s 13156475 birds vocalization united states 13156476 birds vocalization canada western 13156477 birds vocalization 13156478 birds vocalization cwmars 98017 DELETE FROM metabib.browse_entry_simple_heading_map WHERE entry IN (13156477, 13156478, 11153190, 11118410); DELETE FROM metabib.browse_entry WHERE id IN (13156477, 13156478, 11153190, 11118410); --results in removing all headings for Birds Vocalization 4. Reingest authority for "Birds Vocalization" and "Talking Birds" UPDATE config.internal_flag SET enabled = 't' WHERE name = 'ingest.reingest.force_on_same_marc'; UPDATE authority.record_entry SET id = id WHERE id =98017; UPDATE authority.record_entry SET id = id WHERE id =98057; UPDATE config.internal_flag SET enabled = 't' WHERE name = 'ingest.reingest.force_on_same_marc'; The display is exactly the same as prior to running the code.