https://bugzilla.wikimedia.org/show_bug.cgi?id=30051
--- Comment #11 from Roan Kattouw <[email protected]> 2011-08-22 16:23:41 UTC --- Initial review notes at https://secure.wikimedia.org/wikipedia/mediawiki/wiki/User:Catrope/Extension_review/CollabWatchlist (In reply to comment #10) > I just had another look at the sub-select. To me it seems that there is no way > to rewrite that as a JOIN, because it's not a simple sub-select, but an > 'EXISTS', 'NOT EXISTS' sub-select, which IMHO is impossible to rewrite into a > JOIN. I'm open to suggestions for how to solve that differently in SQL, > though. NOT EXISTS can be rewritten into a LEFT JOIN with a WHERE something IS NULL. The EXISTS counterpart would be harder to do in this case because there are multiple tags involved. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
