SELECT PCB.CategoryName, P.PageName, PCB.`CategoryId` FROM PageCategoryBridge PCB INNER JOIN Page P ON P.StateId=27 AND PCB.PageId=P.PageId AND P.TownId = 16332 WHERE PCB.CategoryId IN (8221,8222,8223,8224,8225,8226,8227,8228,8229,8230) AND PCB.CategoryPageNumber=1 AND PCB.StateId=27 limit 4; your city Yellow Pages | Fave Central Community