http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7872 Priority: P5 - low Change sponsored?: --- Bug ID: 7872 Assignee: gmcharlt@gmail.com Summary: C4::Items GetItemsInfo marc_subfield_structure SQL queries fetch all results and use first row QA Contact: koha.sekjal@gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: dpavlin@rot13.org Hardware: All Status: NEW Version: master Component: MARC Authority data support Product: Koha There are two queries without any WHERE which return more than one row, but use just first one (since they don't have order which one will be returned is database dependent). SELECT authorised_value FROM marc_subfield_structure WHERE kohafield="items.notforloan" SELECT authorised_value FROM marc_subfield_structure WHERE kohafield="items.restricted" -- You are receiving this mail because: You are watching all bug changes.