1 create temporary table callnumbers ( callnumber varchar(255) primary key, count int not null ) ;
2 insert into callnumbers select itemcallnumber,count(itemcallnumber) from items where itemcallnumber like 'EF%' group by itemcallnumber ;
4 -- Dodijeljene signature u skupini EF00
5 select count(biblio.biblionumber) as primjeraka,
6 callnumbers.count as signatura,
7 items.itemcallnumber as novasignatura,
8 biblio.author as autor,
9 biblio.title as naslov,
10 biblioitems.publicationyear as godina,
11 biblioitems.volume as svezak,
13 biblioitems.number as starasignatura,
16 left join biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
17 left join biblio on (biblioitems.biblionumber=biblio.biblionumber)
18 LEFT JOIN callnumbers on (items.itemcallnumber=callnumbers.callnumber)
19 where items.itemcallnumber is not null and items.itemcallnumber like 'EF00%'
20 group by biblio.biblionumber
21 order by items.itemcallnumber ;