https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35997 Victor Grousset/tuxayo <victor@tuxayo.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |victor@tuxayo.net --- Comment #5 from Victor Grousset/tuxayo <victor@tuxayo.net> --- Is the join on borrowernumber, biblionumber[1], item_level_request, holdingbranch[1] needed? `itemnumber` is not the primary key of tmp_holdsqueue so is it possible that twice the same itemnumber would be in the table? Even with 5 record level holds for the same patron on a record that has 4 item there is no duplication of itemnumber tmp_holdsqueue. Neither with multiple item level holds on the same item for different patrons. [1] these are 100% sure to be redundant. itemnumber implies biblionumber and holdingbranch -- You are receiving this mail because: You are watching all bug changes.