Untitled

select * from mbd_presentation.fuse_fbts_open_subs_activation
-- where FUSE_PLAN_ID = '0cd2b956-59b4-4023-9cbe-ea3119288407'
where  deferral_product_subtype not in ('AUEMP1MON0')
-- where entitlement_id in
-- where fuse_subscription_id in
-- where count(entitlement_id)>1
and reseller_id = 'optusau' --' like 'star%' --jioin' -- 'globeph' -- 'optusau' -- 'globeph' --'optusau' 'jioin'
-- -- 'jioin' -- mtnng' --' -- 'orangeeg'
-- where fuse_plan_id = 'a8323a46-2589-41bb-8a5d-0bd30d4d3b6d'
-- and test_subscription is null
-- and journal_currency_code = 'USD'
-- and accounting_date_local >='2024-01-01'
and accounting_date_local between '2024-07-01' and '2024-07-31'