SELECT SUM(IF (billtime IS NULL,0,billtime)) AS BT, COUNT(id) AS TC, SUM(IF (user_money IS NULL,0,user_money)) AS AC, SUM(IF (destiny_money IS NULL,0,destiny_money)) AS DC FROM CDR WHERE user='.$agentId.' AND  code=4 AND origin_ip IN ('.$ipList.') AND connect BETWEEN '.$from.' AND '.$to.''