| 12345678910111213 |
- select * from AR_USER_NETWORK_NEW WHERE USER_ID = '76209982806298624'
- select * from AR_USER u where u.USER_NAME='LA68770271'
- select u.ID, u.USER_NAME,u.REAL_NAME from AR_USER u where u.ID = '135210116545908736'
- union all
- (select n.user_id,u.USER_NAME,u.REAL_NAME
- from AR_USER_NETWORK_NEW n left join AR_USER u on n.USER_ID=u.ID
- where
- (select PARENT_UIDS from AR_USER_NETWORK_NEW WHERE USER_ID = '135210116545908736' ) like concat('%' , n.USER_ID , '%')
- order by n.TOP_DEEP desc)
|
