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 's|camel|bali')
then 10 else 0 end) + (case when
(low' at line 11]
wp_posts.post_title as title,
wp_posts.ID as id,
wp_posts.post_date as date,
wp_posts.post_content as content,
wp_posts.post_excerpt as excerpt,
wp_users.user_nicename as author,
wp_posts.post_type as post_type,
GROUP_CONCAT(DISTINCT wp_terms.term_id) as terms,
(lower(wp_posts.post_title) REGEXP 'safari's|camel|bali')
then 10 else 0 end) + (case when
(lower(wp_posts.post_content) REGEXP 'the|and|safari|camel|with| |bali|nusa|tour|for')
then 8 else 0 end)) as relevance
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
LEFT JOIN wp_users ON wp_users.ID = wp_posts.post_author
LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
LEFT JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_id
(wp_posts.ID <> 1281) AND
(wp_posts.post_type REGEXP 'dummy_notting|post|page') AND
wp_posts.ID NOT IN (-99) AND
(wp_posts.post_status = 'publish') AND
((lower(wp_posts.post_title) REGEXP 'safari's|camel|bali') OR (lower(wp_posts.post_content) REGEXP 'safari's|camel|bali') OR (lower(wp_posts.post_excerpt) REGEXP 'safari's|camel|bali') OR (lower(wp_posts.post_content) REGEXP 'the|and|safari|camel|with| |bali|nusa|tour|for') OR (lower(wp_posts.post_title) REGEXP 'the|and|safari|camel|with| |bali|nusa|tour|for') OR (lower(wp_posts.post_excerpt) REGEXP 'the|and|safari|camel|with| |bali|nusa|tour|for'))
GROUP BY wp_posts.ID
ORDER BY relevance DESC, wp_posts.post_date DESC
• Bali is one of islands in Indonesia, which has more value than the other islands in Indonesia. There are varieties of culture, customs and traditions, friendly people, food and the beach with its white sands and also the nature with the weather which always fresh because the beauty and safety of Bali island. Many tourist domestic and foreigners come to Bali.
• Nusa Dua is one of beautiful places which is located in the in the south part of Bali. Nusa Dua is a name of the area which is not strange again for tourist domestic or foreigners. In this place many standard international hotels and tour facilities. For instance: Marine Sport, Turtle Island Tour, Dolphin Tour and Many Others.
• For that reasons we come to complete the tour attraction in Bali. We want to introduce camel tour in Nusa Dua Bali. We take action on, 18th of July 1996 in Tanjung Benoa, because there are many activities in the beach and for the safety of the guest. Next three years we move to the Nusa Dua Beach, certainly in the Nikko Bali Resort and Spa Beach with the Bali Camel consolation, you can ride a camel in the side part of the beach with its white sands of Nusa Dua and the nature around it with some of temples there.
• Before we take action, we have already trained our animal to adapt to people and the environment. And also we choose some of the professional tamers to guide you. All of the animals that we use are become accustomed to serve the guest from the different age. Don’t worry because our animals do not disturb you. To keep our quality, we always give the priority for the safety and the pleasure of the guest.
• With more experiences that ever we done, more than 7500 people have already served by us every years. Although we never find an accident in our place, we always give the insurance for every tourist who wants to enjoy our camel tour. “Enjoy the New Experience
Our Activity Packages:
1 hour Camel Safari with Lunch , Parasailling, Banana Boat, and Glass Bottom Boat & Turtle Island.
Adult : US $ 100
Child : US $ 90
1 hour Camel Safari
Adult : US $ 40
Child : US $ 25
1 hour Camel Safari with lunch or dinner.
Adult : US $ 75
Child : US $ 45
30 minutes Camel Safari
Adult : US $ 25
Child : US $ 20
4 person include return transfer.
2 person + US $ 10, kuta, seminyak, & sanur area
2 person + US $ 5, jimbaran & nusa dua
1 Hour Camel Safari with aroma therapy or balinese massage or balinese custom
Adult : US $ 70
Child : US $ 60
Camel Safari Photo Wedding
1 hour Camel Safari photo pre-wedding : US $ 120/Couple
30 minutes Camel Safari photo pre-wedding : US $ 70/Couple