Error filtering template: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5, query was: SELECT COUNT(DISTINCT ccp.product_id) AS NumberOfProducts FROM catalog_category_product ccp
left join catalog_product_entity_int as cpei on cpei.entity_id=ccp.product_id and cpei.attribute_id=99
left join catalog_product_entity_int as cpei2 on cpei2.entity_id=ccp.product_id and cpei2.attribute_id=97
left join catalog_product_entity as cpe on cpe.entity_id=ccp.product_id
WHERE cpei2.value = 1 AND cpei.value IN (2,4) AND cpe.type_id <> 'virtual' AND ccp.category_id =