| | |
| | | @Param("populationDTO") PageComMngPopulationDTO populationDTO); |
| | | |
| | | @Select("<script> " + "SELECT " + " count( id ) AS localNum, " |
| | | + " ( SELECT count( cmpct.id ) FROM com_mng_population as cmp WHERE cmp.out_or_local = 2 " |
| | | + " ( SELECT count( cmp.id ) FROM com_mng_population as cmp WHERE cmp.out_or_local = 2 " |
| | | + " ) AS flowNum, " |
| | | + " ( SELECT count( cmpct.id ) FROM com_mng_population as cmp left join com_mng_population_community_tags AS cmpct on cmp.id = cmpct.population_id WHERE cmpct.label IS NOT NULL " |
| | | + " ) AS specialNum " + "FROM " |