| | |
|---|
| | | LEFT JOIN yeshi_ec_user_rank rak ON rak.ur_id = ext.uie_rank_id |
|---|
| | | LEFT JOIN yeshi_ec_user_info_extra_taobao tb ON tb.`uiet_uid` = u.id |
|---|
| | | |
|---|
| | | <if test="userState == 2"> <!-- 封禁用户 --> |
|---|
| | | <if test="userState == 2"> |
|---|
| | | LEFT JOIN |
|---|
| | | (SELECT A.uid AS buid,MAX(A.f_wxUnionId) AS wxUnionIdInvalid ,MAX(A.f_taobaoUid) AS taobaoUidInvalid,MAX(A.f_phone) AS phoneInvalid,MAX(A.f_alipayAccount) AS alipayAccountInvalid FROM |
|---|
| | | (SELECT u.`id`AS uid,b.account AS alipayAccount,b.name AS alipayAccountName,fu.* FROM yeshi_ec_user u |
|---|
| | | LEFT JOIN yeshi_ec_binding_account b ON b.`uid` = u.`id` |
|---|
| | | LEFT JOIN yeshi_ec_user_info_extra_taobao tb ON tb.`uiet_uid` = u.id |
|---|
| | | LEFT JOIN (SELECT fc.fuc_effective,IF(fc.`fuc_type` = 'wxUnionId',fc.`fuc_identify_code`,NULL)AS f_wxUnionId, |
|---|
| | | IF(fc.`fuc_type` = 'taobaoUid',fc.`fuc_identify_code`,NULL)AS f_taobaoUid, |
|---|
| | | IF(fc.`fuc_type` = 'phone',fc.`fuc_identify_code`,NULL)AS f_phone, |
|---|
| | | IF(fc.`fuc_type` = 'alipayAccount',fc.`fuc_identify_code`,NULL)AS f_alipayAccount |
|---|
| | | FROM yeshi_ec_forbidden_user_identify_code fc)fu ON (fu.f_wxUnionId = u.`wx_union_id` OR fu.f_taobaoUid = tb.`uiet_taobao_uid` OR fu.f_phone = u.`phone` OR fu.f_alipayAccount = b.`account`) |
|---|
| | | WHERE b.`type`= 1 AND fu.fuc_effective = 1 |
|---|
| | | (SELECT A.uid AS buid,MAX(A.f_wxUnionId) AS wxUnionIdInvalid ,MAX(A.f_taobaoUid) AS taobaoUidInvalid,MAX(A.f_phone) AS phoneInvalid,MAX(A.f_alipayAccount) AS alipayAccountInvalid FROM |
|---|
| | | (SELECT u.`id`AS uid,b.account AS alipayAccount,b.name AS alipayAccountName,fu.* FROM yeshi_ec_user u |
|---|
| | | LEFT JOIN yeshi_ec_binding_account b ON b.`uid` = u.`id` |
|---|
| | | LEFT JOIN yeshi_ec_user_info_extra_taobao tb ON tb.`uiet_uid` = u.id |
|---|
| | | LEFT JOIN (SELECT fc.fuc_effective,IF(fc.`fuc_type` = 'wxUnionId',fc.`fuc_identify_code`,NULL)AS f_wxUnionId, |
|---|
| | | IF(fc.`fuc_type` = 'taobaoUid',fc.`fuc_identify_code`,NULL)AS f_taobaoUid, |
|---|
| | | IF(fc.`fuc_type` = 'phone',fc.`fuc_identify_code`,NULL)AS f_phone, |
|---|
| | | IF(fc.`fuc_type` = 'alipayAccount',fc.`fuc_identify_code`,NULL)AS f_alipayAccount |
|---|
| | | FROM yeshi_ec_forbidden_user_identify_code fc WHERE fc.fuc_effective = 1 )fu ON (fu.f_wxUnionId = u.`wx_union_id` OR fu.f_taobaoUid = tb.`uiet_taobao_uid` OR fu.f_phone = u.`phone` OR fu.f_alipayAccount = b.`account`) |
|---|
| | | WHERE u.`state` =2 |
|---|
| | | )A GROUP BY A.uid) B ON u.id= B.buid |
|---|
| | | </if> |
|---|
| | | |
|---|
