Ενοικίαση Ιστιοπλοϊκού στο Ιόνιο
Εξερευνήστε τα νησιά του Ιονίου με τα ιδιόκτητα σκάφη μας!
string(1185) "SELECT wp_is_posts.* FROM wp_is_posts INNER JOIN wp_is_postmeta ON ( wp_is_posts.ID = wp_is_postmeta.post_id ) INNER JOIN wp_is_postmeta AS mt1 ON ( wp_is_posts.ID = mt1.post_id ) INNER JOIN wp_is_postmeta AS mt2 ON ( wp_is_posts.ID = mt2.post_id ) JOIN wp_is_icl_translations wpml_translations
ON wp_is_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_is_posts.post_type) WHERE 1=1 AND (
( wp_is_postmeta.meta_key = 'boat_type' AND wp_is_postmeta.meta_value = 'monohull' )
AND
( mt1.meta_key = 'people_query' AND CAST(mt1.meta_value AS SIGNED) >= '11' )
AND
( mt2.meta_key = 'people_query' AND CAST(mt2.meta_value AS SIGNED) <= '12' )
) AND wp_is_posts.post_type = 'boat' AND (wp_is_posts.post_status = 'publish' OR wp_is_posts.post_status = 'acf-disabled') AND ( ( ( wpml_translations.language_code = 'el' OR 0 ) AND wp_is_posts.post_type IN ('post','page','attachment','wp_block','boat','review','bases_destinations' ) ) OR wp_is_posts.post_type NOT IN ('post','page','attachment','wp_block','boat','review','bases_destinations' ) ) GROUP BY wp_is_posts.ID ORDER BY wp_is_posts.menu_order ASC "