SELECT SUM(CASE WHEN MutPartNr=1 AND mutsoort = 2 AND MutFactuur=m.MutFactuur AND Mut_Rel_ID = m.Mut_Rel_ID THEN (mutbedragex+mutbtw) ELSE 0 END) AS sBedrag
         , COUNT(CASE WHEN Mut_Ab_ID=71 AND MutPartNr=1 AND MutSoort=2 THEN (1) ELSE NULL END) AS cnt
         , MutFactuur
         , MAX(MutTermijn) AS MutTermijn
         , MIN(CASE WHEN Mut_Ab_ID=71 AND MutPartNr=1 AND MutSoort=2 THEN MutDatum ELSE NULL END) AS MutDatum
         , MIN(r.RelCode) AS RelCode
         , Mut_Rel_ID
         , MIN(RelEmail) AS RelEmail
         , MIN(RelBedrijf) AS RelBedrijf
         , MIN(RelAdres) AS RelAdres
         , MIN(RelPostcode) AS RelPostcode
         , MIN(RelPlaats) AS RelPlaats
         , MIN(RelAanhef) AS RelAanhef
         , SUM(CASE WHEN MutPartNr=3 AND mutsoort IN (7, 3) AND MutFactuur=m.MutFactuur AND Mut_Rel_ID = m.Mut_Rel_ID THEN MutRekenBedrag ELSE NULL END) AS sBetaald
         , (SELECT top 1 MAX(CorDatum) AS CorDatum FROM tblBH_Correspondentie WHERE Cor_Ab_ID = 71 AND CorFactuur=MutFactuur AND Cor_Rel_ID=Mut_Rel_ID) AS LastCor
         , (SELECT TOP 1 CorOmschrijving + '(' + CorPer + ')'   FROM tblBH_Correspondentie  WHERE Cor_Ab_ID=71   AND CorFactuur=MutFactuur   AND Cor_Rel_ID=Mut_Rel_ID AND CorMemo IS NULL ORDER BY CorDatum DESC) AS CorOmschrijving
         , (SELECT TOP 1 MAX(CorDatum)                          FROM tblBH_Correspondentie  WHERE Cor_Ab_ID=71   AND CorFactuur=MutFactuur   AND Cor_Rel_ID=Mut_Rel_ID AND CorMemo IS NOT NULL) AS LastCor
         , (SELECT TOP 1 MAX(CorDatum)                          FROM tblBH_Correspondentie  WHERE Cor_Ab_ID=71   AND CorFactuur=MutFactuur   AND Cor_Rel_ID=Mut_Rel_ID AND CorMemo IS NULL) AS LastCorDatum
         , (SELECT TOP 1 Fact_ID FROM tblFacturen WHERE tblFacturen.FactType='N' AND Fact_Ab_ID=71  AND tblFacturen.FactNummer=MutFactuur AND tblFacturen.Fact_Rel_ID=Mut_Rel_ID) AS Fact_ID
         /*, Max(c1.CorDatum) as LastCor
         , Max(c2.CorOmschrijving) as CorOmschrijving
         , Max(case when c1.CorDatum is not null then c1.CorDatum else null end) as LastCorDatum*/
    FROM tblBH_Mutaties m
    LEFT JOIN tblBH_Relaties r ON Mut_Rel_ID=r.Rel_ID
    /*cross apply (SELECT top 1 max(CorDatum) as CorDatum FROM tblBH_Correspondentie cc WHERE cc.Cor_Ab_ID = 71 AND cc.CorFactuur=MutFactuur AND cc.Cor_Rel_ID=Mut_Rel_ID) c1
    cross apply (SELECT top 1  CorOmschrijving + '(' + CorPer + ')' as CorOmschrijving  FROM tblBH_Correspondentie cc   WHERE Cor_Ab_ID=71   AND (cc.CorFactuur=MutFactuur or cc.CorFactuur=MutFactuur) AND cc.Cor_Rel_ID=Mut_Rel_ID AND CorMemo is null order by cordatum desc) c2*/
    WHERE Mut_Ab_ID=71 AND  MutDatum<='12/31/2013' AND
         ((MutPartNr = 1 AND MutSoort = 2) OR (MutPartNr = 3 AND MutSoort IN (7,3)) )
    GROUP BY MutFactuur, Mut_Rel_ID
    HAVING (SUM(CASE WHEN MutPartNr=1 AND mutsoort = 2 THEN (mutbedragex+mutbtw) ELSE NULL END) <> SUM(CASE WHEN MutPartNr=3 AND mutsoort IN (7, 3) THEN mutrekenbedrag ELSE 0 END))
    ORDER BY mutfactuur