SELECT wp_iv16_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_iv16_postmeta price_meta2 WHERE price_meta2.post_id=wp_iv16_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-12-09:2026-12-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_iv16_postmeta price_meta3 WHERE price_meta3.post_id=wp_iv16_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_iv16_posts INNER JOIN wp_iv16_postmeta ON ( wp_iv16_posts.ID = wp_iv16_postmeta.post_id )
WHERE 1=1 AND (
( wp_iv16_postmeta.meta_key = 'accommodation_location_post_id' AND wp_iv16_postmeta.meta_value IN ('56') )
) AND wp_iv16_posts.post_type = 'accommodation' AND ((wp_iv16_posts.post_status = 'publish'))
GROUP BY wp_iv16_posts.ID HAVING 1=1
ORDER BY wp_iv16_posts.post_title ASC
Unfortunately no accommodations were found.
Lorem ipsum dolor sit amet, consectetur adipisci elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur.
Quis aute iure reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint obcaecat cupiditat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
