17,086
社区成员
发帖
与我相关
我的任务
分享
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;