-- Dodijeljene signature u skupini FB03
select 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 stara_signatura,
	items.ccode as zbirka,
	items.timestamp 
from items 
left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) 
left join biblio on (biblioitems.biblionumber=biblio.biblionumber) 
where itemcallnumber like 'FB03%' 
order by itemcallnumber ;
