56,677
社区成员
发帖
与我相关
我的任务
分享
select a.ID as ID,ifnull(ComplaintsNumbers,'') as ComplaintsNumbers,ifnull(BeenComplaintsNumbers,'') as BeenComplaintsNumbers,ifnull(b.Types,'') as ComplaintsNumbersOperators,ifnull(c.Types,'') as BeenComplaintsNumbersOperators,ifnull(d.Types,'') as ComplaintsNumbersRegion,ifnull(e.Types,'') as BeenComplaintsNumbersRegion,ifnull(ComplaintsContent,'') as ComplaintsContent,ifnull(f.Types,'') as BeenComplaintNumbersNature,ifnull(g.Types,'') as ComplaintHandleStatus,ifnull(ComplaintsTime,'') as ComplaintsTime,ifnull(h.UserName,'') as UserName,ifnull(HandleContent,'') as HandleContent,ifnull(RecvSmsContent,'') as RecvSmsContent,ComplaintHandleStatus as ComplaintHandleStatus from t_complaintsinfos as a left join t_types as b on a.ComplaintsNumbersOperators= b.ID left join t_types as c on a.BeenComplaintsNumbersOperators= c.ID left join t_types as d on a.ComplaintsNumbersRegion= d.ID left join t_types as e on a.BeenComplaintsNumbersRegion= e.ID left join t_types as f on a.BeenComplaintNumbersNature= f.ID left join (select ComplaintsID,ifnull(GROUP_CONCAT(distinct Types),'') as Types from t_complaintshandle as a left join t_types as b on a.HandleStatus=b.ID group by ComplaintsID) as g on a.ID= g.ComplaintsID left join t_userinfos as h on a.UserID= h.ID where a.ID =16