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

pgAdmin error: MSVCP120.dll missing

Tried running pgAdmin, got error missing MSVCP120.dll

Downloaded Microsoft Visual C++ 2013 64 bit, still did not solve problem.


Turns out, have to download/install the x86 version, as well as x64 version,
even if you are running 64 bit Windows


From:
http://stackoverflow.com/questions/24726910/exe-gives-error-msvcp120-dll-is-missing-for-win7x64