id, title, `type`, cover, image, video, content, category_id, topic_ids, uid, star, audit_status, refusal, like_num, reply_num, shareNum, sort, reply_status, is_del, create_time, update_time SELECT n.id,n.title,n.`type`,n.cover,n.category_id as categoryId,n.topic_ids as topicIds,n.star, n.audit_status as auditStatus,n.refusal,n.reply_status as replyStatus,n.create_time as createTime, n.like_num as likeNum,n.reply_num as replyNum, u.id as authorId, u.nickname as authorName from eb_community_notes as n left join eb_user as u on n.uid = u.id where n.is_del = 0 and n.title like CONCAT('%',#{title},'%') and n.`type` = #{type} and n.category_id = #{categoryId} and n.audit_status = #{auditStatus} and find_in_set(#{topicId}, n.topic_ids) and u.nickname like CONCAT('%',#{authorName},'%') ORDER BY n.star desc, n.id desc