SELECT SPLIT, syn(SPLIT),
	SUM(CASE WHEN WORKMODE = 40 THEN 1 ELSE 0 END),
	SUM(CASE WHEN WORKMODE = 30 THEN 1 ELSE 0 END),
	SUM(CASE WHEN WORKMODE = 50 THEN 1 ELSE 0 END),
	SUM(CASE WHEN WORKMODE = 220) THEN 1 ELSE 0 END,
	COUNT(*),
	SUM(CASE WHEN WORKMODE = 20 THEN 1 ELSE 0 END),
	SUM(CASE WHEN WORKMODE = 80 THEN 1 ELSE 0 END)
  FROM csplit
  JOIN cagent ON cagent.ACD = csplit.ACD AND cagent.SPLIT = csplit.SPLIT
 WHERE csplit.ACD = $1 and csplit.SPLIT = $2
   and cagent.LOC_ID = ANY ($3) and cagent.LOGID IS NOT NULL
 GROUP BY SPLIT