- 论坛徽章:
- 0
|
- SELECT A.CATEGORYID,
- A.CATEGORYNAME,
- A.SORT,
- H.ACCOUNTTYPE,
- H.ACCOUNT,
- H.NICKNAME,
- H.APPROVEINFO,
- K.MBLOG_ID,
- K.MBLOG_TEXT,
- K.CREATE_FROM,
- K.REF_MBLOG_ID,
- K.REF_SUBJECT_ID,
- K.REF_SUBJECT_KEYWORDS,
- K.REF_BOOK_ID,
- K.REF_BOOK_KEYWORDS,
- K.COMMENT_TIMES,
- K.CLICK_TIMES
- FROM SNS_FUN_STARSORTRELATION D
- LEFT JOIN SNS_FUN_STARSORT A
- ON D.CATEGORYID = A.CATEGORYID
- LEFT JOIN SNS_FUN_THIRDACCOUNT H
- ON D.ACCOUNTTYPE = H.ACCOUNTTYPE
- AND D.ACCOUNT = H.ACCOUNT
- LEFT JOIN SNS_FUN_MBLOG K
- ON H.ACCOUNTTYPE = K.SYS_ID
- AND H.ACCOUNT = K.USER_ID
- WHERE D.CATEGORYID = 1;
复制代码 |
|