SELECT C.CategoryId, C.CategoryName as CategoryName, P.PageName as CategoryFirstPageName, SUBSTRING(C.CategoryName,1,1) AS letter, ListingCount, RatingCount FROM PageCategoryBridge B INNER JOIN Category C ON B.StateId = 50 and B.TownId=15919 AND B.CategoryId = C.CategoryId INNER JOIN Page P ON P.StateId = 50 and P.TownId=15919 AND B.PageId = P.PageId WHERE B.StateId = 50 and B.CategoryPageNumber = 1 order by ListingCount Desc your city Yellow Pages | Fave Central Community