[Koha] Stats for ILL between locations

[Nicole Engard]

I have one ... did I not add it to the wiki?

#this report shows the total number of items circulated from a branch
other than the owning branch

SELECT count(*) as total from statistics LEFT JOIN items on
(statistics.itemnumber = items.itemnumber) where statistics.branch !=
items.homebranch AND statistics.datetime between '2008-01-01' and
'2008-12-31'

#same except limited by branch

SELECT statistics.branch,count(*) as total from statistics LEFT JOIN
items on (statistics.itemnumber = items.itemnumber) where
statistics.branch != items.homebranch AND statistics.datetime between
'2008-01-01' and '2008-12-31' and items.homebranch = 'BRANCH' group by
statistics.branch

---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at liblime.com
AIM/Y!/Skype: nengard

http://liblime.com
http://blogs.liblime.com/open-sesame/



On Mon, May 4, 2009 at 9:45 AM,  <dschust1 at tx.rr.com> wrote:
> Anybody have an SQL or some type of report that shows how many books were borrowed between locations in a given time period?
>
> I will be adding a few SQL's that I've come up with to the Wiki hopefully today!  You all ROCK!
>
> David Schuster
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>