SQL for all big records

This SQL will give you links to all the bib records in your III catalog:  (Sierra Listserv, Craig Borman)



SELECT
--*
--p.best_title_norm,
--p.best_author_norm,
'http://your.iii.catalog.url.here/record=b' || m.record_num || '&' || 'title=' || p.best_title_norm || '&' || 'author=' || p.best_author_norm || '/'

FROM
sierra_view.record_metadata m

LEFT OUTER JOIN sierra_view.bib_record_property p
ON (m.id = p.bib_record_id)

WHERE
m.record_type_code = 'b'

AND
m.campus_code = ''

AND
m.deletion_date_gmt IS null

LIMIT 500
--OFFSET 1500000
;



https://github.com/joemontibello/iii-sql-queries