SUM(ACTIVE) as ACTIVE ARC_ALARM (ARC_ALARM.ACTIVE = 0 OR ARC_ALARM.ACTIVE = 1) AND ($defaultWhereClause)