1 -- Dodijeljene signature u skupini BC10
3 callnumbers.count as signatura,
4 items.itemcallnumber as novasignatura,
5 biblio.author as autor,
6 biblio.title as naslov,
7 biblioitems.publicationyear as godina,
8 biblioitems.volume as svezak,
10 biblioitems.number as starasignatura,
13 left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
14 left join biblio on (biblioitems.biblionumber=biblio.biblionumber)
15 LEFT JOIN callnumbers on (items.itemcallnumber=callnumbers.callnumber)
16 where items.itemcallnumber is not null and items.itemcallnumber like 'BC10%'
17 order by items.itemcallnumber ;