* Michael T. Babcock
> Its well appreciated to see examples of what works and what doesn't too;
> its nice to know how to get one's queries in an order that makes the
> MySQL optimizer's life easier. I'm trying to decide if there's some
> logical way to inform MySQL that it can reorder a series o
Here is the query that I had in a PhP script that joins a bunch of
tables (I'll try to make this look readable). If you're curious, it's for
a motorcross site (www.springcreekmx.com):
SELECT standings.rank, race.race_date, class.class_name,
racer.racer_name, cycle.cycle_desc, race_event.racer_