SELECT PCB.CategoryName, P.PageName, PCB.`CategoryId` FROM PageCategoryBridge PCB INNER JOIN Page P ON P.StateId=13 AND PCB.PageId=P.PageId AND P.TownId = 9392 WHERE PCB.CategoryId IN (8352,8353,8354,8355,8356,8357,8358,8359,8360,8361) AND PCB.CategoryPageNumber=1 AND PCB.StateId=13 limit 4; your city Yellow Pages | Fave Central Community