Retourne le nombre d’agent connectés pour les campagnes auxquelles l’agent user_oid est affecté.

select count(*) as nb_agents FROM ( SELECT A.campaign_oid FROM omni_callcenter.campaigns_agents A inner JOIN omni.users B ON A.user_oid = B.user_oid INNER JOIN omni_callcenter.Status C ON C.status = B.agent_status where B.customer_id = ‘4C8627DCE97217B1′ and B.id_profile=’1’ and B.agent_status >= ‘0’ and B.agent_status != ‘2000’ and A.campaign_oid IN (select C.campaign_oid from omni_callcenter.campaigns_agents C where C.user_oid =’K677bb7c3ca66f324349668′) group by B.user_oid) as T;