@Select({ "<script>select " + ALL_COLUMNS + " from " + TABLE_NAME,

            " where type = 2 and territory_id in "

                    + "<foreach collection='crmTerritoryIds' item='territoryId' index='index' open='(' close=')' "

                    + "separator=','>"

                    + "#{territoryId} </foreach></script>" })

    public List<Area> selectAreaByTerritoryIds(@Param("crmTerritoryIds") List<Long> crmTerritoryIds);