| | |
|---|
| | | SELECT |
|---|
| | | count( id ) as populationTotal, |
|---|
| | | (select count(id) from com_mng_population where village_id = #{villageId} and out_or_local = 1) as localTotal, |
|---|
| | | (select count(id) from com_mng_population where village_id = #{villageId} and out_or_local = 2) as localTotal, |
|---|
| | | (select count(id) from com_mng_population_community_tags as cmpct left join com_mng_population as cmp on cmpct.population_id = cmp.id where cmp.village_id = #{villageId} and cmpct.label is not null) as specialTotal, |
|---|
| | | (select count(id) from com_mng_population where village_id = #{villageId} and out_or_local = 2) as outTotal, |
|---|
| | | (select count(cmp.id) from com_mng_population_community_tags as cmpct left join com_mng_population as cmp on cmpct.population_id = cmp.id where cmp.village_id = #{villageId} and cmpct.label is not null) as specialTotal, |
|---|
| | | (select count(id) from com_mng_building where village_id = #{villageId}) as buildTotal |
|---|
| | | FROM |
|---|
| | | com_mng_population AS cmp |
|---|
