1 -- Dodijeljene signature u skupini FA05
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,
14 left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
15 left join biblio on (biblioitems.biblionumber=biblio.biblionumber)
16 LEFT JOIN callnumbers on (items.itemcallnumber=callnumbers.callnumber)
17 where items.itemcallnumber is not null and items.itemcallnumber like 'FA05%'
18 group by biblio.biblionumber
19 order by items.itemcallnumber ;