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] => 20250123
)
[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] => 20250123
)
[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] => 20250123
)
[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] => 20250123
[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) >= '20250123' )
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] => d0d575945ed0c42406141980d4fa37f7
[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
Perfect stay: attendance note 1000. Helpful staff who wear the company shirt. The following employees stand out: Meiri, in the pool area. Lucia in the restaurant area. Marco, PR 1000, reflects the great atmosphere of Summerville.
Fernanda QExcellent 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 MWe were in Summerville and we loved our stay. All services met our expectations, the pools, the friendliness of the clerk, the accommodations and the food which, by the way, was always delicious. I emphasize the hospitality and promptness of the...
Diego Armando dWe were delighted with the whole structure of the resort, it offered to its customers, a large swimming pool, courts, game room, kids area, shows at night with live bands and the main thing, the friendliness of its employees always with a smile on...
AlanisbeltronVery 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.
DAVI SGreat Resort. Meeting security protocols for Covid, giving us peace of mind to enjoy our vacation. Helpful and very polite staff. Good structure and very well maintained. I recommend it!
FernandoVery nice trip, hotel with excellent service and structure, several pools and wet bar, beautiful landscape. Congratulations to Meire, Lucius and Zaccheus. Very attentive. Highly recommended and will be back soon. Thank you very much.
Celio F.Wonderful resort, I came with family and we all loved it, we had dinner at Quebramar, the tasting dinner was sensational, perfect room, 1000% service in all sectors, my daughter is 6 years old and was delighted with everything in the recreation all...
José de Anchieta