– 根据查询未读的活动评论或回复
select t1.id, pid, t1.`status`, t1.user_id , t2.avatar , t2.nick_name , content , t3.title, CASE
WHEN pid is null THEN
'reply'
ELSE
'comment'
END as type,
CASE WHEN pid is null THEN
null
ELSE
(select content from cms_activity_comment t where t.id = t1.pid)
END as parent_content
from cms_activity_comment t1
left join cms_user t2 on t1.user_id = t2.user_id
left join cms_activity t3 on t1.aid = t3.id
where t1.tid=116 and t1.`status`='1'