From a44d107d07e3109164ce30eb47f4861501a71e00 Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Fri, 14 Nov 2008 08:41:05 +0100 Subject: [PATCH] kom-signature/23-23.sql --- kom-signature/23-23.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 kom-signature/23-23.sql diff --git a/kom-signature/23-23.sql b/kom-signature/23-23.sql new file mode 100644 index 0000000..85b926a --- /dev/null +++ b/kom-signature/23-23.sql @@ -0,0 +1,18 @@ +-- Dodijeljene signature u skupini EC23 +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 'EC23%' +group by biblio.biblionumber +order by items.itemcallnumber ; -- 2.20.1