id, `type`, uid, content, parent_id, parent_uid, review_id, review_uid, count_start, count_reply, audit_status, refusal, note_id, is_del, create_time, update_time SELECT r.id,r.`type`,r.uid,r.content,r.count_start as countStart,r.count_reply as countReply, r.audit_status as auditStatus,r.refusal,r.create_time as createTime, n.title as noteTitle,u.nickname as userNickname from eb_community_reply as r left join eb_user as u on r.uid = u.id left join eb_community_notes as n on r.note_id = n.id where r.is_del = 0 and r.content like CONCAT('%',#{keywords},'%') and r.audit_status = #{auditStatus} and r.create_time between #{startTime} and #{endTime} and u.nickname like CONCAT('%',#{userName},'%') and n.title like CONCAT('%',#{title},'%') ORDER BY r.id desc