SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-02-26:2027-02-26' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.ID DESC
LIMIT 0, 3
Greece (Greek: Ελλάδα, Ellada, [eˈlaða]), officially the Hellenic Republic and also known as Hellas, is a country located in Southeast Europe. Its population is approximately 10.7 million; Athens is the capital, Inorthwest borders Albania to the northwest, North Macedonia & Bulgaria to the north, Turkey to the northeast. The Aegean Sea in east, the Ionian Sea to the west, the Cretan Sea and the Mediterranean Sea to the south. Greece has the 11th longest coastline in the world at 13,676 km (8,498 Mi), 227 islands are inhabited. Eighty percent of Greece is mountainous, with Mount Olympus being the highest peak at 2,918 meters (9,573 Ft).
Australia, officially the Commonwealth of Australia, is a sovereign country comprising the mainland of the Australian continent, the island of Tasmania, and numerous smaller islands. It is the largest country in Oceania and the world's sixth-largest country by total area. The population of 26 million is highly urbanized and heavily concentrated on the eastern seaboard. Australia's capital is Canberra, and its largest city is Sydney. The country's other major metropolitan areas are Melbourne, Brisbane, Perth, and Adelaide.