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