| | |
| | | "p.activity_amount, " + |
| | | "count(pu.id)giveThumbsUpNum, " + |
| | | "p.handle_photo_list " + |
| | | "c.name communityName " + |
| | | "p.transfer_time" + |
| | | "p.transfer_reason" + |
| | | "p.urban_status" + |
| | | "FROM " + |
| | | "com_act_easy_photo p " + |
| | | "JOIN sys_user u on p.sponsor_id=u.user_id " + |
| | | "LEFT JOIN sys_user su on p.handler_id=su.user_id " + |
| | | "LEFT JOIN sys_user su1 on p.complete_id=su1.user_id " + |
| | | "LEFT JOIN com_act_easy_photo_user pu on p.id=pu.easy_photo_id " + |
| | | "LEFT JOIN com_act c on p.community_id=c.community_id " + |
| | | "WHERE p.del_tag = 0 and p.id=#{id}") |
| | | ComActEasyPhotoVO detailEasyPhoto(Long id); |
| | | @Select("SELECT " + |