select sum(ta.labelCount) as transactions from tbl_FSR_OperatorActivity oa inner join ( select fa.ownerId, fa.ownerType, fa.fsrBusinessId, fa.tmpMonth, fa.tmpYear, fa.fsrProductName, count(*) labelCount from tbl_IMPORT_FoodServiceRewardsTransactions fa where fa.eai_batchId = and fa.fsrBusinessId is not null and fa.duplicate is null group by fa.ownerId, fa.ownerType, fa.fsrBusinessId, fa.tmpMonth, fa.tmpYear, fa.fsrProductName ) ta on ta.ownerId = oa.ownerId and ta.ownerType = oa.ownerType and ta.fsrBusinessId = oa.foodserviceRewardsId and ta.tmpMonth = oa.salesMonth and ta.tmpYear = oa.salesYear and ta.fsrProductName = oa.fsrProductName SELECT oa.fsrProductName, ta.labelCount, oa.salesMonth, oa.salesYear, oa.foodServiceRewardsId, oc.fsrBusName from tbl_FSR_OperatorActivity oa inner join tbl_FSR_OperatorCompanies oc on oc.ownerId = oa.ownerId and oc.ownerType = oa.ownerType and oc.foodServiceRewardsId = oa.foodServiceRewardsId inner join ( select fa.ownerId, fa.ownerType, fa.fsrBusinessId, fa.tmpMonth, fa.tmpYear, fa.fsrProductName, count(*) labelCount from tbl_IMPORT_FoodServiceRewardsTransactions fa where fa.eai_batchId = and fa.ownerId = and fa.ownerType = and fa.fsrBusinessId is not null group by fa.ownerId, fa.ownerType, fa.fsrBusinessId, fa.tmpMonth, fa.tmpYear, fa.fsrProductName ) ta on ta.ownerId = oa.ownerId and ta.ownerType = oa.ownerType and ta.fsrBusinessId = oa.foodserviceRewardsId and ta.tmpMonth = oa.salesMonth and ta.tmpYear = oa.salesYear and ta.fsrProductName = oa.fsrProductName select distinct fa.ownerId, fa.ownerType, fa.fsrBusinessId, fa.tmpMonth, fa.tmpYear, fa.fsrProductName from tbl_IMPORT_FoodServiceRewardsTransactions fa left outer join tbl_FSR_OperatorActivity oa on oa.foodserviceRewardsId = fa.fsrBusinessId and oa.salesMonth = fa.tmpMonth and oa.salesYear = fa.tmpYear and oa.fsrProductName = fa.fsrProductName and oa.ownerId = fa.ownerId and oa.ownerType = fa.ownerType where fa.eai_batchId = and fa.ownerId = and fa.ownerType = and ( fa.fsrBusinessId is null or fa.fseOperatorId is null )

#qmd_getSummary.transactions# Transactions Added

Transaction Results

Operator	FSR Product Name	Year	Month	Label Count
#fsrBusName#	#fsrProductName# #salesYear# #salesMonth# #labelCount#

FoodServiceReward Operators Not Found: #qmd_operatorsNotFound.recordcount#