Accommodation list layout examples
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title ASC
LIMIT 0, 1
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title ASC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title ASC
LIMIT 0, 7
Bayu Inn
Pantai CenangFrom RM
Found Mansion
Padang PutehFrom RM
Geopark Hotel
KuahFrom RM
Greenish Hotel
KuahFrom RM
Level 4.Simfoni
LangkawiFrom RM
Malibest Resort
Pantai CenangFrom RM
Royal Agate
Pantai CenangFrom RM
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title ASC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title DESC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title ASC
LIMIT 0, 3
Bayu Inn
Pantai Cenang
From
RM
Found Mansion
Padang Puteh
From
RM
Geopark Hotel
Kuah
From
RM
SELECT SQL_CALC_FOUND_ROWS wpq2_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpq2_postmeta price_meta2 WHERE price_meta2.post_id=wpq2_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-13:2028-01-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpq2_postmeta price_meta3 WHERE price_meta3.post_id=wpq2_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpq2_posts
WHERE 1=1 AND wpq2_posts.post_type = 'accommodation' AND ((wpq2_posts.post_status = 'publish'))
GROUP BY wpq2_posts.ID HAVING 1=1
ORDER BY wpq2_posts.post_title DESC
LIMIT 0, 3
