select distinct a.* from wcr_s a,wcr_i b ,wcr_r c where a.xId=b.xId and a.xId=c.xId and a.status=值 AND a.uId=值 and c.`type`=值 and b.name <> ''