| | |
| | | volunteer_id, |
| | | issue_status, |
| | | issue_points, |
| | | (select cmvm.name from sys_user cmvm where cmvm.user_id=user_id) as contactName, |
| | | (select cmvm.phone from sys_user cmvm where cmvm.user_id=user_id) as contactPhone, |
| | | (select cmvm.name from sys_user cmvm where cmvm.user_id=volunteer_activities_people_involved.user_id) as contactName, |
| | | (select cmvm.phone from sys_user cmvm where cmvm.user_id=volunteer_activities_people_involved.user_id) as contactPhone, |
| | | creation_time, |
| | | activity_id, |
| | | user_id, |
| | |
| | | volunteer_id, |
| | | issue_status, |
| | | issue_points, |
| | | (select cmvm.name from sys_user cmvm where cmvm.user_id=user_id) as contactName, |
| | | (select cmvm.phone from sys_user cmvm where cmvm.user_id=user_id) as contactPhone, |
| | | (select cmvm.name from sys_user cmvm where cmvm.user_id=volunteer_activities_people_involved.user_id) as contactName, |
| | | (select cmvm.phone from sys_user cmvm where cmvm.user_id=volunteer_activities_people_involved.user_id) as contactPhone, |
| | | creation_time, |
| | | activity_id, |
| | | user_id, |