| | |
|---|
| | | String sql = """ |
|---|
| | | SELECT ap.id as ap_id, ap.description as ap_description, ap.activity_id, ap.region_id, ap.stage_id, |
|---|
| | | ap.project_name, ap.feedback, ap.state as ap_state, |
|---|
| | | p.id as player_id, p.name as player_name, p.phone, p.description as player_desc, |
|---|
| | | p.id as player_id, p.name as player_name, u.phone, p.description as player_desc, |
|---|
| | | p.gender, u.birthday, p.education, p.introduction, u.id as user_id, |
|---|
| | | u.name as user_name, u.phone as user_phone, |
|---|
| | | a.name as activity_name, a.rating_scheme_id, |
|---|
| | | r.id as region_id, r.name as region_name, r.full_path as region_path |
|---|
| | | FROM t_activity_player ap |
|---|
