SELECT d.TopupLevel
	,d.Value AS DenominationValue
	,ISNULL(sum(CashCount), 0) - ISNULL(sum(Debits.DebitCount), 0) AS CurrentSystemCount
FROM kioskdenominations d
LEFT JOIN kioskcashvalues v ON v.denominationvalue = d.value
	AND v.MachineID = d.MachineID
LEFT JOIN (
	SELECT d.ID AS denomination
		,ISNULL(CashCount, 0) AS DebitCount
	FROM KioskDenominations d
	LEFT JOIN KioskCashValues v ON v.denominationvalue = d.value
		AND v.MachineID = d.MachineID
	WHERE debit = 1
		AND SentToCashBox = 0
		AND LiftedDate IS NULL
		AND d.machineID = 'BFEBFBFF0003067822A5ED24'
	GROUP BY d.id
		,cashcount
	) debits ON debits.denomination = d.id
WHERE credit = 1
	AND SentToCashBox = 0
	AND LiftedDate IS NULL
	AND d.machineID = 'BFEBFBFF0003067822A5ED24'
GROUP BY d.Value

U0VMRUNUIGQuVG9wdXBMZXZlbAoJLGQuVmFsdWUgQVMgRGVub21pbmF0aW9uVmFsdWUKCSxJU05VTEwoc3VtKENhc2hDb3VudCksIDApIC0gSVNOVUxMKHN1bShEZWJpdHMuRGViaXRDb3VudCksIDApIEFTIEN1cnJlbnRTeXN0ZW1Db3VudApGUk9NIGtpb3NrZGVub21pbmF0aW9ucyBkCkxFRlQgSk9JTiBraW9za2Nhc2h2YWx1ZXMgdiBPTiB2LmRlbm9taW5hdGlvbnZhbHVlID0gZC52YWx1ZQoJQU5EIHYuTWFjaGluZUlEID0gZC5NYWNoaW5lSUQKTEVGVCBKT0lOICgKCVNFTEVDVCBkLklEIEFTIGRlbm9taW5hdGlvbgoJCSxJU05VTEwoQ2FzaENvdW50LCAwKSBBUyBEZWJpdENvdW50CglGUk9NIEtpb3NrRGVub21pbmF0aW9ucyBkCglMRUZUIEpPSU4gS2lvc2tDYXNoVmFsdWVzIHYgT04gdi5kZW5vbWluYXRpb252YWx1ZSA9IGQudmFsdWUKCQlBTkQgdi5NYWNoaW5lSUQgPSBkLk1hY2hpbmVJRAoJV0hFUkUgZGViaXQgPSAxCgkJQU5EIFNlbnRUb0Nhc2hCb3ggPSAwCgkJQU5EIExpZnRlZERhdGUgSVMgTlVMTAoJCUFORCBkLm1hY2hpbmVJRCA9ICdCRkVCRkJGRjAwMDMwNjc4MjJBNUVEMjQnCglHUk9VUCBCWSBkLmlkCgkJLGNhc2hjb3VudAoJKSBkZWJpdHMgT04gZGViaXRzLmRlbm9taW5hdGlvbiA9IGQuaWQKV0hFUkUgY3JlZGl0ID0gMQoJQU5EIFNlbnRUb0Nhc2hCb3ggPSAwCglBTkQgTGlmdGVkRGF0ZSBJUyBOVUxMCglBTkQgZC5tYWNoaW5lSUQgPSAnQkZFQkZCRkYwMDAzMDY3ODIyQTVFRDI0JwpHUk9VUCBCWSBkLlZhbHVl