| | |
|---|
| | | SELECT a.id, a.activity_name, u.`name` sponsorName, a.activity_addr, a.participant_max, |
|---|
| | | COUNT(if(s.is_volunteer=1,NULL,s.id))participant_now, a.volunteer_max, |
|---|
| | | COUNT(if(s.is_volunteer=1,s.id,NULL))volunteer_now, a.`status`, a.publish_at, |
|---|
| | | a.is_qr_code, a.begin_at, a.end_at, a.sign_up_begin, a.sign_up_end, a.reward_way, a.activity_type |
|---|
| | | a.is_qr_code, a.begin_at, a.end_at, a.sign_up_begin, a.sign_up_end, a.reward_way, a.activity_type, a.have_integral_reward |
|---|
| | | FROM com_act_activity a |
|---|
| | | LEFT JOIN sys_user u ON a.sponsor_id=u.user_id |
|---|
| | | LEFT JOIN com_act_act_sign s ON a.id=s.activity_id |
|---|
