1 -- Dodijeljene signature u skupini FD16
2 select count(biblio.biblionumber) as primjeraka,
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 'FD16%'
17 group by biblio.biblionumber
18 order by items.itemcallnumber ;