56,677
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
USE `weipaike`$$
DROP VIEW IF EXISTS `vw_billing_user_charge`$$
CREATE ALGORITHM=MERGE DEFINER=`mydb`@`%` SQL SECURITY DEFINER VIEW `vw_billing_user_charge` AS
SELECT
`a`.`phone` AS `phone`,
`a`.`province` AS `province`,
`a`.`city` AS `city`,
`a`.`regtime` AS `regtime`,
`a`.`channel` AS `channel`,
(COUNT(`b`.`phone`) + IFNULL((SELECT COUNT(0) FROM `billing_demond_result` WHERE (`billing_demond_result`.`phone` = `a`.`phone`) GROUP BY `billing_demond_result`.`phone`),0)) AS `total_cnt`
FROM (`billing_id` `a`
LEFT JOIN `billing_result` `b`
ON ((`a`.`phone` = `b`.`phone`)))
WHERE (1 = 1)
GROUP BY `a`.`phone`$$
DELIMITER ;