SELECT COUNT(*) AS Cnt
FROM   datamartend.dbo.Abandoned_Call_Dim /*3*/
       INNER JOIN measure /*149,871*/
         ON measure.Abandoned = Abandoned_Call_Dim.abandoned_value
       INNER JOIN DataMartEnd.dbo.Work_Type_Dim /*866*/
         ON measure.DBID = work_type_dim.MIG_Site_ID
            /*Key lookup*/
            AND Work_Type_Dim.Work_Type_Code = measure.Queue
            AND measure.StartTimeDate BETWEEN Work_Type_Dim.DimEffectiveStartDtm AND Work_Type_Dim.DimEffectiveEndDtm
       INNER JOIN datamartend.dbo.Site_Type_Dim /*19*/
         ON work_type_dim.MIG_Site_ID = Site_Type_Dim.Site_Type_Code