From 5c013e7dd30f86bd20e7015570649aceaaf05f3d Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Thu, 4 Dec 2008 22:11:30 +0100 Subject: [PATCH] tur-signature/03-03.sql --- tur-signature/03-03.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 tur-signature/03-03.sql diff --git a/tur-signature/03-03.sql b/tur-signature/03-03.sql new file mode 100644 index 0000000..055baf9 --- /dev/null +++ b/tur-signature/03-03.sql @@ -0,0 +1,18 @@ +-- Dodijeljene signature u skupini EI03 +select count(biblio.biblionumber) as primjeraka, + 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 'EI03%' +group by biblio.biblionumber +order by items.itemcallnumber ; -- 2.20.1