id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
9720	Why the left joins in wp-include/query.php?	Denis-de-Bernardy	anonymous	"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."	defect (bug)	closed	normal	2.8	Optimization	2.8	normal	fixed	has-patch tested commit