SELECT PCB.CategoryName, P.PageName, PCB.`CategoryId` FROM PageCategoryBridge PCB INNER JOIN Page P ON P.StateId=26 AND PCB.PageId=P.PageId AND P.TownId = 10385 WHERE PCB.CategoryId IN (8116,8117,8118,8119,8120,8121,8122,8123,8124,8125) AND PCB.CategoryPageNumber=1 AND PCB.StateId=26 limit 4; your city Yellow Pages | Fave Central Community