FROM €65,00
Single Room
SINGLE/TWIN ROOMS The Hotel has at your disposal 62 Single/Twim rooms with the best conditions for accommodation in this region. Spacious rooms ...
- 1 bed
- 10 m2
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND check_out_timestamp >=
)
OR (
check_in_timestamp >=
' at line 27]SELECT
ID,
wp_postmeta.meta_value as adult_number,
st_meta1.meta_value as children_number
FROM
wp_posts
JOIN wp_postmeta on wp_postmeta.post_id=wp_posts.ID and wp_postmeta.meta_key='adult_number'
JOIN wp_postmeta as st_meta1 on st_meta1.post_id=wp_posts.ID and st_meta1.meta_key='children_number'
where 1=1
AND post_type='hotel_room'
AND wp_posts.ID IN
(
SELECT room_id from(
SELECT
room_id,
COUNT(id) AS total_booked,
wp_postmeta.meta_value
FROM
wp_st_order_item_meta
JOIN wp_postmeta ON wp_postmeta.post_id = room_id
AND wp_postmeta.meta_key = 'number_room'
WHERE
1 = 1
AND (
(
check_in_timestamp <=
AND check_out_timestamp >=
)
OR (
check_in_timestamp >=
AND check_in_timestamp <=
)
)
AND st_booking_post_type = 'hotel_room'
AND STATUS NOT IN (
'trash',
'canceled',
'wc-cancelled'
)
GROUP BY
room_id
Having wp_postmeta.meta_value - total_booked < 1
) as booked_table
)
OR wp_posts.ID IN
(
SELECT
post_id
FROM
wp_st_room_availability
WHERE
1 = 1
AND (
check_in >=
AND check_out <=
AND `status` = 'unavailable'
)
AND post_type='hotel_room'
GROUP BY post_id
)
OR wp_posts.ID IN(
SELECT
post_id
FROM
wp_st_room_availability
WHERE
1 = 1 AND(
adult_number < 0
) AND post_type = 'hotel_room'
)
OR wp_posts.ID IN(
SELECT
post_id
FROM
wp_st_room_availability
WHERE
1 = 1 AND(
child_number < 0
) AND post_type = 'hotel_room'
)
GROUP BY wp_posts.ID
FROM €65,00
FROM €82,50
