| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="pageSocialOrgList" resultType="com.panzhihua.common.model.vos.community.ComActSocialOrgVO"> |
|---|
| | | SELECT t.id, t.`name`, t.company_type, t.attach_url, t.streetName,, t.create_at, t.service_type, |
|---|
| | | SELECT t.id, t.`name`, t.company_type, t.attach_url, t.streetName, t.create_at, t.service_type, |
|---|
| | | (SELECT COUNT(id) FROM com_act_social_member WHERE org_id = t.id) AS staffCount, |
|---|
| | | (SELECT COUNT(id) FROM com_act_social_project WHERE responsibility_type = 3 AND responsibility_id = t.id) AS undertakeProjectNum, |
|---|
| | | (SELECT COUNT(id) FROM com_act_activity WHERE `type` = 4 AND project_id IN ( |
|---|
