| | |
| | | nfnpc.punch_start_time, |
| | | nfnpc.punch_end_time, |
| | | if(nfnpc.user_id>0,1,0) as isJoin, |
| | | (count(nfnpc.task_id)) as joinNum, |
| | | (select count(task_id) from new_fight_need_problem_claim where task_id=nfpi.id) as joinNum, |
| | | nfnpc.service_time, |
| | | nfpi.status, |
| | | nfpi.is_display, |
| | |
| | | nfnpc.punch_start_time, |
| | | nfnpc.punch_end_time, |
| | | if(nfnpc.user_id>0,1,0) as isJoin, |
| | | (count(task_id)) as joinNum, |
| | | (select count(task_id) from new_fight_need_problem_claim where task_id=nfpi.id) as joinNum, |
| | | nfpi.status, |
| | | nfpi.is_display, |
| | | nfpi.user_id |
| | |
| | | nfnpc.punch_start_time, |
| | | nfnpc.punch_end_time, |
| | | if(nfnpc.user_id>0,1,0) as isJoin, |
| | | (count(task_id)) as joinNum, |
| | | (select count(task_id) from new_fight_need_problem_claim where task_id=nfpi.id) as joinNum, |
| | | nfpi.status, |
| | | nfpi.is_display, |
| | | nfpi.user_id |