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] => 20250401
)
[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] => 20250401
)
[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] => 20250401
)
[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] => 20250401
[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) >= '20250401' )
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] => fc3ce7b1690d42cb9a6089b22bf4d4a1
[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 QGreat accommodations. Excellent environment. Very helpful staff. A special highlight for Lili in the pool area. Her sympathy and joy infected everyone. We like everything very much and we plan to return for sure.
FelipeA4717Wonderful hotel in all aspects, cleanliness, polite staff, we loved everything and my family loved the recreation team. From the circus, always with a different activity for children and teenagers, the beach in front of the hotel is not very...
Livia DVery 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...
Razoavel1234Wonderful 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 AnchietaHotel is cozy, clean room with working air conditioning, good bathroom, great shower. Activities for children over 4 years old, for younger children you can hire a nanny (we didn't use this service). The restaurant is very good, with many options of...
P798JFclaudiafWe loved the Hotel, we were very well received and all the staff we had contact with were very kind and attentive, especially in the children's cafeteria where an employee, whosename I forget but who works from 3pm, was very helpful with the...
DsilveiraFThis 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....
TatyanaSaraiva