All pastes #995018 Raw Edit

Someone

public text v1 · immutable
#995018 ·published 2008-04-23 20:37 UTC
rendered paste body
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.''