mapper.xml sql左连接语句报错

select ut.*,

uw.nickname,

(CASE WHEN u.role='0' THEN '注册会员' WHEN u.role='1' THEN '认证会员' WHEN  u.role='2' THEN '认证师' WHEN u.role='3' THEN '认证商' WHEN u.role='6' THEN '非会员' END) role3,
(CASE WHEN ut.newRole='0' THEN '注册会员' WHEN ut.newRole='1' THEN '认证会员' WHEN  ut.newRole='2' THEN '认证师' WHEN ut.newRole='3' THEN '认证商' WHEN ut.newRole='6' THEN '非会员' END) newRole,

FROM usertarget ut LEFT JOIN usersweixininformation uw
ON ut.openid=uw.openid

LEFT JOIN userinfo u 
ON ut.openid = u.openid 
ORDER BY ut.time desc

</select>

报错
FROM usertarget ut LEFT JOIN usersweixininformation uw
ON ut.openid=uw.openid
' at line 8

THEN '非会员' END) newRole, 后面多个逗号

FROM 前边有逗号 ----