Self-Drive 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(1320) "SELECT DISTINCT t1.tour_id AS tour_id FROM Search164fc5a89850e9014cb8d2e062041ccd 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 (34) AND tr.object_id = post_s1.ID ) = 1) AND meta_destination.meta_value IN (10052689) AND post_s1.post_type = 'tour' AND ( STR_TO_DATE(meta_date.meta_value,'%d-%m-%Y')> STR_TO_DATE('10-04-2021','%d-%m-%Y') OR meta_date.meta_value IS NULL) LIMIT 0, 12;"

1 Ergebnisse gefunden.

Preis
Weitere Filter
Reiseländer

Du möchtest gerne auf eigene Faust fahren und völlig unabhängig auf Deinem Motorrad die Freiheit genießen? Dann haben wir für Dich eine ganze Reihe interessanter Selbstfahrer-Reisen im Programm. Alle Touren wurden von erfahrenen Bikern ausgearbeitet und bieten Fahrspaß und Erlebnis pur. Du erhältst hierzu umfangreiches Infomaterial und ein ausführliches Roadbook, mit dem Du sorgenfrei die Reise genießen kannst…

Sortiert nach:

Südafrika Route 62 – Garden Route 14 Tage/ 13 Nächte
0 Review

0 Review

ab

3.050 €

Startort

Kapstadt

ab

3.050 €

Mietmotorrad: Ja
Schwierigkeitsgrad: leicht
Begleitfahrzeug: Nein