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