I'm trying to work out a better query for you. If you get a chance, could you re-post your query with all the columns being aliased? You have columns in the SELECT clauses that do not contain aliases, so I am having trouble re-writing the query.

Also, any other info you could provide, such as all available indexes, what the explain plans are, etc would be most helpful.

Thanks,

- Chris