SELECT SQL_NO_CACHE
	Customer.id,
	'' AS totalClientes 
FROM
	Customer
	INNER JOIN FidelizationTransaction ON Customer.id = FidelizationTransaction.id_customer
	LEFT JOIN FidelizationProducts ON FidelizationProducts.id_fidelizationtransaction = FidelizationTransaction.id
	INNER JOIN CatalogProduct ON FidelizationProducts.id_catalogproduct = CatalogProduct.id 
WHERE
	Customer.NAME != '' 
	AND Customer.surname != '' 
	AND Customer.bt_status != 2 
	AND Customer.lastpurchasedate >= '2023-01-01 00:00:00' 
	AND Customer.lastpurchasedate <= '2023-07-01 23:59:59' 
	AND Customer.id_unit IN ( 15 ) 
	AND FidelizationTransaction.DATE >= '2023-01-01 00:00:00' 
	AND FidelizationTransaction.DATE <= '2023-07-01 23:59:59' 
	AND CatalogProduct.id_catalogcategory IN ( 1, 42 ) 
	AND CatalogProduct.id_subcatalogcategory IN ( 4, 9 ) 
GROUP BY
	Customer.id 
ORDER BY
	NULL;