| | |
| | | "p.activity_id, " + |
| | | "p.activity_amount, " + |
| | | "count(pu.id)giveThumbsUpNum, " + |
| | | "p.handle_photo_list," + |
| | | "c.name communityName," + |
| | | "p.transfer_time," + |
| | | "p.is_report_urban," + |
| | | "p.transfer_reason," + |
| | | "ca.`name` as classifyName," + |
| | | "p.urban_status " + |
| | | "p.urban_status, " + |
| | | "p.img_width, " + |
| | | "p.img_height, " + |
| | | "p.handle_photo_list " + |
| | | "FROM " + |
| | | "com_act_easy_photo p " + |
| | | "JOIN sys_user u on p.sponsor_id=u.user_id " + |
| | |
| | | "p.activity_amount, " + |
| | | "p.classify_id, " + |
| | | "class.`name` as classifyName, " + |
| | | "p.img_width, " + |
| | | "p.img_height, " + |
| | | "p.examine_at " + |
| | | "FROM " + |
| | | "com_act_easy_photo p " + |