SELECT SQL_CALC_FOUND_ROWS mod202_posts.*, (
SELECT SUM(rooms_available) rooms_available FROM (SELECT IFNULL(SUM(room_count), 0) rooms_available, availabilities.accommodation_id FROM mod202_byt_accommodation_vacancies availabilities INNER JOIN (
select d.the_date from
(
select adddate('2026-03-15',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4
having the_date between '2026-03-15' and '2028-03-15'
ORDER BY the_date
) d
where DATE(d.the_date) >= DATE(CURDATE())
group by d.the_date
order by d.the_date
) possible_dates ON (possible_dates.the_date >= DATE(availabilities.start_date) AND possible_dates.the_date < DATE(availabilities.end_date)) WHERE 1=1 AND ('2026-03-15' BETWEEN start_date AND end_date OR start_date <= '2028-03-15') AND end_date >= '2026-03-15' GROUP BY possible_dates.the_date, availabilities.accommodation_id ) as ra WHERE accommodation_id = mod202_posts.ID ) rooms_available , (
SELECT IFNULL(SUM(rooms_booked), 0) rooms_booked FROM ((SELECT IFNULL(SUM(bookings.room_count), 0) rooms_booked, bookings.accommodation_id, possible_dates.the_date FROM mod202_byt_accommodation_bookings bookings INNER JOIN (
select d.the_date from
(
select adddate('2026-03-15',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4
having the_date between '2026-03-15' and '2028-03-15'
ORDER BY the_date
) d
where DATE(d.the_date) >= DATE(CURDATE())
group by d.the_date
order by d.the_date
) possible_dates ON (possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date < DATE(bookings.date_to)) AND IFNULL(woo_status, '') IN ('completed') WHERE 1=1 GROUP BY possible_dates.the_date, accommodation_id ) as rb, (SELECT MIN(start_date) min_start_date, MAX(end_date) max_end_date, accommodation_id FROM mod202_byt_accommodation_vacancies GROUP BY accommodation_id) min_max_available_dates ) WHERE rb.accommodation_id = mod202_posts.ID AND min_max_available_dates.accommodation_id = mod202_posts.ID AND rb.the_date >= min_max_available_dates.min_start_date AND rb.the_date < min_max_available_dates.max_end_date ) rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM mod202_postmeta price_meta2 WHERE price_meta2.post_id=mod202_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-03-15:2028-03-15' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM mod202_postmeta price_meta3 WHERE price_meta3.post_id=mod202_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM mod202_posts
WHERE 1=1 AND mod202_posts.post_type = 'accommodation' AND ((mod202_posts.post_status = 'publish'))
GROUP BY mod202_posts.ID HAVING 1=1 AND rooms_available > rooms_booked AND rooms_available >= 1
ORDER BY accommodation_price ASC
LIMIT 0, 12
Chambre élégante et chaleureuse, au premier étage, offrant une vue sur la cour et sa piscine et la truffière. La dominante verte de la tête de lit et de la faïence évoque la forêt et la nature, sublimée par des touches de noir dans les cadres, luminaires et chevets, rappelant la mystérieuse richesse de la truffe noire d’hiver. Très lumineuse grâce à ses deux fenêtres traversantes, elle dispose d’un sol en parquet en bois, d’une salle d’eau moderne et d’un WC séparé.
check_circle 1 lit 160 x 200 cm et 1 lit de 90 x 200 cm check_circle 18m² hors sanitaires check_circle 1 à 3 personnes
Découvrez une ambiance estivale et chaleureuse, où le bleu du ciel et de l’été s’harmonise avec des touches de blanc et de noir, évoquant subtilement la truffe d’été, aussi élégante que rare, pour une décoration à la fois raffinée et pleine de fraîcheur. Une jolie chambre au premier étage, avec vue sur la cour intérieure, la piscine et avec vue sur la truffière. Très lumineuse avec ses deux fenêtres traversantes. Sol en plancher bois, salle d’eau et WC séparé. Espace bureau.
check_circle 1 lit 160 x 200 cm et 1 lit 90 x 200 cm check_circle 20 m² hors sanitaires check_circle 1 à 3 personnes
Nous utilisons des cookies pour vous garantir la meilleure expérience sur notre site web. Si vous continuez à utiliser ce site, nous supposerons que vous en êtes satisfait.
