SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, (
SELECT SUM(rooms_available) rooms_available FROM (SELECT IFNULL(SUM(room_count), 0) rooms_available, availabilities.accommodation_id FROM HMNxkYV_byt_accommodation_vacancies availabilities INNER JOIN (
select d.the_date from
(
select adddate('2026-03-07',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-07' and '2028-03-07'
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-07' BETWEEN start_date AND end_date OR start_date <= '2028-03-07') AND end_date >= '2026-03-07' GROUP BY possible_dates.the_date, availabilities.accommodation_id ) as ra WHERE accommodation_id = HMNxkYV_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 HMNxkYV_byt_accommodation_bookings bookings INNER JOIN (
select d.the_date from
(
select adddate('2026-03-07',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-07' and '2028-03-07'
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 ('pending','on-hold','completed','processing','cancelled','') 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 HMNxkYV_byt_accommodation_vacancies GROUP BY accommodation_id) min_max_available_dates ) WHERE rb.accommodation_id = HMNxkYV_posts.ID AND min_max_available_dates.accommodation_id = HMNxkYV_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 HMNxkYV_postmeta price_meta2 WHERE price_meta2.post_id=HMNxkYV_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-03-07:2028-03-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM HMNxkYV_postmeta price_meta3 WHERE price_meta3.post_id=HMNxkYV_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM HMNxkYV_posts INNER JOIN HMNxkYV_postmeta ON ( HMNxkYV_posts.ID = HMNxkYV_postmeta.post_id )
WHERE 1=1 AND (
HMNxkYV_postmeta.meta_key = 'accommodation_star_count'
) AND HMNxkYV_posts.post_type = 'accommodation' AND ((HMNxkYV_posts.post_status = 'publish'))
GROUP BY HMNxkYV_posts.ID HAVING 1=1 AND rooms_available > rooms_booked AND rooms_available >= 1
ORDER BY HMNxkYV_postmeta.meta_value+0 ASC
LIMIT 0, 24
Welcome to Amalia Hotel Athens,Greece
Amalia Hotel Athens is located in the heart of Athens, just steps from Syntagma Square and the National Garden, Amalia Hotel Athens blends ...
The brand new Enorme Santana Beach scores top marks for style and it’s wrapped up in a landscape of theatrical location, offering almost 180 view to the Cretan Sea.
Evexia boutique hotel & Spa**** accomodates guests from 16 y.o. and is pet friendly. It is located only 50m. away from the famous sandy beach of Agia Marina in Chania at Crete island.
Imperial Palace | Classical Hotel is situated in the heart of Thessaloniki’s historic and commercial center, is conveniently close to the city’s most important monuments and entertainment venues.
WELCOME
In Paralia Katerini, next to the beach, in the shadow of Olympus Mountain, we created a modern hotel complex designed to offer our guests affordable luxury and convenien...
In the capital of the ancient world, experience luxurious accommodations and personalized service at the NJV Athens Plaza, the city's most exclusive address for distinguished travelers.
The Aquagrand Artistic Luxury Beach Resort is a beachfront sanctuary located in Lindos, where romance and relaxation intertwine effortlessly. With its lush landscapes and panoramic vistas of Navarone Bay.
In complete harmony with the pristine natural environment, within 1,763 hectares of natural grandeur in the iconic Porto Carras Grand Resort complex lies its crown jewel, the Po...
Русский
