Accommodation grid layout examples
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 2
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 3
![Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/09/Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400.jpg)
Apartament Bobâlnei din Cluj-Napoca
Cluj-Napoca, strada Bobâlnei nr. 46, județul Cluj
Tarif de la:
Lei
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 4
![Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/09/Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400.jpg)
Apartament Bobâlnei din Cluj-Napoca
Cluj-Napoca, strada Bobâlnei nr. 46, județul Cluj
Tarif de la:
Lei
![Cazare-la-Apartament-Bonjour-din-Mangalia-Litoral-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/07/Cazare-la-Apartament-Bonjour-din-Mangalia-Litoral-1-600x400.jpg)
Apartament Bonjour din Mangalia
Mangalia, str. Nicolae Iorga, nr. 2E, județul Constanța
Tarif de la:
Lei
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 5
![Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/09/Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400.jpg)
Apartament Bobâlnei din Cluj-Napoca
Cluj-Napoca, strada Bobâlnei nr. 46, județul Cluj
Tarif de la:
Lei
![Cazare-la-Apartament-Bonjour-din-Mangalia-Litoral-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/07/Cazare-la-Apartament-Bonjour-din-Mangalia-Litoral-1-600x400.jpg)
Apartament Bonjour din Mangalia
Mangalia, str. Nicolae Iorga, nr. 2E, județul Constanța
Tarif de la:
Lei
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 4
![Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/09/Cazare-la-Apartament-Bobalnei-din-Cluj-Napoca-Transilvania-1-600x400.jpg)
Apartament Bobâlnei din Cluj-Napoca
Cluj-Napoca, strada Bobâlnei nr. 46, județul Cluj
Tarif de la:
Lei
![Cazare-la-Apartament-Bonjour-din-Mangalia-Litoral-1-600x400 Accommodations grid layouts](https://www.descoperimromania.ro/wp-content/uploads/2015/07/Cazare-la-Apartament-Bonjour-din-Mangalia-Litoral-1-600x400.jpg)
Apartament Bonjour din Mangalia
Mangalia, str. Nicolae Iorga, nr. 2E, județul Constanța
Tarif de la:
Lei
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS diws_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM diws_postmeta price_meta2 WHERE price_meta2.post_id=diws_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM diws_postmeta price_meta3 WHERE price_meta3.post_id=diws_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM diws_posts
WHERE 1=1 AND diws_posts.post_type = 'accommodation' AND ((diws_posts.post_status = 'publish'))
GROUP BY diws_posts.ID HAVING 1=1
ORDER BY diws_posts.post_title ASC
LIMIT 0, 2