| | |
| | | "p.urban_status, " + |
| | | "p.img_width, " + |
| | | "p.img_height, " + |
| | | "caepe.score," + |
| | | "caepe.`content` " + |
| | | "p.handle_photo_list " + |
| | | "FROM " + |
| | | "com_act_easy_photo p " + |
| | |
| | | "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 " + |
| | | "left join com_act_easy_photo_classify ca on ca.id = p.classify_id " + |
| | | "left join com_act_easy_photo_evaluate as caepe on caepe.service_id = p.id and caepe.service_type = 1 " + |
| | | "WHERE p.del_tag = 0 and p.id=#{id}") |
| | | ComActEasyPhotoVO detailEasyPhoto(Long id); |
| | | @Select("SELECT " + |