SELECT  [Opportunity].[Result_event_attrID],
        [Lead].[Lead_ID],
        [Opportunity].[State_attrID],
        [Opportunity].[Status_attrID],
        [Opportunity].[Own_Funds],
        [Opportunity].[BorrowedFunds],
        [Opportunity].[First_Paysum],
        [Opportunity].[Contract_Price],
        [Opportunity].[Total_Area],
        [Opportunity].[Type_Opportunity_attrID],
        [Opportunity].[Fact_Area],
        [Opportunity].[Opportunity_Cost],
        [Opportunity].[BTI_Pricefix],
        [Opportunity].[Not_Paid_Area],
        [Opportunity].[Own_Funds],
        [PIK_fact_call_details].[talk_time],
        [PIK_fact_call_details].[hold_time],
        [PIK_fact_call_details].[busy_time],
        [PIK_fact_call_details].[wrap_time],
        [PIK_fact_call_details].[call_dialing_dur],
        [PIK_fact_call_details].[queue_size],
        [PIK_fact_call_details].[call_wait_qty]
    FROM [PIK_DWH].[dbo].[Call_CRM] AS Call_CRM
        INNER JOIN [PIK_DWH].[Phone].[PIK_fact_call_details] AS PIK_fact_call_details ON
        [Call_CRM].[CallCenterID] = [PIK_fact_call_details].[global_call_call_key]
        INNER JOIN [PIK_DWH].[dbo].[Lead] AS Lead ON
        [Call_CRM].[Call_CRM_ID] = [Lead].[Call_CRM_ID]
        JOIN [PIK_DWH].[dbo].[Opportunity] AS Opportunity ON
        [Lead].[Lead_ID] = [Opportunity].[Lead_ID]
        WHERE [Lead].[Call_CRM_ID] != -1