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(1099) "SELECT DISTINCT t1.tour_id AS tour_id FROM Searchf4e62f061b585221983b0bd86c536daa 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_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 ( STR_TO_DATE(meta_date.meta_value,'%d-%m-%Y')> STR_TO_DATE('29-07-2021','%d-%m-%Y') OR meta_date.meta_value IS NULL) LIMIT 0, 12;"