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 = 13 AND L.TownId=28188 AND
F.StateId = 13 AND F.TownId=28188 AND
L.CategoryId =8351
ORDER BY L.Rank DESC LIMIT 0, 30
your city Yellow Pages
| Fave Central Community
Looking for free advertising? Look no more. Grab your "Free Ads".