SlickSolutionsInc - 4:06 am on Mar 29, 2011 (gmt 0)

I am not familiar with the statistic but I took a swag at what the indexes should be.

The joins should be on indexed primary keys and indexed foreign keys.

e.productid AND e.fieldid = Index
e.fieldid = Index - May not need this but see what happens and delete if never used.
c.avail AND c.categoryid = Index
i.id = Index
p.forsale = Index

pc.productid = p.productid = PK and FK index
pc.categoryid = c.categoryid = PK and FK index
i.id = p.productid = PK and FK index