SELECT
tb. ID,
cf.fieldName,
tb.taTitle,
tb.taContent,
tb.taPubTime,
zc.logoFile,
zc. COUNT AS num,
tb.taUserId,
tb.pubTitleUserName
FROM
ZDYIMTALKABOUT tb
INNER JOIN ZCMEMBER zc ON(tb.taUserId = zc. ID)
LEFT JOIN ZDYCMFIELD cf ON(cf. ID = tb.taFieldId)
LEFT JOIN(
SELECT
RELAID,
COUNT(ID)AS COUNT
FROM
ZCCOMMENT
WHERE
verifyFlag = 'Y'
AND siteId = 14
GROUP BY
RELAID
)zc ON(tb. ID = zc.relaId)
WHERE
tb. ID IN(
SELECT DISTINCT
ta. ID
FROM
ZCCOMMENT zcc
INNER JOIN ZDYIMTALKABOUT ta ON(ta. ID = zcc.relaId)
WHERE
zcc.userId = '485'
AND zcc.prop1 = 401
AND zcc.siteId = 14
AND ta.isDel = 1
AND tb.taVerifyStatus = 1
)
ORDER BY
tb.createTime DESC