Filipe Tomita wrote:
> Hi all,

I would suspect that your problems may be more from your subselects than
from your joins.

Make sure all your join fields can be accessed using an index and change the
subselects to joins too.