http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11045 Bug ID: 11045 Summary: Wrong query in C4/Biblios.pm : join between biblioitems.itemtypes and itemtypes table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: gmcharlt@gmail.com Reporter: mathieu.saby@univ-rennes2.fr QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl C4::Biblios::GetBiblioData and GetBiblioItemData are doing : SELECT [...] itemtypes.notforloan [...] [...] LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype This is wrong becaause itemtypes table could be linked with items.itype (as in my library) and not with biblioitems.itemtype. M. Saby -- You are receiving this mail because: You are watching all bug changes.