WP_Query Object
(
[query] => Array
(
[post_type] => pacote
[posts_per_page] => 6
[lang] => es
[paged] => 1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => categorias_pacotes
[field] => slug
[terms] => especiales
)
)
[meta_query] => Array
(
[0] => Array
(
[key] => data_final
[compare] => >=
[type] => DATE
[value] => 20250120
)
[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] => es
[paged] => 1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => categorias_pacotes
[field] => slug
[terms] => especiales
)
)
[meta_query] => Array
(
[0] => Array
(
[key] => data_final
[compare] => >=
[type] => DATE
[value] => 20250120
)
[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] => especiales
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => categorias_pacotes
[terms] => Array
(
[0] => especiales
)
[field] => slug
[operator] => IN
[include_children] => 1
)
[1] => Array
(
[taxonomy] => language
[terms] => Array
(
[0] => es
)
[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] => especiales
)
[field] => slug
)
[language] => Array
(
[terms] => Array
(
[0] => es
)
[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] => 20250120
)
[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] => 20250120
[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 (377)
AND
tt1.term_taxonomy_id IN (77)
) AND (
( wp_postmeta.meta_key = 'data_final' AND CAST(wp_postmeta.meta_value AS DATE) >= '20250120' )
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] => 7ba0cf4b7ffeffe06446b818b3388898
[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
)
)
Ningún resultado encontrado.
VEA A CONTINUACIÓN
Algunas Opiniones
El resort es maravilloso pero lo que más llamó la atención fue la organización del personal y el excelente servicio de los funcionarios, con énfasis en el servicio de la playa de Muro Alto, que se encuentra a escasos metros, y donde el resort...
MelissaTotal infraestrutura para passaar las vacaciones con opciones para parejas, enamorados y toda la família. Exelentes dependências, profissionales muy colaborativos y atentos.Toda tranquilidad y recreacion sin necessitar salir del hotel com toda...
Valters271Fuimos del 17 al 28 de julio, con mucha lluvia y viento fuerte. Sin embargo ... fue una delicia. Empleados que hacen la experiencia aún mejor, así como el mesero Alexandro de la barra, es MUY atento y servicial, llama la atención por la calidad...
Amanda VEl Summerville es um exelente resort para qualquier tipo de diversion, la atencion es perfecta y la qualidad del servicio es inconparable. Viaje para muchos resorts y no creo que ningun se compare a el. La recreacion es única y anima a todos. Super...
Juliane OMuy buen resort, ubicación (frente al mar), piscina enorme, estructura completa incluso para niños. Gastronomía, limpieza, servicios, etc. todo de la máxima calidad. Destacar por la amabilidad y dedicación de los funcionarios en general,...
Razoavel1234Servicio muy Bueno. Alimentacion exelente. Mucha varieda y ofertas. Buen parque aquático. Playa tranquilla. Paisajismo muy bonito. Fuimos em pareja y esperamos volver com hijos y família. Felicitaciones a todos.
DAVI SEstuvimos en el Summerville en la fiesta del dia 15/11. Fuimos super bien atendidos, empleados atentos, em especial el Flavio y Denise del bar de la piscina, el gaúcho Marco, siempre muy solícito y el chef Anderson que preparo uma m oqueca y uma...
ChristianneTEl Resort es lindo con una piscina grande. El diferencial fureon los empleados, muy educados y atentos desde la recepcion has el equipo que limpia la piscina. La recreacion fue maravillosa con Todinho, a Miojo e los otros, muy responsables, nos...
Emilia G