Enduro-Reisen

string(0) ""
SELECT t1.* FROM ( SELECT DISTINCT post_s1.ID AS tour_id FROM abr_posts AS post_s1 WHERE (post_s1.post_status = 'publish') AND (post_s1.post_type = 'tour') ) AS t1 WHERE 1=1
string(1317) "SELECT DISTINCT t1.tour_id AS tour_id FROM Search00cb56008d54b7e4a0b158c2908e30d7 as t1 INNER JOIN abr_posts post_s1 ON (t1.tour_id = post_s1.ID) AND (post_s1.post_status = 'publish') AND (post_s1.post_type = 'tour') LEFT JOIN abr_postmeta AS meta_destination ON post_s1.ID = meta_destination.post_id AND meta_destination.meta_key = 'aventura_tour_destination' LEFT JOIN abr_postmeta AS meta_price ON post_s1.ID = meta_price.post_id AND meta_price.meta_key = 'aventura_adult_price' LEFT JOIN abr_postmeta AS meta_rating ON post_s1.ID = meta_rating.post_id AND meta_rating.meta_key = 'tz-average-rating' LEFT JOIN abr_postmeta AS meta_views ON post_s1.ID = meta_views.post_id AND meta_views.meta_key = 'post_views_count' LEFT JOIN abr_postmeta AS meta_date ON post_s1.ID = meta_date.post_id AND meta_date.meta_key = 'aventura_tour_end_date' WHERE 1=1 AND (( SELECT COUNT(1) FROM abr_term_relationships AS tr INNER JOIN abr_term_taxonomy AS tt1 ON ( tr.term_taxonomy_id= tt1.term_taxonomy_id ) WHERE tt1.taxonomy = 'tour-category' AND tt1.term_id IN (47) AND tr.object_id = post_s1.ID ) = 1) AND meta_destination.meta_value IN (10052976) AND post_s1.post_type = 'tour' AND ( STR_TO_DATE(meta_date.meta_value,'%d-%m-%Y')> STR_TO_DATE('25-09-2021','%d-%m-%Y') OR meta_date.meta_value IS NULL) LIMIT 0, 12;"

1 Ergebnisse gefunden.

Preis
Weitere Filter
Reiseländer

Für alle, die Abenteuer und Action lieben und beides gerne in ihrem Urlaub verbinden möchten, haben wir eine große Auswahl an interessanten und aufregenden Offroad-Touren. Wer also nicht einfach nur gemütlich “cruisen” möchte, sondern abseits befestigter Straßen die Welt “er-fahren” möchte, wird bei uns mit Sicherheit fündig. Alle Enduro-Reisen werden natürlich von erfahrenen Tour-Guides begleitet, und für Einsteiger sind Trainings möglich…

Sortiert nach:

0 Review

ab

4.695 €

Nächster Start

13/11/2021

Startort

Santiago de Chile

ab

4.695 €

Mietmotorrad: Ja
Schwierigkeitsgrad: mittel
Begleitfahrzeug: Ja