,array_accum(COALESCE(race::text,'')) AS race
,array_accum(COALESCE(amount,0)) AS amount
,array_accum(COALESCE(eta,0)) AS eta
,array_accum(COALESCE(shiptype,'')) AS shiptype
,array_accum(COALESCE(alliance,'?')) AS alliance
,array_accum(coords) AS attackers
,array_accum(COALESCE(race::text,'')) AS race
,array_accum(COALESCE(amount,0)) AS amount
,array_accum(COALESCE(eta,0)) AS eta
,array_accum(COALESCE(shiptype,'')) AS shiptype
,array_accum(COALESCE(alliance,'?')) AS alliance
,array_accum(coords) AS attackers