MySQL badly ‘optimized’ queries

I am having difficulties getting mysql to run my nicely structured sub-queries in an orderly manner. As it turns out I am not alone. The folks obviously do not plan on fixing this until mysql 5.2 is out. 5.1 has just reached RC status…. So what to do until it is fixed?

Have a look at the section called: How to force the inner query to execute first. Nice info!

http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/