SELECT luvp.id,luvp.userid,luvp.play_num,lu.nickname nickname,lu.cover_img_url userImg,
IFNULL( (select lur.type from la_user_relation lur where lur.focusid=luvp.userid and lur.userid=?) ,-1) isFocus
FROM la_user_voice_played luvp,la_user lu where luvp.userid=lu.id
转载于:https://my.oschina.net/u/555639/blog/401486