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