qq2

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'
GROUP BY
	Customer.id
ORDER BY
	NULL;