https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26567
--- Comment #15 from Marcel de Rooy <[email protected]> --- (In reply to Katrin Fischer from comment #14) > Isn't in Discussion a bit harsh for a question? ;) > > Can you explain why the group or limit 1 is better than using a distinct? Isnt Failed QA a bit hard too? lol. Had no reason to fail here. Counter question: q| INNER JOIN (SELECT DISTINCT subscriptionid FROM subscriptionroutinglist) srl ON srl.subscriptionid = subscription.subscriptionid|; Doesnt this looks a bit odd? Joining a subselect. Probably we c/should compare performance on the various constructs. But I gladly get a response from the author of doing that all by myself ;) -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
