SELECT wp_544149_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_544149_postmeta price_meta2 WHERE price_meta2.post_id=wp_544149_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_544149_postmeta price_meta3 WHERE price_meta3.post_id=wp_544149_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_544149_posts INNER JOIN wp_544149_postmeta ON ( wp_544149_posts.ID = wp_544149_postmeta.post_id )
WHERE 1=1 AND (
( wp_544149_postmeta.meta_key = 'accommodation_location_post_id' AND wp_544149_postmeta.meta_value IN ('7301') )
) AND wp_544149_posts.post_type = 'accommodation' AND ((wp_544149_posts.post_status = 'publish'))
GROUP BY wp_544149_posts.ID HAVING 1=1
ORDER BY wp_544149_posts.post_title ASC
Terra Mare Suites
Mytakas
From
CHF
266,45
Je vous ai déniché une pépite pieds dans l'eau! Pour les amoureux de la mer
Unfortunately no cruises were found.
Unfortunately no car rentals were found.