THEMATIC

string(1164) " FROM Search0b7757408b4fed0471587fccfff03fb1 as t1 INNER JOIN mthr_posts post_s1 ON (t1.tour_id = post_s1.ID) AND (post_s1.post_status = 'publish') AND (post_s1.post_type = 'tour') LEFT JOIN mthr_postmeta AS meta_price ON post_s1.ID = meta_price.post_id AND meta_price.meta_key = 'aventura_adult_price' LEFT JOIN mthr_postmeta AS meta_rating ON post_s1.ID = meta_rating.post_id AND meta_rating.meta_key = 'tz-average-rating' LEFT JOIN mthr_postmeta AS meta_views ON post_s1.ID = meta_views.post_id AND meta_views.meta_key = 'post_views_count' INNER JOIN mthr_postmeta AS meta_types ON post_s1.ID = meta_types.post_id AND meta_types.meta_key = 'aventura_tour_type' LEFT JOIN mthr_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 mthr_term_relationships AS tr INNER JOIN mthr_term_taxonomy AS tt1 ON ( tr.term_taxonomy_id= tt1.term_taxonomy_id ) WHERE tt1.taxonomy = 'tour-category' AND tt1.term_id IN (157) AND tr.object_id = post_s1.ID )) AND (meta_types.meta_value = 'special' OR meta_types.meta_value = 'daily' OR meta_types.meta_value = 'external')"
string(1) "2"

Thematic excursions throughout Greece

5 days in Venice

5 ημέρες & 4 βράδια
0 Review
0 Review

From

€50,00

Date

22 October 2026

Departure

Βενετία, Ιταλία

From

€50,00

5 days in Arachova

3 Days & 4 Nights
0 Review
0 Review

From

€40,00

Date

10 November 2021

Departure

Vacation

From

€40,00

2 results found.