| | |
|---|
| | | <select id="getVillagePopulationTotalNew" |
|---|
| | | resultType="com.panzhihua.common.model.vos.screen.ScreenDrawEventPopulationTotalVO"> |
|---|
| | | SELECT |
|---|
| | | (SELECT count(id) FROM com_mng_population WHERE road = ( SELECT alley FROM com_mng_village WHERE village_id = #{villageId} ) |
|---|
| | | AND door_no = ( SELECT house_num FROM com_mng_village WHERE village_id = #{villageId} )) as populationTotal, |
|---|
| | | (SELECT count(id) FROM com_mng_population WHERE village_id = #{villageId}) as populationTotal, |
|---|
| | | (SELECT count(id) from com_mng_building where village_id = #{villageId}) as buildTotal, |
|---|
| | | (SELECT count(id) FROM com_mng_population_house WHERE village_id = #{villageId}) as houseTotal, |
|---|
| | | (select count(id) from com_mng_population where village_id = #{villageId} and out_or_local = 1) as localTotal, |
|---|
