select distinct SitemapLevel2Id from SitemapTown where StateId=27 and TownId in (9427,9455,9459,9489,9515,9553) your city Yellow Pages | Fave Central Community