| | |
|---|
| | | (select count(id) from com_sw_patrol_record t LEFT JOIN com_act t1 on t.community_id = t1.community_id where t1.area_code ='510423') safety, |
|---|
| | | (select count(*) from com_act_reserve t LEFT JOIN com_act_reserve_record t1 on t.id = t1.reserve_id LEFT JOIN com_act t2 on t.community_id = t2.community_id where (title like '%居家隔离%' or title like '%返攀登记%' or title like '%来攀登记%') and t2.area_code ='510423' and t1.status = 2 ) reserve, |
|---|
| | | (select (select count(*) from com_act_activity t LEFT JOIN com_act t1 on t.community_id = t1.community_id where status !=6 and status !=1 and t1.area_code ='510423')+(select count(id) from com_pb_activity t LEFT JOIN com_act t1 on t.community_id = t1.community_id where status !=6 and status !=1 and t1.area_code ='510423')) activity, |
|---|
| | | (select count(*) from com_act_neighbor_circle t LEFT JOIN com_act t1 on t.community_id = t1.community_id |
|---|
| | | where is_del =2 and status=2 and t1.area_code ='510423') neighbor, |
|---|
| | | (select count(*) from com_act_easy_photo t LEFT JOIN com_act t1 on t.community_id = t1.community_id |
|---|
| | | where status in (1,2,4) and del_tag = 0 and t1.area_code ='510423') neighbor, |
|---|
| | | (select count(*) from com_act_discuss t LEFT JOIN com_act t1 on t.community_id = t1.community_id |
|---|
| | | where is_del =2 and t1.area_code ='510423') discuss |
|---|
| | | </select> |
|---|
