Captain Paralytic wrote:
> I would re-write this as implicit JOINs. It becomes much clearer what
> is happening.

I don't know what an "implicit" JOIN is, I will investigate...

> What indexes do you have built on this table?

Only the "path" has an index.

E.