Why the left joins in wp-include/query.php?
|Reported by:||Denis-de-Bernardy||Owned by:|
|Component:||Optimization||Keywords:||has-patch tested commit|
While looking into #9635, I noticed a whole bunch of left joins in the main queries, where a straightforward join would usually seem perfectly valid.
Are there any reasons for them to be used? Asking, because imporperly used left joins can have devastating effects on a query's performance by forcing the join order.