Notice: Undefined index: filter_category_id in /var/www/vhosts/4shop.biz/httpdocs/dmanager_shop/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 898Notice: Error: Unknown column 'p2c.category_id' in 'where clause'
Error No: 1054
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2cc ON (p.product_id = p2cc.product_id) LEFT JOIN product_to_customer_groups p2cg ON (p2s.product_id = p2cg.p2cg_product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '2' AND p2cg.p2cg_product_id IS NULL OR p2c.category_id = '0' AND p2cg.p2cg_customer_group_id = '2' in /var/www/vhosts/4shop.biz/httpdocs/dmanager_shop/system/database/mysqliz.php on line 53