db tuning - some queries not using defined indexes?

[kobra]

You have not provided the server base system????

No matter, as tuning my.cnf is an item that hosts spend a huge amount of time on and are reluctant to share

[donplay]

Do you mean the server/install specs?

MySQL 5.0.90-community
PHP Version 5.2.9
Zen Cart 1.3.8
Dedicated machine with a lot of RAM

And all of the tables in the query have indexes on the primary keys and the columns in the where clauses, yet they aren't used. Maybe it's because of the LEFT JOIN, the distinct or some other parts of the query but I'm not sure. I tried googling around and didn't find a clear answer.

-d

You have not provided the server base system????

No matter, as tuning my.cnf is an item that hosts spend a huge amount of time on and are reluctant to share

[DrByte]

Something about that query is just wrong.
Where did you get it from? As in ... I can't find that query within Zen Cart anywhere. What addon is using that?