| | |
| | | select * FROM ( |
| | | select cancc.id,cancc.circle_id,cancc.user_id,cancc.content,cancc.fabulous_num |
| | | cancc.create_at,cancc.is_release,su.nick_name as userName,su.image_url as userHeadUrl |
| | | from com_act_neighbor_circle_comment as cancc " + " left join sys_user as su on su.user_id = cancc.user_id |
| | | from com_act_neighbor_circle_comment as cancc |
| | | left join sys_user as su on su.user_id = cancc.user_id |
| | | where cancc.circle_id = #{neighborCircleAppDTO.circleId} and cancc.status = 1 |
| | | union |
| | | select cancc.id,cancc.circle_id,cancc.user_id,cancc.content,cancc.fabulous_num |
| | | ,cancc.create_at,cancc.is_release,su.nick_name as userName,su.image_url as userHeadUrl |
| | | from com_act_neighbor_circle_comment_west as cancc " + " left join sys_user as su on su.user_id = cancc.user_id |
| | | from com_act_neighbor_circle_comment_west as cancc |
| | | left join sys_user as su on su.user_id = cancc.user_id |
| | | where cancc.circle_id = #{neighborCircleAppDTO.circleId} and cancc.status = 1) temp |
| | | <if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 1'> |
| | | order by temp.create_at desc |