iii-sql-queries

A collection of SQL queries for our Sierra db.

These SQL queries were created on an ad-hoc basis. Some are well-commented, others not so much. But at least if they're here, they're under version control, so there's that...

Name		Name	Last commit message	Last commit date
Latest commit History 25 Commits
001andnot003.sql		001andnot003.sql
1query.sql		1query.sql
ALThtmpm.sql		ALThtmpm.sql
BDLPatronquery.sql		BDLPatronquery.sql
BDitemslongloanperiod.sql		BDitemslongloanperiod.sql
BFcirc.sql		BFcirc.sql
LabelsScratch.sql		LabelsScratch.sql
README.md		README.md
_config.yml		_config.yml
allbibs.sql		allbibs.sql
allusersallprinters.sql		allusersallprinters.sql
almostgotit.sql		almostgotit.sql
badsubfieldtags.sql		badsubfieldtags.sql
badtotals.sql		badtotals.sql
barcode2irecnum.sql		barcode2irecnum.sql
barcodenotpipeZ.sql		barcodenotpipeZ.sql
bib-order-fund.sql		bib-order-fund.sql
bibholds.sql		bibholds.sql
bibid2recnum.sql		bibid2recnum.sql
bibnum2itemnum.sql		bibnum2itemnum.sql
bibrecords.sql		bibrecords.sql
bibvarfields.sql		bibvarfields.sql
blanksubfieldS.sql		blanksubfieldS.sql
boundwiths.sql		boundwiths.sql
brecnum+recid.sql		brecnum+recid.sql
byfund.sql		byfund.sql
callnumbercircreport.sql		callnumbercircreport.sql
candelaria.sql		candelaria.sql
circtrans.sql		circtrans.sql
clem.sql		clem.sql
clrsa.sql		clrsa.sql
controlfieldF.sql		controlfieldF.sql
countexpiringholds.sql		countexpiringholds.sql
coursereserves.sql		coursereserves.sql
coursereserves2.sql		coursereserves2.sql
currentqueries.sql		currentqueries.sql
dartid2recid.sql		dartid2recid.sql
desktopoptions.sql		desktopoptions.sql
dhmcnonloading.sql		dhmcnonloading.sql
duplicatebarcodes.sql		duplicatebarcodes.sql
dupmarcfields.sql		dupmarcfields.sql
dvdcallnum.sql		dvdcallnum.sql
examplequery.sql		examplequery.sql
faileddup050search.sql		faileddup050search.sql
feedbuilder.sql		feedbuilder.sql
feldbergcheckouts.sql		feldbergcheckouts.sql
find405-5-d.sql		find405-5-d.sql
findoclcnums.sql		findoclcnums.sql
genfeedbuilder.sql		genfeedbuilder.sql
hasholds.sql		hasholds.sql
hathitrust.sql		hathitrust.sql
htmpm.sql		htmpm.sql
htmpm2016.sql		htmpm2016.sql
htmpm2017.sql		htmpm2017.sql
htserials.sql		htserials.sql
htserials2016.sql		htserials2016.sql
htserials2018.sql		htserials2018.sql
htspm.sql		htspm.sql
htspm2.sql		htspm2.sql
htspm2016.sql		htspm2016.sql
indexedfields.sql		indexedfields.sql
initials+group.sql		initials+group.sql
invoicenum_chartstring.sql		invoicenum_chartstring.sql
itemcountsbyitype.sql		itemcountsbyitype.sql
itemsWmanybibs.sql		itemsWmanybibs.sql
itemsthathavebeenonreserve.sql		itemsthathavebeenonreserve.sql
kresgeisbn.sql		kresgeisbn.sql
labels.sql		labels.sql
laddquery.sql		laddquery.sql
lastautovac.sql		lastautovac.sql
leachquery.sql		leachquery.sql
loanruledet.sql		loanruledet.sql
loanrulemodeller.sql		loanrulemodeller.sql
locationnotinbiboritem.sql		locationnotinbiboritem.sql
lotsofitems.sql		lotsofitems.sql
lowuselocs.sql		lowuselocs.sql
marctagcounts.sql		marctagcounts.sql
miloptions.sql		miloptions.sql
mostcirculated.sql		mostcirculated.sql
multiplesubfieldbs.sql		multiplesubfieldbs.sql
multvarfieldssamevalue.sql		multvarfieldssamevalue.sql
needezproxy.sql		needezproxy.sql
newcirctrans.sql		newcirctrans.sql
newhtspm.sql		newhtspm.sql
orphanedrecords.sql		orphanedrecords.sql
patronreadinghistory.sql		patronreadinghistory.sql
patronswithspaces.sql		patronswithspaces.sql
patronuid2recid.sql		patronuid2recid.sql
patwithodues.sql		patwithodues.sql
printerusers.sql		printerusers.sql
priv-renewloanrule.sql		priv-renewloanrule.sql
privhasholds.sql		privhasholds.sql
qtl.sql		qtl.sql
readinghistory.sql		readinghistory.sql
recentsbyselector.sql		recentsbyselector.sql
savemsmnewordershsci.sql		savemsmnewordershsci.sql
scratch.sql		scratch.sql
serialsforeric.sql		serialsforeric.sql
showdbbloat.sql		showdbbloat.sql
showdbbloat2.sql		showdbbloat2.sql

joemontibello/iii-sql-queries

Folders and files

Latest commit

History