-- Dodijeljene signature u skupini BC17
select 
	callnumbers.count as signatura, 
	items.itemcallnumber as novasignatura,
	biblio.author as autor,
	biblio.title as naslov,
	biblioitems.publicationyear as godina,
	biblioitems.volume as svezak,
	items.biblionumber,
	biblioitems.number as starasignatura,
	items.timestamp 
from items 
left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) 
left join biblio on (biblioitems.biblionumber=biblio.biblionumber) 
LEFT JOIN callnumbers on (items.itemcallnumber=callnumbers.callnumber)
where items.itemcallnumber is not null and items.itemcallnumber like 'BC17%' 
order by items.itemcallnumber ;
