| | |
|---|
| | | select ( SELECT count(*) FROM com_act_micro_wish AS camw LEFT JOIN com_act t1 on camw.community_id = t1.community_id |
|---|
| | | where t1.area_code ='510423' and camw.STATUS = 6 ) microWish , |
|---|
| | | (select count(user_id) from sys_user t LEFT JOIN com_act t1 on t.community_id = t1.community_id |
|---|
| | | where t.type=1 and t.community_id is not null and t1.area_code ='510423') user, |
|---|
| | | where t.type=1 and t.community_id is not null and t.id_card is not null and t1.area_code ='510423') user, |
|---|
| | | (select count(id) from com_pb_org t LEFT JOIN com_act t1 on t.community_id = t1.community_id where parent_id = 0 and t1.area_code ='510423') partyOrg, |
|---|
| | | (select count(id) from com_pb_member t LEFT JOIN com_act t1 on t.community_id = t1.community_id where audit_result = 1 and t1.area_code ='510423') partyMember, |
|---|
| | | (select count(id) from com_mng_volunteer_mng t LEFT JOIN com_act t1 on t.community_id = t1.community_id where t.state = 2 and t1.area_code ='510423') volunteer, |
|---|
