https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43714 --- Comment #5 from Lucas Gass (lukeg) <lucas@bywatersolutions.com> --- In stockrotations.pl: my $sritems = Koha::StockRotationItems->search( { 'stage.rota_id' => $params{rota_id} }, { prefetch => { stage => { 'stockrotationitems' => { 'itemnumber' => 'biblionumber' } } } } ); The prefetch is getting: the stages, then the stockrotationitems, then ALL the items in the stockrotationitems, then all those item's biblios. Does this once for EVERY item in the rota. There should be a less round about way to arrive here: { prefetch => [ 'stage', { itemnumber => 'biblionumber' } ] } -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.