Re: Optimize Question

[Patrick Crowley]

I'm running 3.23.52 locally, but I just noticed my production server is
running 4.0.12.

Given the complexity of this query, should I use subqueries instead of
joins? Would that make any difference?

Best,
Patrick

> What version of mysql is this?  If you're running 3.23, does 4.0.14 do the
> same thing?  And if you can try it, does 4.1.0?