 -- B4
 select *
 from analytics_invoice_adjustments b
-left outer join invoice_items ii on ii.id = b.item_id
-left outer join bundles bndl on ii.bundle_id = bndl.id
+left outer join bundles bndl on b.bundle_id = bndl.id
 where coalesce(bndl.external_key, 'NULL') != coalesce(b.bundle_external_key, 'NULL')
 ;
 



-- BUNDLE TAGS
/* table not currently used */

-- ACCOUNT TRANSITIONS

-- I1a TODO
select *
from blocking_states bs
left outer join analytics_account_transitions bos on bs.record_id = bos.blocking_state_record_id
