-
Notifications
You must be signed in to change notification settings - Fork 0
/
isbn-return.sql
35 lines (27 loc) · 3.07 KB
/
isbn-return.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
SELECT
--*
b.record_type_code||b.record_num||'a', b.title, p.call_number, p.barcode, r.last_checkin_gmt, r.checkout_total, r.renewal_total
FROM
sierra_view.item_record_property AS p
JOIN
sierra_view.item_record AS r
ON
p.item_record_id = r.id
JOIN
sierra_view.record_metadata AS m
ON
r.id = m.id
JOIN
sierra_view.bib_record_item_record_link AS L
ON
p.item_record_id = L.item_record_id
JOIN
sierra_view.bib_view AS b
ON
L.bib_record_id = b.id
WHERE
p.barcode
IN
(
'35054015305572','35054012779795','35054019057625','35054024224483','35054024789006','35054017264728','35054028361901','35054015305663','35054027104153','35054027104096','35054027384128','35054027384185','35054012393191','35054023434877','35054027259049','35054017265048','35054004516643','35054006384057','35054001548565','35054015517242','35054015517184','35054028485510','35054031024215','35054031434059','35054031669605','35054016856565','35054018300349','35054028485577','35054010637144','35054026602470','35054001617618','35054029378631','35054015896265','35054012375586','35054006146092','35054023579192','35054023579259','35054033662749','35054030577528','35054023464858','35054016072437','35054019063607','35054028046148','35054033774155','35054015371558','35054027638705','35054012688020','35054012688087','35054000608741','35054028117501','35054026841938','35054033603594','35054033660297','35054002511869','35054017274131','35054027762869','35054018664835','35054026287850','35054033152055','35054026385282','35054028485395','35054031615798','35054018113866','35054002262703','35054009865573','35054003758063','35054004574840','35054029679483','35054009509643','35054016004042','35054026127171','35054014588855','35054029287824','35054001332770','35054000398665','35054029573058','35054018716759','35054029528771','35054019220793','35054032341683','35054032341675','35054026371910','35054030302471','35054017048675','35054032691244','35054028441240','35054030819847','35054026026886','35054015759034','35054024274157','35054017116183','35054017116308','35054017116266','35054017116142','35054017116100','35054017116225','35054017116092','35054017116530','35054030506279','35054033942778','35054006243279','35054010933279','35054006708347','35054010933238','35054010933295','35054033456126','35054026562906','35054032813129','35054023304211','35054022414706','35054024230910','35054016840957','35054024141505','35054024141562','35054024141620','35054014051805','35054023311398','35054024620789','35054030790840','35054030790832','35054031229772','35054032967552','35054015604479','35054013108093','35054028127112','35054027515440','35054017116498','35054006416263','35054023998384','35054023997717','35054023650274','35054032273142','35054032273175','35054032273183','35054030790857','35054020206567','35054027285713','35054018679825','35054032273167','35054032273159','35054013069709','35054016009694','35054024650364','35054024650422','35054027390372','35054024242980','35054024513059','35054015914712','35054023998327','35054023998269','35054024304202','35054023998202','35054023336635','35054023336684','35054023336627','35054029376882','35054015517234'
)