DECLARE @AgentID int = 41

CREATE TABLE #AGENT_GROUPS
(
    AgentGroupID smallint,
    AgentGroupName varchar
)
INSERT #AGENT_GROUPS EXEC [AdminCollex].[sp_GetGroupsForAgent] @AgentID

SELECT
      p.PoolName
    , MAX(apr.AccountCount)
    , 'Status'
    , pm.EntryDate
    , pm.StartTime
    , pm.EndTime
    , MIN(apr.AccountCount)

FROM Domain.AgentGroup AS ag WITH (NOLOCK)
INNER JOIN Domain.AgentAgentGroup AS aag
    ON ag.AgentGroupID = aag.AgentGroupID
INNER JOIN Dialer.PoolManagement AS pm
    ON ag.AgentGroupID = pm.AgentGroupID
CROSS JOIN Main.Account
CROSS JOIN AccountPool.Pool AS p
INNER JOIN AccountPool.AccountPoolRun AS apr
    ON p.PoolID = apr.PoolID

WHERE pm.AgentGroupID IN (SELECT AgentGroupID FROM #AGENT_GROUPS)
AND pm.AccountPoolID IN (SELECT p.PoolID)

DROP TABLE #AGENT_GROUPS