1 -- Dodijeljene signature u skupini D0
2 select items.itype as vrstagrade,
3 items.itemcallnumber as novasignatura,
4 biblio.author as autor,
5 biblio.title as naslov,
6 biblioitems.publishercode as izdavac,
7 biblioitems.publicationyear as godina,
8 biblioitems.volume as svezak,
10 biblioitems.number as starasignatura,
13 left join biblio on (items.biblionumber=biblio.biblionumber)
14 left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
15 where items.itemcallnumber is not null and items.itemcallnumber like 'D0.%'
16 order by items.itemcallnumber ;