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