SELECT DISTINCT s.abv, s.name, bc.bizname
FROM (`aaruname_db1`.`states` s INNER JOIN `aaruname_db1`.`biz_contacts` bc ON s.abv=bc.state) INNER JOIN `aaruname_db1`.`biz_types` bt ON bc.type = bt. biztype_id
WHERE bc.active = 1 AND bt.lodging <> 1
AND (type = 37 OR bc.bizamens LIKE '%23%'
)
ORDER BY s.name;
Find Guided Kayak Trips and Guided Canoe Trips - Search a full selection of Guided Kayak Tours and Guided Canoe Tours on AllAboutRivers.com
Email this page to a friend
