SELECT     name, owneridname AS AccountManager, new_telemarketingownername AS TelemarketingOwner, accountid, new_autonumbertext,
                          (SELECT     TOP (1) fpc1.actualend
                            FROM          FilteredPhoneCall AS fpc1 INNER JOIN
                                                   FilteredActivityParty AS fap1 ON fpc1.activityid = fap1.activityid INNER JOIN
                                                   FilteredContact AS fc1 ON fap1.partyid = fc1.contactid INNER JOIN
                                                   FilteredAccount AS fa1 ON fc1.accountid = fa1.accountid
                            WHERE      (fap1.participationtypemaskname = N'To Recipient') AND (fa.accountid = fc1.accountid) AND (fpc1.statecode = '1')
                            ORDER BY fpc1.actualend DESC) AS LastCallDate,
                          (SELECT     TOP (1) fpc1.subject
                            FROM          FilteredPhoneCall AS fpc1 INNER JOIN
                                                   FilteredActivityParty AS fap1 ON fpc1.activityid = fap1.activityid INNER JOIN
                                                   FilteredContact AS fc1 ON fap1.partyid = fc1.contactid INNER JOIN
                                                   FilteredAccount AS fa1 ON fc1.accountid = fa1.accountid
                            WHERE      (fap1.participationtypemaskname = N'To Recipient') AND (fa.accountid = fc1.accountid) AND (fpc1.statecode = '1')
                            ORDER BY fpc1.actualend DESC) AS LastPhoneCallSubject,
                          (SELECT     TOP (1) fpc1.owneridname
                            FROM          FilteredPhoneCall AS fpc1 INNER JOIN
                                                   FilteredActivityParty AS fap1 ON fpc1.activityid = fap1.activityid INNER JOIN
                                                   FilteredContact AS fc1 ON fap1.partyid = fc1.contactid INNER JOIN
                                                   FilteredAccount AS fa1 ON fc1.accountid = fa1.accountid
                            WHERE      (fap1.participationtypemaskname = N'To Recipient') AND (fa.accountid = fc1.accountid) AND (fpc1.statecode = '1')
                            ORDER BY fpc1.actualend DESC) AS LastPhoneCallOwner,
                          (SELECT     TOP (1) fpc1.owneridname
                            FROM          FilteredPhoneCall AS fpc1 INNER JOIN
                                                   FilteredActivityParty AS fap1 ON fpc1.activityid = fap1.activityid INNER JOIN
                                                   FilteredContact AS fc1 ON fap1.partyid = fc1.contactid INNER JOIN
                                                   FilteredAccount AS fa1 ON fc1.accountid = fa1.accountid
                            WHERE      (fap1.participationtypemaskname = N'To Recipient') AND (fa.accountid = fc1.accountid) AND (fpc1.statecode = '0')
                            ORDER BY fpc1.scheduledend) AS NextPhoneCallOwner,
                          (SELECT     TOP (1) fpc1.scheduledend
                            FROM          FilteredPhoneCall AS fpc1 INNER JOIN
                                                   FilteredActivityParty AS fap1 ON fpc1.activityid = fap1.activityid INNER JOIN
                                                   FilteredContact AS fc1 ON fap1.partyid = fc1.contactid INNER JOIN
                                                   FilteredAccount AS fa1 ON fc1.accountid = fa1.accountid
                            WHERE      (fap1.participationtypemaskname = N'To Recipient') AND (fa.accountid = fc1.accountid) AND (fpc1.statecode = '0')
                            ORDER BY fpc1.scheduledend) AS NextCallDate
FROM         FilteredAccount AS fa
WHERE     (statuscode = '1')

SELECT  [name]
       ,owneridname AS AccountManager
       ,new_telemarketingownername AS TelemarketingOwner
       ,accountid
       ,new_autonumbertext
       ,oa1.LastCallDate
       ,oa1.subject
       ,oa1.owneridname
       ,oa2.owneridname
       ,oa2.scheduledend

FROM         FilteredAccount AS fa

OUTER APPLY (
       select top 1 
              fpc1.actualend AS LastCallDate
              ,fpc1.subject
              ,fpc1.owneridname
       FROM   FilteredPhoneCall AS fpc1 
       INNER JOIN FilteredActivityParty AS fap1 ON fap1.activityid  = fpc1.activityid
       INNER JOIN FilteredContact AS fc1 ON fc1.contactid  = fap1.partyid
       where  fc1.accountid = fa.accountid
       and    fap1.participationtypemaskname = N'To Recipient'
       AND    fpc1.statecode = '1'
       order by fpc1.actualend DESC
       ) oa1

OUTER APPLY (
       select top 1 
              fpc1.owneridname
              ,fpc1.scheduledend
       FROM   FilteredPhoneCall AS fpc1 
       INNER JOIN FilteredActivityParty AS fap1 ON fap1.activityid  = fpc1.activityid
       INNER JOIN FilteredContact AS fc1 ON fc1.contactid  = fap1.partyid
       where  fc1.accountid = fa.accountid
       and    fap1.participationtypemaskname = N'To Recipient'
       AND    fpc1.statecode = '0'
       order by fpc1.scheduledend
       ) oa2

WHERE     fa.statuscode = '1'