From 7664c8319c071f614ca2c2ccc08d580c4d9bb7ad Mon Sep 17 00:00:00 2001 From: Marijana Glavica Date: Thu, 15 Apr 2010 14:41:23 +0200 Subject: [PATCH] signature/ang/prema_skupinama/06-06.sql --- signature/ang/prema_skupinama/06-06.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 signature/ang/prema_skupinama/06-06.sql diff --git a/signature/ang/prema_skupinama/06-06.sql b/signature/ang/prema_skupinama/06-06.sql new file mode 100644 index 0000000..1b7d26a --- /dev/null +++ b/signature/ang/prema_skupinama/06-06.sql @@ -0,0 +1,17 @@ +-- Dodijeljene signature u skupini FA06 +select count(biblio.biblionumber) as br_primjeraka, + callnumbers.count as br_signatura, + items.itemcallnumber as novasignatura, + biblio.author as autor, + biblio.title as naslov, + biblioitems.publicationyear as godina, + biblioitems.number as svezak, + items.biblionumber, + items.copynumber +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 'FA06%' +group by biblio.biblionumber +order by items.itemcallnumber ; -- 2.20.1