WP_Query Object
(
[query] => Array
(
[post_type] => pacote
[posts_per_page] => 6
[lang] => en
[paged] => 1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => categorias_pacotes
[field] => slug
[terms] => specials
)
)
[meta_query] => Array
(
[0] => Array
(
[key] => data_final
[compare] => >=
[type] => DATE
[value] => 20241222
)
[1] => Array
(
[relation] => OR
[0] => Array
(
[key] => exibicao_do_pacote
[value] => ambos
[compare] => =
)
[1] => Array
(
[key] => exibicao_do_pacote
[value] => desktop
[compare] => =
)
)
)
)
[query_vars] => Array
(
[post_type] => pacote
[posts_per_page] => 6
[lang] => en
[paged] => 1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => categorias_pacotes
[field] => slug
[terms] => specials
)
)
[meta_query] => Array
(
[0] => Array
(
[key] => data_final
[compare] => >=
[type] => DATE
[value] => 20241222
)
[1] => Array
(
[relation] => OR
[0] => Array
(
[key] => exibicao_do_pacote
[value] => ambos
[compare] => =
)
[1] => Array
(
[key] => exibicao_do_pacote
[value] => desktop
[compare] => =
)
)
)
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[search_columns] => Array
(
)
[orderby] => menu_order
[order] => ASC
[update_post_term_cache] => 1
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => categorias_pacotes
[term] => specials
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => categorias_pacotes
[terms] => Array
(
[0] => specials
)
[field] => slug
[operator] => IN
[include_children] => 1
)
[1] => Array
(
[taxonomy] => language
[terms] => Array
(
[0] => en
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
[1] => tt1
)
[queried_terms] => Array
(
[categorias_pacotes] => Array
(
[terms] => Array
(
[0] => specials
)
[field] => slug
)
[language] => Array
(
[terms] => Array
(
[0] => en
)
[field] => slug
)
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => data_final
[compare] => >=
[type] => DATE
[value] => 20241222
)
[1] => Array
(
[0] => Array
(
[key] => exibicao_do_pacote
[value] => ambos
[compare] => =
)
[1] => Array
(
[key] => exibicao_do_pacote
[value] => desktop
[compare] => =
)
[relation] => OR
)
[relation] => AND
)
[relation] => AND
[meta_table] => wp_postmeta
[meta_id_column] => post_id
[primary_table] => wp_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wp_postmeta
[1] => mt1
)
[clauses:protected] => Array
(
[wp_postmeta] => Array
(
[key] => data_final
[compare] => >=
[type] => DATE
[value] => 20241222
[compare_key] => =
[alias] => wp_postmeta
[cast] => DATE
)
[mt1] => Array
(
[key] => exibicao_do_pacote
[value] => ambos
[compare] => =
[compare_key] => =
[alias] => mt1
[cast] => CHAR
)
[mt1-1] => Array
(
[key] => exibicao_do_pacote
[value] => desktop
[compare] => =
[compare_key] => =
[alias] => mt1
[cast] => CHAR
)
)
[has_or_relation:protected] => 1
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (379)
AND
tt1.term_taxonomy_id IN (80)
) AND (
( wp_postmeta.meta_key = 'data_final' AND CAST(wp_postmeta.meta_value AS DATE) >= '20241222' )
AND
(
( mt1.meta_key = 'exibicao_do_pacote' AND mt1.meta_value = 'ambos' )
OR
( mt1.meta_key = 'exibicao_do_pacote' AND mt1.meta_value = 'desktop' )
)
) AND ((wp_posts.post_type = 'pacote' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY wp_posts.menu_order ASC
LIMIT 0, 6
[posts] => Array
(
)
[post_count] => 0
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[comment_count] => 0
[current_comment] => -1
[found_posts] => 0
[max_num_pages] => 0
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] => 1
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => 9f1fcf281277cda0136b0fc9c420fba7
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
No results found.
See below for
Some Testimonials
The structure of the Hotel, food and children's recreation are excellent. The service of the staff is a feature of the Hotel. Staff are very cordial and were nice to us. My 4 year old daughter, like every child at this age has difficulty eating...
Savioli_AndersonI really enjoyed the animation and the shows. The animators I liked the most were Uncle Lollipop, Aunt Pompom and Uncle Long Leg, I liked the acrobats a lot too (but I don't remember their names). That was my assessment.
Kenzo JVery good hotel, the staff are very attentive making themselves available to help. My room was completely ready, even with a cot for my daughter; I did not even have to ask for anything. Great entertainment team for the kids and a pool...
Sabra05This is the second time we stayed at Summerville. The first time we were at the resort (in 2015), my daughter was 3 and came back crying home because she did not want to leave. Ha Ha. This year, in November 2018, we came back to stay at Summerville....
TatyanaSaraivaVery good service. Excellent food. Lots of variety and offer. Good Water Park. Quiet beach. Very beautiful landscaping. We went as a couple and hope to return with kids and family. Congratulations to all of you.
Excellent structure, great service and very attentive, friendly and helpful staff. The beach is fantastic: beautiful, calm sea with natural pools and warm water of the Northeast. The food is very good but not a place for lovers of fine food. The...
Diana MResort with excellence in quality. All wonderful. Incredible gastronomy. Staff super helpful. It even has Space Chandon and nautical support. Get to know the massage combos they offer. Optimum cost x benefit.
fabriciusmilagresVery good resort, location (facing the sea), huge pool, complete structure including for children. Gastronomy, cleaning, services, etc. all of the highest quality. Emphasis on the friendliness and dedication of employees in general, dedicated to...
Razoavel1234