select distinct baap.member_id    as member_id,
       baap.agent_id     as agent_id,
       baap.agent_title  as agent_title,
       baap.agent_desc   as agent_desc,
       baap.agent_avatar as agent_avatar
from biz_member_agent_application_collect bmaac
left join biz_agent_application_publish baap on baap.agent_id = bmaac.agent_id
where baap.is_deleted = 'N'
and bmaac.is_deleted = 'N'
<<and bmaac.is_collect = :isCollect>>
<<and bmaac.member_id = :memberId>>
order by baap.created_time desc