WordPress database error: [Not unique table/alias: 'tb']SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price
FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id
WHERE 1=1 AND ((wpsr_posts.post_type = 'st_tours' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_hotel')) AND tb.check_in >= 1780963200 AND tb.check_out <= 1781049600 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_tours')) AND
CASE
WHEN ISNULL(tb.max_people) THEN 1=1
WHEN tb.max_people = '' THEN 1=1
WHEN tb.max_people = '0' THEN 1=1
ELSE tb.max_people >= 1 END
GROUP BY wpsr_posts.ID
ORDER BY tb_st_tours.is_featured desc
LIMIT 0, 4
WordPress database error: [Not unique table/alias: 'tb']SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price
FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id INNER JOIN wpsr_st_activity as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_activity as tb_st_activity ON wpsr_posts.ID = tb_st_activity.post_id
WHERE 1=1 AND ((wpsr_posts.post_type = 'st_activity' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_hotel')) AND tb.check_in >= 1780963200 AND tb.check_out <= 1781049600 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_tours')) AND
CASE
WHEN ISNULL(tb.max_people) THEN 1=1
WHEN tb.max_people = '' THEN 1=1
WHEN tb.max_people = '0' THEN 1=1
ELSE tb.max_people >= 1 END
AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_activity'))
GROUP BY wpsr_posts.ID
ORDER BY tb_st_activity.is_featured desc
LIMIT 0, 4
WordPress database error: [Not unique table/alias: 'tb']SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price
FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id INNER JOIN wpsr_st_activity as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_activity as tb_st_activity ON wpsr_posts.ID = tb_st_activity.post_id INNER JOIN wpsr_st_cars as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON wpsr_posts.ID = tb_postmeta.post_id
WHERE 1=1 AND ((wpsr_posts.post_type = 'st_cars' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_hotel')) AND tb.check_in >= 1780963200 AND tb.check_out <= 1781049600 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_tours')) AND
CASE
WHEN ISNULL(tb.max_people) THEN 1=1
WHEN tb.max_people = '' THEN 1=1
WHEN tb.max_people = '0' THEN 1=1
ELSE tb.max_people >= 1 END
AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_activity')) AND tb_postmeta.meta_key = 'car_type' AND tb_postmeta.meta_value = 'normal'
GROUP BY wpsr_posts.ID
ORDER BY tb.is_featured desc
LIMIT 0, 4
WordPress database error: [Not unique table/alias: 'tb']SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price
FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id INNER JOIN wpsr_st_activity as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_activity as tb_st_activity ON wpsr_posts.ID = tb_st_activity.post_id INNER JOIN wpsr_st_cars as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON wpsr_posts.ID = tb_postmeta.post_id
WHERE 1=1 AND ((wpsr_posts.post_type = 'post' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_hotel')) AND tb.check_in >= 1780963200 AND tb.check_out <= 1781049600 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_tours')) AND
CASE
WHEN ISNULL(tb.max_people) THEN 1=1
WHEN tb.max_people = '' THEN 1=1
WHEN tb.max_people = '0' THEN 1=1
ELSE tb.max_people >= 1 END
AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14489') AND post_type IN ('st_activity')) AND tb_postmeta.meta_key = 'car_type' AND tb_postmeta.meta_value = 'normal'
GROUP BY wpsr_posts.ID
ORDER BY tb.is_featured desc
LIMIT 0, 8
Subscribe to see secret deals prices drop the moment you sign up!