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 = 26 and B.TownId=19011 AND B.CategoryId = C.CategoryId INNER JOIN Page P ON P.StateId = 26 and P.TownId=19011 AND B.PageId = P.PageId WHERE B.StateId = 26 and B.CategoryPageNumber = 1 HAVING letter in ('i','j') order by letter ASC, ListingCount Desc your city Yellow Pages | Fave Central Community