1、检查积分等级页面设置的等级区间是否有重叠(不可调整,只能人为控制创建的等级不重叠)
2、检查对应的关联数据是是否有重复数据,t_wx_car;
3、历史数据有关联车辆后删除了车辆未删除关联车辆的数据的情况,会导致有空白的关联数据显示(修复版本:V6.18.1122);
select wechatname='" + content + "', Uscore=isnull(a.QYDQscore,0), degreeName , b.carid , a.ID, keep_nextmileage,driver_sort,
a.openid,headimgurl,nickname,a.sex,replace(county,'中国','')+province +city as address,convert(varchar(20),subscribetime,120) as subscribetime
,c.car_id,car_platenum, car_brand,d.cust_name,c.driver,convert(varchar(20),keep_nextdate,23) as keep_nextdate,convert(varchar(20),check_date,23) as check_date,
convert(varchar(20),enforceinsurance_lastdate,23) as enforceinsurance_lastdate,convert(varchar(20),businessinsurance_lastdate,23) as businessinsurance_lastdate,
insurance_date=convert(varchar(20),case when enforceinsurance_lastdate>=businessinsurance_lastdate then businessinsurance_lastdate else enforceinsurance_lastdate end ,23)
,convert(varchar(20),driver_check,23) as driver_check,'' as rem,e.linkman as wx_linkman,e.carbrand as wx_carbrand,e.carplatenum as wx_carplatenum,e.enginenum as wx_enginenum,e.movephone as wx_movephone
from t_wx_user a
left join t_wx_car b on a.openid=b.openid
left join t_car c on b.carid =c.car_id
left join t_cust d on c.cust_id = d.cust_id
left join t_wx_usermemo e on a.openid = e.openid
left join T_WX_ScoreDegree t on (isnull(a.QYtotalscore,0)>=t.score_min or t.score_min is null) and (isnull(a.QYtotalscore,0)<=t.score_max or t.score_max is null)
where 1=1