Error filtering template: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.segment_id' in 'where clause', query was: SELECT DISTINCT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 LEFT JOIN `panda_segments_products` AS `panda_s` ON e.entity_id = p.product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (panda_s.segment_id IS NULL OR p.segment_id NOT IN ('1')) AND (((IFNULL(`e`.`sku`, 0) IN ('MT07', 'MH07', 'MSH03', 'MP03') OR (FIND_IN_SET ('MT07', `e`.`sku`) > 0) OR (FIND_IN_SET ('MH07', `e`.`sku`) > 0) OR (FIND_IN_SET ('MSH03', `e`.`sku`) > 0) OR (FIND_IN_SET ('MP03', `e`.`sku`) > 0)) ))
Copyright © 2013-present Magento, Inc. All rights reserved.