| | |
| | | nfpi.community_id, |
| | | nfnpc.punch_start_time, |
| | | nfnpc.punch_end_time, |
| | | count(nfnpc.id) as isJoin, |
| | | if(nfnpc.user_id>0,1,0) as isJoin, |
| | | nfpi.status, |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |
| | |
| | | nfpi.community_id, |
| | | nfnpc.punch_start_time, |
| | | nfnpc.punch_end_time, |
| | | count(nfnpc.id) as isJoin, |
| | | if(nfnpc.user_id>0,1,0) as isJoin, |
| | | nfpi.status, |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |
| | |
| | | nfpi.community_id, |
| | | nfnpc.punch_start_time, |
| | | nfnpc.punch_end_time, |
| | | count(nfnpc.id) as isJoin, |
| | | if(nfnpc.user_id>0,1,0) as isJoin, |
| | | nfpi.status, |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |