SELECT L.ListingId, L.Rank, L.CategoryId, F.*, FD.Description FROM Listing L INNER JOIN Firm F ON L.FirmId = F.FirmId LEFT JOIN FirmDescription FD ON F.FirmId=FD.FirmId WHERE F.PageId != 1 AND L.StateId = 51 AND L.TownId=21007 AND F.StateId = 51 AND F.TownId=21007 AND L.CategoryId =8240 ORDER BY L.Rank DESC LIMIT 0, 30 your city Yellow Pages | Fave Central Community