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;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货