MySQL 按日期模拟查询

– 查询出付费的所有通道
select channels, count(*) from t_auth_core_flow where res_code not in (’-10000’,‘10075’,‘10094’‘10095’,‘10097’,‘10105’,‘10110’,‘10112’) GROUP BY channels

– 查询联润表
– 查询2018年所有
select * from t_lianrun_flow where create_time > ‘2018-04-01 00:00:00’ and ‘2018-12-31 24:59:59’ ORDER BY create_time DESC

– mysql 查询时间范围模拟查询 联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– mysql 一月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– mysql 二月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– mysql 三月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– mysql 四月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– mysql 5月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– mysql 6月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– mysql 7月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– mysql 8月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– mysql 10月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– mysql 11月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– mysql 12月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– mysql 查询时间范围模拟查询 银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– mysql 一月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– mysql 2月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– mysql 3月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– mysql 4月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– mysql 5月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– mysql 6月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– mysql 7月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– mysql 8月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– mysql 9月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– mysql 10月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– mysql 11月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– mysql 12月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– mysql 查询时间范围模拟查询 小河
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select DISTINCT error_content from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）一月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）二月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）三月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）四月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）5月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）6月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）7月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）8月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）9月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）10月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）11月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）12月份
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 小河银行卡二要素 身份证实名（身份证号+姓名）
select * from t_xiaoheer_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）

select DISTINCT error_content from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）一月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）二月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）3月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）四月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）5月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）6月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）7月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-08-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）8月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）9月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）10月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’
– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）11月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 小河银行卡二要素 身份证水纹照片（身份证号+姓名）12月份

select * from t_xiaoheer_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_id_name_image_flow where error_content like ‘%身份证与姓名不匹配%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）
select DISTINCT error_content from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_status_flow where error_content like ‘%正常%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_status_flow where error_content like ‘%停机%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）一月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）2月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）3月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）4月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）5月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）6月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）7月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）8月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）9月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）10月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）11月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）12月份
select * from t_xiaoheer_mobile_status_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select DISTINCT error_content from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）1月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）2月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）3月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）4月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）5月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）6月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）7月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）8月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）9月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）10月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’
– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）11月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 小河银行卡二要素 手机号三网三要素（身份证+姓名+手机号）12月份

select * from t_xiaoheer_mobile_check_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_check_flow where error_content like ‘%手机三要素不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 小河 在网时长

select DISTINCT error_content from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小河 在网时长 1月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 小河 在网时长 2月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– 小河 在网时长 3月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– 小河 在网时长 4月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’
– 小河 在网时长 5月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’
– 小河 在网时长 6月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– 小河 在网时长 7月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– 小河 在网时长 8月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– 小河 在网时长 9月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– 小河 在网时长 10月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– 小河 在网时长 11月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 小河 在网时长 12月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 小河 在网时长 12月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 甄视 身份证实名（身份证号+姓名）

select DISTINCT message from t_minivision_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_minivision_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_minivision_id_name_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_minivision_id_name_flow where message like ‘%余额不足0%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 甄视 身份证实名（身份证号+姓名）10月份

select * from t_minivision_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_minivision_id_name_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_minivision_id_name_flow where message like ‘%余额不足0%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– 甄视 身份证实名（身份证号+姓名）11月份

select * from t_minivision_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_minivision_id_name_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_minivision_id_name_flow where message like ‘%余额不足0%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 甄视 身份证实名（身份证号+姓名）12月份

select * from t_minivision_id_name_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_minivision_id_name_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_minivision_id_name_flow where message like ‘%余额不足0%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 甄视 身份证水纹照片（身份证号+姓名）

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 甄视 身份证水纹照片（身份证号+姓名） 1月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 甄视 身份证水纹照片（身份证号+姓名） 2月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– 甄视 身份证水纹照片（身份证号+姓名） 3月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– 甄视 身份证水纹照片（身份证号+姓名） 4月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– 甄视 身份证水纹照片（身份证号+姓名） 5月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– 甄视 身份证水纹照片（身份证号+姓名） 6月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– 甄视 身份证水纹照片（身份证号+姓名） 7月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– 甄视 身份证水纹照片（身份证号+姓名） 8月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– 甄视 身份证水纹照片（身份证号+姓名） 9月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– 甄视 身份证水纹照片（身份证号+姓名） 10月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– 甄视 身份证水纹照片（身份证号+姓名） 11月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 甄视 身份证水纹照片（身份证号+姓名） 12月份

select * from t_minivision_id_name_image_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_minivision_id_name_image_flow where message like ‘%一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– 小安 在网时长
select * from t_xiaoan_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoan_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_xiaoan_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– 小安 在网时长 1月份

select * from t_xiaoan_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoan_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_xiaoan_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– 小安 在网时长 2月份

select * from t_xiaoan_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoan_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– 小安 在网时长 3月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– 小安 在网时长 4月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– 小安 在网时长 5月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– 小安 在网时长 6月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– 小安 在网时长 7月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– 小安 在网时长 8月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– 小安 在网时长 9月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– 小安 在网时长 10月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– 小安 在网时长 11月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– 小安 在网时长 12月份

select * from t_xiaoheer_mobile_online_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%查询成功%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_xiaoheer_mobile_online_flow where error_content like ‘%ERROR:%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select DISTINCT resp_code,res_desc from t_lianrun_flow

本文地址：https://blog.csdn.net/estelle0725/article/details/85987401