| | |
| | | ( |
| | | SELECT count(*) FROM com_convenient_consultation_statistics ccs inner JOIN |
| | | ( SELECT cm.id from com_convenient_merchants as cm INNER JOIN com_act as ca on ca.community_id = cm.community_id |
| | | where ca.app_id = 'wx118de8a734d269f0' |
| | | ) as mc on mc.id = ccs.merchant_id |
| | | ) as consultationStatistics, |
| | | |
| | | ( SELECT count(*) FROM event_grid_member_relation as mr INNER JOIN com_act as ca on ca.community_id = mr.grid_community_id |
| | | where ca.app_id = 'wx118de8a734d269f0' ) as gridMember |
| | | ) as gridMember |
| | | |
| | | |
| | | |
| | |
| | | com_act_neighbor_circle_topic_new AS ctn |
| | | LEFT JOIN ( |
| | | SELECT new_fight_need_problem_inventory.* from new_fight_need_problem_inventory inner join ( |
| | | SELECT community_id from com_act WHERE app_id ='wx118de8a734d269f0' |
| | | SELECT community_id from com_act |
| | | ) as ca on ca.community_id = new_fight_need_problem_inventory.community_id |
| | | <if test="yearTime != null and yearTime != '' "> |
| | | WHERE |