Accommodation grid layout examples
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 2
Amaya Kuda Rah
Atoll d'Ari Sud, Maldives
From
$
LE LUXE AU PARADIS
L'un des meilleurs complexes de luxe des Maldives. Vivez une croisière au coucher du soleil et trouvez le bonheur intérieur dans notre spa.
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 3
Amaya Kuda Rah
Atoll d'Ari Sud, Maldives
From
$
LE LUXE AU PARADIS
L'un des meilleurs complexes de luxe des Maldives. Vivez une croisière au coucher du soleil et trouvez le bonheur intérieur dans notre spa.
Ammon Zeus hôtel
Kallithea
From
$
La mer est aux eaux cristallines et la plage est très propre et sablonneuse.
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 4
Amaya Kuda Rah
Atoll d'Ari Sud, Maldives
From
$
LE LUXE AU PARADIS
L'un des meilleurs complexes de luxe des Maldives. Vivez une croisière au coucher du soleil et trouvez le bonheur intérieur dans notre spa.
Ammon Zeus hôtel
Kallithea
From
$
La mer est aux eaux cristallines et la plage est très propre et sablonneuse.
Anteliz Suites Boutique Hôtel
îles Cyclades
From
$
Découvrez Santorin, une destination unique dans les îles grecques
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 5
Amaya Kuda Rah
Atoll d'Ari Sud, Maldives
From
$
LE LUXE AU PARADIS
L'un des meilleurs complexes de luxe des Maldives. Vivez une croisière au coucher du soleil et trouvez le bonheur intérieur dans notre spa.
Ammon Zeus hôtel
Kallithea
From
$
La mer est aux eaux cristallines et la plage est très propre et sablonneuse.
Anteliz Suites Boutique Hôtel
îles Cyclades
From
$
Découvrez Santorin, une destination unique dans les îles grecques
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 4
Amaya Kuda Rah
Atoll d'Ari Sud, Maldives
From
$
Ammon Zeus hôtel
Kallithea
From
$
Anteliz Suites Boutique Hôtel
îles Cyclades
From
$
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS wp_1091640_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_1091640_postmeta price_meta2 WHERE price_meta2.post_id=wp_1091640_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-16:2028-04-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_1091640_postmeta price_meta3 WHERE price_meta3.post_id=wp_1091640_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_1091640_posts
WHERE 1=1 AND wp_1091640_posts.post_type = 'accommodation' AND ((wp_1091640_posts.post_status = 'publish'))
GROUP BY wp_1091640_posts.ID HAVING 1=1
ORDER BY wp_1091640_posts.post_title ASC
LIMIT 0, 2
