select T.*, S.StateName from Town T inner join State S ON T.StateId=S.StateId where T.Display=1 order by T.TownName, T.StateCode limit -500,500 your city Yellow Pages | Fave Central Community

Fave Cities