| | |
| | | IFNULL((select count(DISTINCT `name`) from com_mng_village where community_id = cmpct.community_id),0) as village, |
| | | IFNULL((select count(user_id) from sys_user where community_id = cmpct.community_id and type=1),0) as user, |
| | | IFNULL((select count(id) from com_pb_member where community_id = cmpct.community_id ),0) as partyMember, |
| | | IFNULL((select count(user_id) from sys_user where community_id = cmpct.community_id and is_volunteer=1 and type=1),0) as volunteer |
| | | IFNULL((select count(user_id) from sys_user where community_id = cmpct.community_id and is_volunteer=1 and type=1),0) as volunteer, |
| | | IFNULL((select count(id) from com_pb_org where community_id = cmpct.community_id and parent_id = 0),0) as partyOrg |
| | | from com_mng_population_community_tags AS cmpct |
| | | where cmpct.community_id = #{communityId} |
| | | </select> |