WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurr...' at line 46]SELECT posts.*,
rules.*,
(t_rate.price_from*(100-COALESCE(pmd.discount, 0))*(100+COALESCE(tm2.meta_value, 0)*COALESCE(tm3.meta_value, 0)))/(100*100) AS discount_price_from,
pm.guests AS guests,
ctt.slug AS category_slug,
ctt.term_id AS category_id,
CAST(tm2.meta_value AS UNSIGNED) AS categories_add_taxes,
CAST(tm3.meta_value AS UNSIGNED) AS categories_tax,
CAST(pmr.meta_value AS DECIMAL(3,2)) AS rating,
items_number,
pmd.discount, pmd.discount_date_from, pmd.discount_date_to,
t_rate.rate_id, t_rate.rate_title, t_rate.date_from AS rate_date_from, t_rate.date_to AS rate_date_to, t_rate.apply_days, t_rate.start_days, t_rate.min_booking_period, t_rate.max_booking_period, t_rate.price_from, t_rate.price_general, t_rate.prices_conditional, t_rate.rate_order
FROM wp_posts posts
#every our post assigned to terms from booking categories and other taxonomies
INNER JOIN wp_term_relationships tr ON posts.ID = tr.object_id
#we need only our post type with categories
INNER JOIN wp_term_taxonomy ct ON ct.term_taxonomy_id = tr.term_taxonomy_id
AND ct.taxonomy = 'categories' AND ct.term_taxonomy_id IN (171)
#get category slug
INNER JOIN wp_terms ctt ON ctt.term_id = ct.term_id
#get max guests
INNER JOIN
(
SELECT CAST(meta_value AS DECIMAL) AS guests, post_id AS pm_post_id
FROM wp_postmeta
WHERE meta_key = 'guests'
) pm ON ( posts.ID = pm.pm_post_id AND pm.guests >= 1 )
#add categories_booking_rule meta
LEFT JOIN wp_termmeta tm ON tr.term_taxonomy_id = tm.term_id AND tm.meta_key = 'categories_booking_rule'
# get rule
LEFT JOIN wp_babe_booking_rules rules ON rules.rule_id = tm.meta_value
# get rates
INNER JOIN wp_babe_rates t_rate ON posts.ID = t_rate.booking_obj_id
AND ( t_rate.date_from <= '2026-04-03 23:59:59' OR t_rate.date_from IS NULL )
AND ( t_rate.date_to >= '2026-04-04 00:51:51' OR t_rate.date_to IS NULL ) AND ( ) AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.min_booking_period <= 0 )
AND ( t_rate.max_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.max_booking_period >= 0 )
#get items number
LEFT JOIN
(
SELECT GREATEST(CAST(COALESCE(meta_value, 1) AS DECIMAL), 1) AS items_number, post_id AS pmt_post_id, meta_key AS pmt_meta_key
FROM wp_postmeta
) pmt ON ( posts.ID = pmt.pmt_post_id AND pmt.pmt_meta_key = CONCAT('items_number_', ctt.slug) )
# get av cal
INNER JOIN
(
SELECT booking_obj_id AS obj_id, DATE_FORMAT(date_from, '%Y-%m-%d') AS cal_date, MIN(date_from) AS av_date_from, 0 as group_results_by_date
FROM wp_babe_av_cal
WHERE in_schedule=1 AND date_from >= '2026-04-04 00:51:51' AND date_from <= '2026-04-03 23:59:59'
GROUP BY booking_obj_id
ORDER BY date_from ASC
) av_cal ON av_cal.obj_id = posts.ID
LEFT JOIN
(
SELECT category_id AS category_id_to_exclude
FROM wp_babe_category_deactivate_schedule
WHERE deactivate_date_from <= '2026-04-04 00:51:51' AND deactivate_date_to >= '2026-04-03 23:59:59'
GROUP BY category_id
) cds ON cds.category_id_to_exclude = ctt.term_id
#add categories_add_taxes meta
LEFT JOIN wp_termmeta tm2 ON tr.term_taxonomy_id = tm2.term_id AND tm2.meta_key = 'categories_add_taxes'
#add categories_tax meta
LEFT JOIN wp_termmeta tm3 ON tr.term_taxonomy_id = tm3.term_id AND tm3.meta_key = 'categories_tax'
#get rating
LEFT JOIN wp_postmeta pmr ON posts.ID = pmr.post_id AND pmr.meta_key = '_rating'
#get discount
LEFT JOIN
(
SELECT discount, date_from AS discount_date_from, date_to AS discount_date_to, booking_obj_id AS discount_obj_id
FROM wp_babe_discount
WHERE date_from <= '2026-04-04 00:51:51' AND date_to >= '2026-04-04 00:51:51'
) pmd ON posts.ID = pmd.discount_obj_id
WHERE posts.post_type = 'to_book'
AND posts.post_status = 'publish'
AND (
(
rules.basic_booking_period = 'recurrent_custom'
OR rules.basic_booking_period = 'single_custom'
OR rules.basic_booking_period = 'night'
)
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from > '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
)
)
AND (
rules.basic_booking_period != 'night'
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from >= '2026-04-04 00:51:51'
AND date_from < '2026-04-03 00:00:00'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
) )
AND (
(
rules.basic_booking_period != 'recurrent_custom'
AND rules.basic_booking_period != 'single_custom'
)
OR EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND in_schedule=1
AND date_from >= '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND av_guests > 1
LIMIT 1
)
)
AND cds.category_id_to_exclude IS NULL GROUP BY posts.ID ORDER BY pmr.meta_value DESC, t_rate.booking_obj_id ASC, t_rate.rate_order ASC, t_rate.price_from ASC, t_rate.date_from DESC, t_rate.date_to DESC
LIMIT 0, 12
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurr...' at line 46]SELECT COUNT(discount_price_from) AS total_count FROM (SELECT posts.*,
rules.*,
(t_rate.price_from*(100-COALESCE(pmd.discount, 0))*(100+COALESCE(tm2.meta_value, 0)*COALESCE(tm3.meta_value, 0)))/(100*100) AS discount_price_from,
pm.guests AS guests,
ctt.slug AS category_slug,
ctt.term_id AS category_id,
CAST(tm2.meta_value AS UNSIGNED) AS categories_add_taxes,
CAST(tm3.meta_value AS UNSIGNED) AS categories_tax,
CAST(pmr.meta_value AS DECIMAL(3,2)) AS rating,
items_number,
pmd.discount, pmd.discount_date_from, pmd.discount_date_to,
t_rate.rate_id, t_rate.rate_title, t_rate.date_from AS rate_date_from, t_rate.date_to AS rate_date_to, t_rate.apply_days, t_rate.start_days, t_rate.min_booking_period, t_rate.max_booking_period, t_rate.price_from, t_rate.price_general, t_rate.prices_conditional, t_rate.rate_order
FROM wp_posts posts
#every our post assigned to terms from booking categories and other taxonomies
INNER JOIN wp_term_relationships tr ON posts.ID = tr.object_id
#we need only our post type with categories
INNER JOIN wp_term_taxonomy ct ON ct.term_taxonomy_id = tr.term_taxonomy_id
AND ct.taxonomy = 'categories' AND ct.term_taxonomy_id IN (171)
#get category slug
INNER JOIN wp_terms ctt ON ctt.term_id = ct.term_id
#get max guests
INNER JOIN
(
SELECT CAST(meta_value AS DECIMAL) AS guests, post_id AS pm_post_id
FROM wp_postmeta
WHERE meta_key = 'guests'
) pm ON ( posts.ID = pm.pm_post_id AND pm.guests >= 1 )
#add categories_booking_rule meta
LEFT JOIN wp_termmeta tm ON tr.term_taxonomy_id = tm.term_id AND tm.meta_key = 'categories_booking_rule'
# get rule
LEFT JOIN wp_babe_booking_rules rules ON rules.rule_id = tm.meta_value
# get rates
INNER JOIN wp_babe_rates t_rate ON posts.ID = t_rate.booking_obj_id
AND ( t_rate.date_from <= '2026-04-03 23:59:59' OR t_rate.date_from IS NULL )
AND ( t_rate.date_to >= '2026-04-04 00:51:51' OR t_rate.date_to IS NULL ) AND ( ) AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.min_booking_period <= 0 )
AND ( t_rate.max_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.max_booking_period >= 0 )
#get items number
LEFT JOIN
(
SELECT GREATEST(CAST(COALESCE(meta_value, 1) AS DECIMAL), 1) AS items_number, post_id AS pmt_post_id, meta_key AS pmt_meta_key
FROM wp_postmeta
) pmt ON ( posts.ID = pmt.pmt_post_id AND pmt.pmt_meta_key = CONCAT('items_number_', ctt.slug) )
# get av cal
INNER JOIN
(
SELECT booking_obj_id AS obj_id, DATE_FORMAT(date_from, '%Y-%m-%d') AS cal_date, MIN(date_from) AS av_date_from, 0 as group_results_by_date
FROM wp_babe_av_cal
WHERE in_schedule=1 AND date_from >= '2026-04-04 00:51:51' AND date_from <= '2026-04-03 23:59:59'
GROUP BY booking_obj_id
ORDER BY date_from ASC
) av_cal ON av_cal.obj_id = posts.ID
LEFT JOIN
(
SELECT category_id AS category_id_to_exclude
FROM wp_babe_category_deactivate_schedule
WHERE deactivate_date_from <= '2026-04-04 00:51:51' AND deactivate_date_to >= '2026-04-03 23:59:59'
GROUP BY category_id
) cds ON cds.category_id_to_exclude = ctt.term_id
#add categories_add_taxes meta
LEFT JOIN wp_termmeta tm2 ON tr.term_taxonomy_id = tm2.term_id AND tm2.meta_key = 'categories_add_taxes'
#add categories_tax meta
LEFT JOIN wp_termmeta tm3 ON tr.term_taxonomy_id = tm3.term_id AND tm3.meta_key = 'categories_tax'
#get rating
LEFT JOIN wp_postmeta pmr ON posts.ID = pmr.post_id AND pmr.meta_key = '_rating'
#get discount
LEFT JOIN
(
SELECT discount, date_from AS discount_date_from, date_to AS discount_date_to, booking_obj_id AS discount_obj_id
FROM wp_babe_discount
WHERE date_from <= '2026-04-04 00:51:51' AND date_to >= '2026-04-04 00:51:51'
) pmd ON posts.ID = pmd.discount_obj_id
WHERE posts.post_type = 'to_book'
AND posts.post_status = 'publish'
AND (
(
rules.basic_booking_period = 'recurrent_custom'
OR rules.basic_booking_period = 'single_custom'
OR rules.basic_booking_period = 'night'
)
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from > '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
)
)
AND (
rules.basic_booking_period != 'night'
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from >= '2026-04-04 00:51:51'
AND date_from < '2026-04-03 00:00:00'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
) )
AND (
(
rules.basic_booking_period != 'recurrent_custom'
AND rules.basic_booking_period != 'single_custom'
)
OR EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND in_schedule=1
AND date_from >= '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND av_guests > 1
LIMIT 1
)
)
AND cds.category_id_to_exclude IS NULL GROUP BY posts.ID) AS a
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurr...' at line 46]SELECT posts.*,
rules.*,
(t_rate.price_from*(100-COALESCE(pmd.discount, 0))*(100+COALESCE(tm2.meta_value, 0)*COALESCE(tm3.meta_value, 0)))/(100*100) AS discount_price_from,
pm.guests AS guests,
ctt.slug AS category_slug,
ctt.term_id AS category_id,
CAST(tm2.meta_value AS UNSIGNED) AS categories_add_taxes,
CAST(tm3.meta_value AS UNSIGNED) AS categories_tax,
CAST(pmr.meta_value AS DECIMAL(3,2)) AS rating,
items_number,
pmd.discount, pmd.discount_date_from, pmd.discount_date_to,
t_rate.rate_id, t_rate.rate_title, t_rate.date_from AS rate_date_from, t_rate.date_to AS rate_date_to, t_rate.apply_days, t_rate.start_days, t_rate.min_booking_period, t_rate.max_booking_period, t_rate.price_from, t_rate.price_general, t_rate.prices_conditional, t_rate.rate_order
FROM wp_posts posts
#every our post assigned to terms from booking categories and other taxonomies
INNER JOIN wp_term_relationships tr ON posts.ID = tr.object_id
#we need only our post type with categories
INNER JOIN wp_term_taxonomy ct ON ct.term_taxonomy_id = tr.term_taxonomy_id
AND ct.taxonomy = 'categories' AND ct.term_taxonomy_id IN (171)
#get category slug
INNER JOIN wp_terms ctt ON ctt.term_id = ct.term_id
#get max guests
INNER JOIN
(
SELECT CAST(meta_value AS DECIMAL) AS guests, post_id AS pm_post_id
FROM wp_postmeta
WHERE meta_key = 'guests'
) pm ON ( posts.ID = pm.pm_post_id AND pm.guests >= 1 )
#add categories_booking_rule meta
LEFT JOIN wp_termmeta tm ON tr.term_taxonomy_id = tm.term_id AND tm.meta_key = 'categories_booking_rule'
# get rule
LEFT JOIN wp_babe_booking_rules rules ON rules.rule_id = tm.meta_value
# get rates
INNER JOIN wp_babe_rates t_rate ON posts.ID = t_rate.booking_obj_id
AND ( t_rate.date_from <= '2026-04-03 23:59:59' OR t_rate.date_from IS NULL )
AND ( t_rate.date_to >= '2026-04-04 00:51:51' OR t_rate.date_to IS NULL ) AND ( ) AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.min_booking_period <= 0 )
AND ( t_rate.max_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.max_booking_period >= 0 )
#get items number
LEFT JOIN
(
SELECT GREATEST(CAST(COALESCE(meta_value, 1) AS DECIMAL), 1) AS items_number, post_id AS pmt_post_id, meta_key AS pmt_meta_key
FROM wp_postmeta
) pmt ON ( posts.ID = pmt.pmt_post_id AND pmt.pmt_meta_key = CONCAT('items_number_', ctt.slug) )
# get av cal
INNER JOIN
(
SELECT booking_obj_id AS obj_id, DATE_FORMAT(date_from, '%Y-%m-%d') AS cal_date, MIN(date_from) AS av_date_from, 0 as group_results_by_date
FROM wp_babe_av_cal
WHERE in_schedule=1 AND date_from >= '2026-04-04 00:51:51' AND date_from <= '2026-04-03 23:59:59'
GROUP BY booking_obj_id
ORDER BY date_from ASC
) av_cal ON av_cal.obj_id = posts.ID
LEFT JOIN
(
SELECT category_id AS category_id_to_exclude
FROM wp_babe_category_deactivate_schedule
WHERE deactivate_date_from <= '2026-04-04 00:51:51' AND deactivate_date_to >= '2026-04-03 23:59:59'
GROUP BY category_id
) cds ON cds.category_id_to_exclude = ctt.term_id
#add categories_add_taxes meta
LEFT JOIN wp_termmeta tm2 ON tr.term_taxonomy_id = tm2.term_id AND tm2.meta_key = 'categories_add_taxes'
#add categories_tax meta
LEFT JOIN wp_termmeta tm3 ON tr.term_taxonomy_id = tm3.term_id AND tm3.meta_key = 'categories_tax'
#get rating
LEFT JOIN wp_postmeta pmr ON posts.ID = pmr.post_id AND pmr.meta_key = '_rating'
#get discount
LEFT JOIN
(
SELECT discount, date_from AS discount_date_from, date_to AS discount_date_to, booking_obj_id AS discount_obj_id
FROM wp_babe_discount
WHERE date_from <= '2026-04-04 00:51:51' AND date_to >= '2026-04-04 00:51:51'
) pmd ON posts.ID = pmd.discount_obj_id
WHERE posts.post_type = 'to_book'
AND posts.post_status = 'publish'
AND (
(
rules.basic_booking_period = 'recurrent_custom'
OR rules.basic_booking_period = 'single_custom'
OR rules.basic_booking_period = 'night'
)
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from > '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
)
)
AND (
rules.basic_booking_period != 'night'
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from >= '2026-04-04 00:51:51'
AND date_from < '2026-04-03 00:00:00'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
) )
AND (
(
rules.basic_booking_period != 'recurrent_custom'
AND rules.basic_booking_period != 'single_custom'
)
OR EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND in_schedule=1
AND date_from >= '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND av_guests > 1
LIMIT 1
)
)
AND cds.category_id_to_exclude IS NULL GROUP BY posts.ID ORDER BY pmr.meta_value DESC, t_rate.booking_obj_id ASC, t_rate.rate_order ASC, t_rate.price_from ASC, t_rate.date_from DESC, t_rate.date_to DESC
LIMIT 0, 12
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurr...' at line 46]SELECT COUNT(discount_price_from) AS total_count FROM (SELECT posts.*,
rules.*,
(t_rate.price_from*(100-COALESCE(pmd.discount, 0))*(100+COALESCE(tm2.meta_value, 0)*COALESCE(tm3.meta_value, 0)))/(100*100) AS discount_price_from,
pm.guests AS guests,
ctt.slug AS category_slug,
ctt.term_id AS category_id,
CAST(tm2.meta_value AS UNSIGNED) AS categories_add_taxes,
CAST(tm3.meta_value AS UNSIGNED) AS categories_tax,
CAST(pmr.meta_value AS DECIMAL(3,2)) AS rating,
items_number,
pmd.discount, pmd.discount_date_from, pmd.discount_date_to,
t_rate.rate_id, t_rate.rate_title, t_rate.date_from AS rate_date_from, t_rate.date_to AS rate_date_to, t_rate.apply_days, t_rate.start_days, t_rate.min_booking_period, t_rate.max_booking_period, t_rate.price_from, t_rate.price_general, t_rate.prices_conditional, t_rate.rate_order
FROM wp_posts posts
#every our post assigned to terms from booking categories and other taxonomies
INNER JOIN wp_term_relationships tr ON posts.ID = tr.object_id
#we need only our post type with categories
INNER JOIN wp_term_taxonomy ct ON ct.term_taxonomy_id = tr.term_taxonomy_id
AND ct.taxonomy = 'categories' AND ct.term_taxonomy_id IN (171)
#get category slug
INNER JOIN wp_terms ctt ON ctt.term_id = ct.term_id
#get max guests
INNER JOIN
(
SELECT CAST(meta_value AS DECIMAL) AS guests, post_id AS pm_post_id
FROM wp_postmeta
WHERE meta_key = 'guests'
) pm ON ( posts.ID = pm.pm_post_id AND pm.guests >= 1 )
#add categories_booking_rule meta
LEFT JOIN wp_termmeta tm ON tr.term_taxonomy_id = tm.term_id AND tm.meta_key = 'categories_booking_rule'
# get rule
LEFT JOIN wp_babe_booking_rules rules ON rules.rule_id = tm.meta_value
# get rates
INNER JOIN wp_babe_rates t_rate ON posts.ID = t_rate.booking_obj_id
AND ( t_rate.date_from <= '2026-04-03 23:59:59' OR t_rate.date_from IS NULL )
AND ( t_rate.date_to >= '2026-04-04 00:51:51' OR t_rate.date_to IS NULL ) AND ( ) AND ( t_rate.min_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.min_booking_period <= 0 )
AND ( t_rate.max_booking_period = 0 OR rules.basic_booking_period = 'recurrent_custom' OR rules.basic_booking_period = 'hour' OR t_rate.max_booking_period >= 0 )
#get items number
LEFT JOIN
(
SELECT GREATEST(CAST(COALESCE(meta_value, 1) AS DECIMAL), 1) AS items_number, post_id AS pmt_post_id, meta_key AS pmt_meta_key
FROM wp_postmeta
) pmt ON ( posts.ID = pmt.pmt_post_id AND pmt.pmt_meta_key = CONCAT('items_number_', ctt.slug) )
# get av cal
INNER JOIN
(
SELECT booking_obj_id AS obj_id, DATE_FORMAT(date_from, '%Y-%m-%d') AS cal_date, MIN(date_from) AS av_date_from, 0 as group_results_by_date
FROM wp_babe_av_cal
WHERE in_schedule=1 AND date_from >= '2026-04-04 00:51:51' AND date_from <= '2026-04-03 23:59:59'
GROUP BY booking_obj_id
ORDER BY date_from ASC
) av_cal ON av_cal.obj_id = posts.ID
LEFT JOIN
(
SELECT category_id AS category_id_to_exclude
FROM wp_babe_category_deactivate_schedule
WHERE deactivate_date_from <= '2026-04-04 00:51:51' AND deactivate_date_to >= '2026-04-03 23:59:59'
GROUP BY category_id
) cds ON cds.category_id_to_exclude = ctt.term_id
#add categories_add_taxes meta
LEFT JOIN wp_termmeta tm2 ON tr.term_taxonomy_id = tm2.term_id AND tm2.meta_key = 'categories_add_taxes'
#add categories_tax meta
LEFT JOIN wp_termmeta tm3 ON tr.term_taxonomy_id = tm3.term_id AND tm3.meta_key = 'categories_tax'
#get rating
LEFT JOIN wp_postmeta pmr ON posts.ID = pmr.post_id AND pmr.meta_key = '_rating'
#get discount
LEFT JOIN
(
SELECT discount, date_from AS discount_date_from, date_to AS discount_date_to, booking_obj_id AS discount_obj_id
FROM wp_babe_discount
WHERE date_from <= '2026-04-04 00:51:51' AND date_to >= '2026-04-04 00:51:51'
) pmd ON posts.ID = pmd.discount_obj_id
WHERE posts.post_type = 'to_book'
AND posts.post_status = 'publish'
AND (
(
rules.basic_booking_period = 'recurrent_custom'
OR rules.basic_booking_period = 'single_custom'
OR rules.basic_booking_period = 'night'
)
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from > '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
)
)
AND (
rules.basic_booking_period != 'night'
OR NOT EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND date_from >= '2026-04-04 00:51:51'
AND date_from < '2026-04-03 00:00:00'
AND (
in_schedule=0
OR av_guests < 1
)
LIMIT 1
) )
AND (
(
rules.basic_booking_period != 'recurrent_custom'
AND rules.basic_booking_period != 'single_custom'
)
OR EXISTS (
SELECT booking_obj_id
FROM wp_babe_av_cal
WHERE booking_obj_id = posts.ID
AND in_schedule=1
AND date_from >= '2026-04-04 00:51:51'
AND date_from <= '2026-04-03 23:59:59'
AND av_guests > 1
LIMIT 1
)
)
AND cds.category_id_to_exclude IS NULL GROUP BY posts.ID) AS a
Why travel with us....
Extended Customization
Hand-tailor your tour until it fits your need.
Customer Satisfaction
We deliver beyond your expectation.
Memorable Experiences
Browse and book tours and activities so incredible.
Ultimate flexibility
You’re in control, with free cancellation and payment options.
Latest Travel Guides
Why Kenya Should Be Your Next Safari Destination An African safari isn’t just a trip—it’s a life-changing experience. Imagine watching a lioness guide her cubs through golden grasslands or witnessing elephants roam against the backdrop of Mount Kilimanjaro in Amboseli. Kenya delivers these moments effortlessly, thanks to its world-renowned parks like the Maasai Mara and […]
Discover the ultimate African adventure with Kenya’s leading safari experts Kenya is globally celebrated for its spectacular wildlife, diverse ecosystems, and unforgettable safari experiences. From the iconic Maasai Mara to the misty views of Mount Kilimanjaro in Amboseli, this East African jewel offers once-in-a-lifetime journeys for nature lovers and adventure seekers alike. However, with countless […]
What Our Travelers Say
About the Trip
Our Partners
