http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757
--- Comment #2 from Nicole C. Engard <[email protected]> --- Here's one: select i.location, s.type, count(s.datetime) as count from statistics s left join items i using (itemnumber) where i.location IN ('BOARDBK','EASYRDR','JAUDIOBK','JBIO','JDVD','JDVDNF','JDVDS7','JDVDSER','JFIC','JGRAPHIC','JLANG','JMUSIC','JMYS','JNF','JOS','JPER','JSPN','JVDV','KIWANIS','PICBOOK','SUMMER') AND s.datetime between <<Between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> and s.type in ('issue','renew','return') group by i.location, s.type -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
