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-07-20',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-07-20' and '2028-07-20'
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-07-20' BETWEEN start_date AND end_date OR start_date <= '2028-07-20') AND end_date >= '2026-07-20' 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-07-20',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-07-20' and '2028-07-20'
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-07-20:2028-07-20' 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
WHERE 1=1 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 accommodation_price ASC
LIMIT 0, 24
[:ru]Бутик-отель Evexia & Spa**** принимает гостей от 16 лет и разрешает проживание с домашними животными. Он расположен всего в 50 метрах от знаменитого песчаного пляжа Агия Марина в Ханье на острове Крит.[:en]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.[:]
[:en]Main Road Ierapetra - Siteia Crete[:ru]Главная дорога Иерапетра - Крет
From €
[:ru]Три роскошные виллы с частными бассейнами, видом на море, современными удобствами и атмосферой полного спокойствия в тихом районе Галини на Крите.[:en]Three luxury villas with private pools, sea views, modern comforts, and a serene atmosphere designed for complete relaxation in the peaceful area of Galini, Crete.[:]
[:ru]2. Проспект Александра Великого, Салоники[:el]Λεωφόρος Μεγάλου Αλεξάνδρου 2 Θεσσαλονίκη[:en]2 Alexander the Great Avenue Thessaloniki
From €
[:ru]Современный, аристократичный, культовый и актуальный — вот лишь некоторые слова, описывающие отель «Македония».[:en]Modern, aristocratic, iconic and contemporary, are only some of the words that define Makedonia Palace.[:el]Μοντέρνο, αριστοκρατικό, εμβληματικό και σύγχρονο, είναι μόνο μερικές από τις λέξεις που ορίζουν το Makedonia Palace.[:]
[:ru]Наша миссия — порадовать наших гостей исключительным опытом в уникальном историческом центре нашего города[:en]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.[:]
[:en]Ornos Beach Mykonos island[:ru]Пляж Орнос, остров Миконос
From €
[:ru] Элитный отдых на берегу залива Орнос Откройте для себя истинную магию Миконоса в Mykonos Ammos Hotel. Пятизвездочный бутик-отель, член сети Small Luxury Hotels of the World, предлагает безупречный сервис у самой кромки моря, высокую кухню в ресторане Kuzina и эксклюзивные спа-ритуалы для идеальной гармонии души и тела.[:en]Barefoot Luxury on Ornos Beach Experience the quintessential Mykonian lifestyle at Mykonos Ammos Hotel. A 5-star boutique retreat and member of Small Luxury Hotels of the World, offering elegant beachfront living, world-class gastronomy at Kuzina, and holistic wellness, all just steps away from the crystal-clear Aegean waters.[:]
[:ru]РоскошныйпляжныйкурортAquagrandArtistic — это прибрежный оазис в Линдосе, где романтика и отдых органично переплетаются.[:en]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.[:el]Το Aquagrand Artistic Luxury Beach Resort είναι ένα παραθαλάσσιο καταφύγιο που βρίσκεται στη Λίνδο, όπου ο ρομαντισμός και η χαλάρωση συνδυάζονται αβίαστα.[:]
