SELECT SQL_CALC_FOUND_ROWS trvl57ch_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM trvl57ch_postmeta price_meta2 WHERE price_meta2.post_id=trvl57ch_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-12-12:2026-12-12' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM trvl57ch_postmeta price_meta3 WHERE price_meta3.post_id=trvl57ch_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM trvl57ch_posts LEFT JOIN trvl57ch_term_relationships ON (trvl57ch_posts.ID = trvl57ch_term_relationships.object_id) INNER JOIN trvl57ch_postmeta ON ( trvl57ch_posts.ID = trvl57ch_postmeta.post_id )
WHERE 1=1 AND (
trvl57ch_term_relationships.term_taxonomy_id IN (1229)
) AND (
trvl57ch_postmeta.meta_key = 'accommodation_star_count'
) AND trvl57ch_posts.post_type = 'accommodation' AND ((trvl57ch_posts.post_status = 'publish'))
GROUP BY trvl57ch_posts.ID HAVING 1=1
ORDER BY trvl57ch_postmeta.meta_value+0 DESC
LIMIT 24, 12
Situé au coeur d'Athènes, «la ville européenne qui ne dort jamais». L'hôtel se dresse avec fierté sur la célèbre place Omonia (Concorde) avec sa fontaine au milieu de la place, qui donne un charme certain à la ville.