string(1164) " FROM Search9592969bf152ff6d9b1cfa5e0392c164 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 (126) 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')"
Εγγραφείτε για να λαμβάνετε πρώτοι όλα τα νέα και τις προτάσεις μας
Χρησιμοποιούμε cookies για να βελτιώσουμε την εμπειρία σας στον ιστότοπό μας. Με την περιήγηση σε αυτόν τον ιστότοπο, αποδέχεστε τη χρήση των cookies από εμάς.Εντάξει