select outfitter_trip.outfitter_trip_id as id,outfitter_trip.name,outfitter_trip.city,outfitter_trip.state,outfitter_trip.short_description as dsc,outfitter_trip.fee,outfitter_trip.outfitter_id,outfitter.name as outfitter_name,outfitter.image_logo as image,outfitter_trip.destination_id,destination.name as destination_name from outfitter_trip,outfitter,destination where (outfitter_trip.outfitter_id=343) and (outfitter_trip.outfitter_id=outfitter.outfitter_id) and (outfitter_trip.destination_id=destination.destination_id) order by outfitter_trip.




Home | 
Destinations | 
Activities | 
Organizations






;