select
                
                reg_id = ISNULL(dr1.reg_id, dr2.reg_id), -- changed  
                invitee_id = ISNULL(di1.invitee_id, di2.invitee_id), -- changed
                 
                contact_type = isnull(ct.cont_type_name, ''),  
                item_id = I.item_id,
                item_type = i.item_type,  
                item_category = I.item_category,  
                item_name = I.item_name,  
                item_code = I.item_code,  
                fee_name = f.fee_name,  
                start_date = I.session_start_date,
                end_date = I.session_end_date,
                reg_date = ae.created_date,  
                item_quantity = ae.prod_qty,  
                item_price = bd.bskt_dtl_price_tier_amt,  
                eligible_credit = I.credit_value,
                participant_flag = case
                                                                when pe.acct_id is null then 0
                                                                else 1 end,
                cv_acct_id = ae.acct_id,  
                cv_entity_stub = ae.entity_stub,  
                cv_entity_type_id = ae.entity_type_id,  
                cv_prod_stub = ae.prod_stub
        from [dbo].[ATTENDEE_ENTITY] ae with (nolock)
        join [dbo].[DMP_EVENT_ITEM] I with (nolock)
                on I.cv_acct_id =  ae.acct_id  and I.cv_evt_stub = ae.evt_stub  
                AND ae.prod_stub = I.cv_prod_stub
        left join [dbo].[CONTACT_TYPE] ct with (nolock)
                on ct.acct_id =  ae.acct_id  and ct.cont_type_stub = ae.cont_type_stub
        left join [dbo].[BASKET_DETAIL] bd with (nolock)
                on bd.acct_id =  ae.acct_id  and bd.bskt_dtl_stub = ae.bskt_dtl_stub
        left join [dbo].[FEE] f with (nolock)
                on f.acct_id =  bd.acct_id  and f.fee_stub = bd.bskt_dtl_fee_stub

-- changes              
        LEFT join [dbo].[DMP_EVENT_INVITEE] di1 with (nolock)
                on di.cv_acct_id =  ae.acct_id  and di.cv_cont_stub = ae.entity_stub -- > Difference
                and di.cv_free_stub = '00000000-0000-0000-0000-000000000000'
                and di.cv_evt_stub = i.cv_evt_stub

        LEFT join [dbo].[DMP_EVENT_REGISTRATION] dr1 (nolock)
                on dr.invitee_id = di1.invitee_id and dr.event_id = di1.event_id

        LEFT join [dbo].[DMP_EVENT_INVITEE] di2 with (nolock)
                on di.cv_acct_id = ae.acct_id and di.cv_free_stub = ae.entity_stub -- > Difference
                
        LEFT join [dbo].[DMP_EVENT_REGISTRATION] dr2 with (nolock)
                on dr2.cv_invitee_stub = di2.cv_invitee_stub and dr2.event_id = di2.event_id

-- \changes
                
        left join [dbo].[PARTICIPANT_ENTITY] pe (nolock)
                on pe.acct_id = ae.acct_id 
                and pe.evt_stub = ae.evt_stub and pe.prod_stub = i.cv_prod_stub and pe.entity_stub = ae.entity_stub
        where ae.acct_id = 2000022 
                AND (ae.entity_type_id = 3 OR ae.entity_type_id = 10) -- > Changes