| | |
|---|
| | | left join com_act_neighbor_circle_topic as canct on canct.id = canc.topic_id |
|---|
| | | left join com_act as ca on ca.community_id = canc.community_id |
|---|
| | | LEFT JOIN com_act_activity t ON canc.id = t.relation_id |
|---|
| | | where is_del = 2 and canc.status = 2 and canc.solve_status in (2,3,4) and canc.community_id = ${neighborCircleAppDTO.communityId} AND t.id IS NULL |
|---|
| | | where is_del = 2 and canc.status = 2 AND canc.order_type = 1 and canc.solve_status in (2,3,4) and canc.community_id = ${neighborCircleAppDTO.communityId} AND t.id IS NULL |
|---|
| | | <if test='neighborCircleAppDTO.topicId != null '> |
|---|
| | | and canc.topic_id = #{neighborCircleAppDTO.topicId} |
|---|
| | | </if> |
|---|
