https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21622 --- Comment #13 from Nick Clemens <nick@bywatersolutions.com> --- (In reply to Jonathan Druart from comment #11)
(In reply to Nick Clemens from comment #10)
I missed this one and filed 22260
I am wondering if one situation is preferable to the other (subquery vs adding all fields to group by)
Bug 20182 and 21723 imply there may be some issues here - can we get some opinions here on the best way to fix these situations?
Could you benchmark the 2 queries on a big production DB?
~.1 seconds for this solution vs ~4 seconds for the other Deprecated in favor of this one, we should invesitgate 21723 on its own I think -- You are receiving this mail because: You are watching all bug changes.