-
SELECT 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.category_id=2532
INNER JOIN `catalog_product_entity_varchar` AS `cpev` ON e.entity_id = cpev.entity_id AND cpev.store_id = 0 AND cpev.attribute_id = (
SELECT attribute_id FROM eav_attribute WHERE attribute_code = "name" AND entity_type_id = (
SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = "catalog_product"
)
)
INNER JOIN `catalog_product_entity_varchar` AS `cpev1` ON e.entity_id = cpev1.entity_id AND cpev1.store_id = 0 AND cpev1.attribute_id = (
SELECT attribute_id FROM eav_attribute WHERE attribute_code = "banknote_102" AND entity_type_id = (
SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = "catalog_product"
)
)
COUNTRY/TERRITORY