egdb3_12_9
.metabib
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
browse_authority_refs_pivot(integer[], text)
Parameters
Name
Type
Mode
integer[]
IN
text
IN
Definition
SELECT mbe.id FROM metabib.browse_entry mbe JOIN metabib.browse_entry_simple_heading_map mbeshm ON ( mbeshm.entry = mbe.id ) JOIN authority.simple_heading ash ON ( mbeshm.simple_heading = ash.id ) JOIN authority.control_set_auth_field_metabib_field_map_refs_only map ON ( ash.atag = map.authority_field AND map.metabib_field = ANY($1) ) WHERE mbe.sort_value >= public.naco_normalize($2) ORDER BY mbe.sort_value, mbe.value LIMIT 1;