Booking Hotels site for travel Booking Cruise cheap prices
Last Minute Offers Ski Holiday
Booking Hotels site for travel Booking Cruise cheap prices
Average rating: 1 reviews Dec 30, 2022
by George
Great site
I have booked several times with this site the support is super nice and professional
SELECT SQL_CALC_FOUND_ROWS bsj_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM bsj_postmeta price_meta2 WHERE price_meta2.post_id=bsj_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-06-05:2025-06-05' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM bsj_postmeta price_meta3 WHERE price_meta3.post_id=bsj_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM bsj_posts LEFT JOIN bsj_term_relationships ON (bsj_posts.ID = bsj_term_relationships.object_id) LEFT JOIN bsj_term_relationships AS tt1 ON (bsj_posts.ID = tt1.object_id)
WHERE 1=1 AND (
bsj_term_relationships.term_taxonomy_id IN (178,187,195,203,213,254,255,303)
AND
tt1.term_taxonomy_id IN (180,186,188,189,321,322,323,324)
) AND bsj_posts.post_type = 'accommodation' AND ((bsj_posts.post_status = 'publish'))
GROUP BY bsj_posts.ID HAVING 1=1
ORDER BY bsj_posts.post_date DESC
LIMIT 24, 12
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Manage consent