Let us do the ground work for you and help you plan the perfect Maldives resort holiday. Tell us exactly what you want, including preferred dates, number of guests and budget and we’ll make it happen
- SELECT SQL_CALC_FOUND_ROWS M8G_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM M8G_postmeta price_meta2 WHERE price_meta2.post_id=M8G_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-11-21:2027-11-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM M8G_postmeta price_meta3 WHERE price_meta3.post_id=M8G_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price FROM M8G_posts INNER JOIN M8G_postmeta ON ( M8G_posts.ID = M8G_postmeta.post_id ) WHERE 1=1 AND ( ( M8G_postmeta.meta_key = 'accommodation_is_featured' AND CAST(M8G_postmeta.meta_value AS SIGNED) = '1' ) ) AND M8G_posts.post_type = 'accommodation' AND ((M8G_posts.post_status = 'publish')) GROUP BY M8G_posts.ID HAVING 1=1 ORDER BY RAND() LIMIT 0, 3
