Nick, I figured it out - we needed to limit to LOC authorized values:
SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS Circulations FROM (select i.location as loction, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal branch|branches>> and s.datetime between <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> group by i.location with rollup ) AS thingy LEFT JOIN authorised_values a on thingy.loction=a.authorised_value where a.category='LOC' On Tue, Mar 25, 2014 at 1:08 PM, Nick Clemens <n...@quecheelibrary.org> wrote: > Here's a thought, it might be an error in the authorized values., and I > think it is a bug > > I recreated it on our system by adding an authorized_value in a different > category with the same value as one in the LOC: > i.e. > I added AFIC to our Vendor category, with description Error! The system > doesn't throw an error, and I can't see that value in the listing, but it is > then 'Adult Fiction' is duplicated in my report > > Is the issue clear? > > > > > On Thu, Mar 20, 2014 at 7:04 PM, Nicole Engard <neng...@gmail.com> wrote: >> >> Okay, any idea why the Juveasy might be showing 2 times? >> >> http://screencast.com/t/6dbByW4eZ >> >> I added the location code in case that was it - they're identical as >> are their numbers. >> >> On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard <neng...@gmail.com> wrote: >> > Thank you so much Nick!! >> > >> > Nicole > > > > > -- > Nick Clemens > Quechee & Wilder Libraries > n...@quecheelibrary.org > http://www.QuecheeLibrary.org > Q (802) 295-1232 W (802) 295-6341 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha