SELECT SQL_CALC_FOUND_ROWS wp_spftvh_posts.*, (
SELECT SUM(rooms_available) rooms_available FROM (SELECT IFNULL(SUM(room_count), 0) rooms_available, availabilities.accommodation_id FROM wp_spftvh_byt_accommodation_vacancies availabilities INNER JOIN (
select d.the_date from
(
select adddate('2021-03-01',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 '2021-03-01' and '2023-03-01'
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 ('2021-03-01' BETWEEN start_date AND end_date OR start_date <= '2023-03-01') AND end_date >= '2021-03-01' GROUP BY possible_dates.the_date, availabilities.accommodation_id ) as ra WHERE accommodation_id = wp_spftvh_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 wp_spftvh_byt_accommodation_bookings bookings INNER JOIN (
select d.the_date from
(
select adddate('2021-03-01',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 '2021-03-01' and '2023-03-01'
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 wp_spftvh_byt_accommodation_vacancies GROUP BY accommodation_id) min_max_available_dates ) WHERE rb.accommodation_id = wp_spftvh_posts.ID AND min_max_available_dates.accommodation_id = wp_spftvh_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 wp_spftvh_postmeta price_meta2 WHERE price_meta2.post_id=wp_spftvh_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2021-03-01:2023-03-01' LIMIT 1), 0) accommodation_price FROM wp_spftvh_posts WHERE 1=1 AND wp_spftvh_posts.post_type = 'accommodation' AND ((wp_spftvh_posts.post_status = 'publish')) GROUP BY wp_spftvh_posts.ID HAVING 1=1 AND rooms_available > rooms_booked AND rooms_available >= 1 ORDER BY accommodation_price DESC LIMIT 0, 12
Medium room with Queen bed. Private bath. Two large arched windows draped in damask flood this corner room with sunlight. Historical hummingbird wallpaper and period décor.
check_circle Medium room check_circle Queen Bed check_circle Private bath, 2 L. arched windows
Medium room with a queen bed. Private bath. Decorated in an updated French country style, this room boasts beautiful toile draperies, black painted furniture, and a romantic linen-draped canopy bed.
check_circle Medium room check_circle Queen Bed check_circle Tub, Workspace: Yes.
