Hi, we use this contribution as sidebox in a website with thousends of motorbike spare parts and the huge amount of categories and products results in a massive production of this query:

SELECT COUNT( * ) AS total
FROM products p, products_to_categories p2c

And as you can imagine website gets slower and slower when there are many customers.

Is there a way to avoid the check to see if there are products in the categories? We have no empty categories, so it's useless for us and in some case we're so slow that I have to remove the sidebox for a while..

Thanks!!