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