花城 【小程序】干部统计排行：所属单位字段显示为空
| | |
|---|
| | | communityId, memberId, memberName, belongUnit, belongCommunity, belongTo,sum(award) as partyCount |
|---|
| | | FROM ( |
|---|
| | | SELECT caa.id, caa.duration, cpcu.id as unitId,cpcu.name as unitName,cpcu.org_name as orgName, cpcu.community_id as communityId, su.user_id as |
|---|
| | | memberId, su.name as memberName, su.relation_name as belongUnit, ca.name as belongCommunity, cpcu.belong_to belongTo,caa.pb_reward_integral as award |
|---|
| | | memberId, su.name as memberName, cpcu.name as belongUnit, ca.name as belongCommunity, cpcu.belong_to belongTo,caa.pb_reward_integral as award |
|---|
| | | FROM `com_act_activity` as caa |
|---|
| | | left join com_act_act_regist as caar on caa.id=caar.activity_id |
|---|
| | | left join sys_user as su on caar.user_id=su.user_id |
|---|
