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