Well, here's a new one that nobody has posted about. Strange because I know the field "master_categories_id" does exist in the table "zen_products" (this is the correct table prefix in my installation).

If anybody can point me in the right direction, I'd greatly appreciate it. Here is the error below. Doesn't matter what category you search or price range, it always is a problme with "p.master_categories_id"...

1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(distinct p.products_id) as total FROM zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_products_options po , zen_products_options_values pov LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND (p.products_status = 1 AND p2c.categories_id = 700 AND p.products_price >= 0 AND p.products_price <= 1000000 AND p.products_quantity > 0 AND p.products_id = pd.products_id AND p.products_id = p2c.products_id) ]