From 727185757ba6b028d9f2077da6b95f1e6dbc8190 Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Tue, 3 Dec 2013 16:21:29 +0100 Subject: [PATCH] items/zs/knjige/02-PB2.sql --- items/zs/knjige/02-PB2.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 items/zs/knjige/02-PB2.sql diff --git a/items/zs/knjige/02-PB2.sql b/items/zs/knjige/02-PB2.sql new file mode 100644 index 0000000..36d065b --- /dev/null +++ b/items/zs/knjige/02-PB2.sql @@ -0,0 +1 @@ +select items.biblionumber, itemnumber, itemcallnumber as signatura, location as lokacija, ccode as zbirka, itemtype as vrsta_gradje, itype as vrsta_gradje_primjerak, frameworkcode, notforloan, onloan, damaged, itemlost, withdrawn from items join biblioitems on items.biblionumber=biblioitems.biblionumber join biblio on biblio.biblionumber=items.biblionumber where itemcallnumber like 'PB %' order by itemcallnumber limit 30001, 60000; -- 2.20.1