Accommodation list layout examples
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title ASC
LIMIT 0, 1

Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) Athens
From
€
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 ...
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title ASC
LIMIT 0, 3

Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) Athens
From
€
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 ...
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title ASC
LIMIT 0, 7

Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) AthensFrom €
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title ASC
LIMIT 0, 3

Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) Athens
From
€
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 ...
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title DESC
LIMIT 0, 3

Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) Athens
From
€
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 ...
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title ASC
LIMIT 0, 3
Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) Athens
From
€
SELECT SQL_CALC_FOUND_ROWS HMNxkYV_posts.*, 1 rooms_available, 0 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-02-16:2028-02-16' 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
ORDER BY HMNxkYV_posts.post_title DESC
LIMIT 0, 3
