WordPress database error: [Unknown column 'wp_posts.post_type' in 'WHERE']SELECT COUNT(*)
FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID
WHERE ( comment_approved = '1' ) AND comment_post_ID = 2379 AND comment_type NOT IN ('note') AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND comment_type != 'action_log' AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND wp_posts.post_type NOT IN ('st_hotel','st_cars','st_rental','st_activity','hotel_room','rental_room')
WordPress database error: [Unknown column 'wp_posts.post_type' in 'WHERE']SELECT COUNT(*)
FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID
WHERE ( comment_approved = '0' ) AND comment_post_ID = 2379 AND comment_type NOT IN ('note') AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND comment_type != 'action_log' AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND wp_posts.post_type NOT IN ('st_hotel','st_cars','st_rental','st_activity','hotel_room','rental_room')
WordPress database error: [Unknown column 'wp_posts.post_type' in 'WHERE']SELECT COUNT(*)
FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID
WHERE ( comment_approved = 'spam' ) AND comment_post_ID = 2379 AND comment_type NOT IN ('note') AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND comment_type != 'action_log' AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND wp_posts.post_type NOT IN ('st_hotel','st_cars','st_rental','st_activity','hotel_room','rental_room')
WordPress database error: [Unknown column 'wp_posts.post_type' in 'WHERE']SELECT COUNT(*)
FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID
WHERE ( comment_approved = 'trash' ) AND comment_post_ID = 2379 AND comment_type NOT IN ('note') AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND comment_type != 'action_log' AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND wp_posts.post_type NOT IN ('st_hotel','st_cars','st_rental','st_activity','hotel_room','rental_room')
WordPress database error: [Unknown column 'wp_posts.post_type' in 'WHERE']SELECT COUNT(*)
FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID
WHERE ( comment_approved = 'post-trashed' ) AND comment_post_ID = 2379 AND comment_type NOT IN ('note') AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND comment_type != 'action_log' AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND wp_posts.post_type NOT IN ('st_hotel','st_cars','st_rental','st_activity','hotel_room','rental_room')
Ideal for certified divers who want to explore Cozumel’s most spectacular reefs in just one day. The experience begins on a speedboat heading to the dive sites within the Cozumel Reefs Marine Park, renowned for its biodiversity and crystal-clear waters.
During the tour, you will do two dives guided by a local instructor, where you can admire corals, tropical fish, and the marine life typical of the Caribbean.
Each guide accompanies a small group of divers to ensure safety, comfort, and personalized attention, making this experience an unforgettable adventure.
Daily departures: 9:00 AM or 2:00 PM. Minimum of 2 people required for the tour.
4-5 hours
Daily experience
1 guide per 4 divers
Spanish, english
Member Since 2024
English
