object(WP_Query)#2761 (49) { ["query"]=> array(7) { ["post_type"]=> string(6) "oferta" ["posts_per_page"]=> int(1) ["offset"]=> int(0) ["orderby"]=> string(10) "menu_order" ["order"]=> string(3) "ASC" ["post_status"]=> string(7) "publish" ["meta_query"]=> array(4) { ["relation"]=> string(3) "AND" [0]=> array(4) { ["key"]=> string(15) "fecha_de_inicio" ["value"]=> int(1474729200000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) "<=" } [1]=> array(4) { ["key"]=> string(16) "fecha_de_termino" ["value"]=> int(1474642800000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) ">=" } [2]=> array(4) { ["key"]=> string(16) "oferta_destacada" ["value"]=> int(1) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(1) "=" } } } ["query_vars"]=> array(67) { ["post_type"]=> string(6) "oferta" ["posts_per_page"]=> int(1) ["offset"]=> int(0) ["orderby"]=> string(10) "menu_order" ["order"]=> string(3) "ASC" ["post_status"]=> string(7) "publish" ["meta_query"]=> array(4) { ["relation"]=> string(3) "AND" [0]=> array(4) { ["key"]=> string(15) "fecha_de_inicio" ["value"]=> int(1474729200000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) "<=" } [1]=> array(4) { ["key"]=> string(16) "fecha_de_termino" ["value"]=> int(1474642800000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) ">=" } [2]=> array(4) { ["key"]=> string(16) "oferta_destacada" ["value"]=> int(1) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(1) "=" } } ["error"]=> string(0) "" ["m"]=> string(0) "" ["p"]=> int(0) ["post_parent"]=> string(0) "" ["subpost"]=> string(0) "" ["subpost_id"]=> string(0) "" ["attachment"]=> string(0) "" ["attachment_id"]=> int(0) ["name"]=> string(0) "" ["static"]=> string(0) "" ["pagename"]=> string(0) "" ["page_id"]=> int(0) ["second"]=> string(0) "" ["minute"]=> string(0) "" ["hour"]=> string(0) "" ["day"]=> int(0) ["monthnum"]=> int(0) ["year"]=> int(0) ["w"]=> int(0) ["category_name"]=> string(0) "" ["tag"]=> string(0) "" ["cat"]=> string(0) "" ["tag_id"]=> string(0) "" ["author"]=> string(0) "" ["author_name"]=> string(0) "" ["feed"]=> string(0) "" ["tb"]=> string(0) "" ["paged"]=> int(0) ["meta_key"]=> string(0) "" ["meta_value"]=> string(0) "" ["preview"]=> string(0) "" ["s"]=> string(0) "" ["sentence"]=> string(0) "" ["title"]=> string(0) "" ["fields"]=> string(0) "" ["menu_order"]=> string(0) "" ["embed"]=> string(0) "" ["category__in"]=> array(0) { } ["category__not_in"]=> array(0) { } ["category__and"]=> array(0) { } ["post__in"]=> array(0) { } ["post__not_in"]=> array(0) { } ["post_name__in"]=> array(0) { } ["tag__in"]=> array(0) { } ["tag__not_in"]=> array(0) { } ["tag__and"]=> array(0) { } ["tag_slug__in"]=> array(0) { } ["tag_slug__and"]=> array(0) { } ["post_parent__in"]=> array(0) { } ["post_parent__not_in"]=> array(0) { } ["author__in"]=> array(0) { } ["author__not_in"]=> array(0) { } ["ignore_sticky_posts"]=> bool(false) ["suppress_filters"]=> bool(false) ["cache_results"]=> bool(false) ["update_post_term_cache"]=> bool(true) ["update_post_meta_cache"]=> bool(true) ["nopaging"]=> bool(false) ["comments_per_page"]=> string(2) "50" ["no_found_rows"]=> bool(false) } ["tax_query"]=> object(WP_Tax_Query)#2800 (6) { ["queries"]=> array(0) { } ["relation"]=> string(3) "AND" ["table_aliases":protected]=> array(0) { } ["queried_terms"]=> array(0) { } ["primary_table"]=> string(13) "sisaweb_posts" ["primary_id_column"]=> string(2) "ID" } ["meta_query"]=> object(WP_Meta_Query)#2802 (9) { ["queries"]=> array(4) { [0]=> array(4) { ["key"]=> string(15) "fecha_de_inicio" ["value"]=> int(1474729200000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) "<=" } [1]=> array(4) { ["key"]=> string(16) "fecha_de_termino" ["value"]=> int(1474642800000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) ">=" } [2]=> array(4) { ["key"]=> string(16) "oferta_destacada" ["value"]=> int(1) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(1) "=" } ["relation"]=> string(3) "AND" } ["relation"]=> string(3) "AND" ["meta_table"]=> string(16) "sisaweb_postmeta" ["meta_id_column"]=> string(7) "post_id" ["primary_table"]=> string(13) "sisaweb_posts" ["primary_id_column"]=> string(2) "ID" ["table_aliases":protected]=> array(3) { [0]=> string(16) "sisaweb_postmeta" [1]=> string(3) "mt1" [2]=> string(3) "mt2" } ["clauses":protected]=> array(3) { ["sisaweb_postmeta"]=> array(6) { ["key"]=> string(15) "fecha_de_inicio" ["value"]=> int(1474729200000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) "<=" ["alias"]=> string(16) "sisaweb_postmeta" ["cast"]=> string(6) "SIGNED" } ["mt1"]=> array(6) { ["key"]=> string(16) "fecha_de_termino" ["value"]=> int(1474642800000) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(2) ">=" ["alias"]=> string(3) "mt1" ["cast"]=> string(6) "SIGNED" } ["mt2"]=> array(6) { ["key"]=> string(16) "oferta_destacada" ["value"]=> int(1) ["type"]=> string(7) "NUMERIC" ["compare"]=> string(1) "=" ["alias"]=> string(3) "mt2" ["cast"]=> string(6) "SIGNED" } } ["has_or_relation":protected]=> bool(false) } ["date_query"]=> bool(false) ["request"]=> string(781) "SELECT SQL_CALC_FOUND_ROWS sisaweb_posts.ID FROM sisaweb_posts INNER JOIN sisaweb_postmeta ON ( sisaweb_posts.ID = sisaweb_postmeta.post_id ) INNER JOIN sisaweb_postmeta AS mt1 ON ( sisaweb_posts.ID = mt1.post_id ) INNER JOIN sisaweb_postmeta AS mt2 ON ( sisaweb_posts.ID = mt2.post_id ) WHERE 1=1 AND ( ( sisaweb_postmeta.meta_key = 'fecha_de_inicio' AND CAST(sisaweb_postmeta.meta_value AS SIGNED) <= '1474729200000' ) AND ( mt1.meta_key = 'fecha_de_termino' AND CAST(mt1.meta_value AS SIGNED) >= '1474642800000' ) AND ( mt2.meta_key = 'oferta_destacada' AND CAST(mt2.meta_value AS SIGNED) = '1' ) ) AND sisaweb_posts.post_type = 'oferta' AND ((sisaweb_posts.post_status = 'publish')) GROUP BY sisaweb_posts.ID ORDER BY sisaweb_posts.menu_order ASC LIMIT 0, 1" ["posts"]=> array(1) { [0]=> object(WP_Post)#2787 (24) { ["ID"]=> int(9344) ["post_author"]=> string(2) "10" ["post_date"]=> string(19) "2016-09-22 15:35:59" ["post_date_gmt"]=> string(19) "2016-09-22 19:35:59" ["post_content"]=> string(0) "" ["post_title"]=> string(35) "Posta Negra o Rosada Cat. V, vacío" ["post_excerpt"]=> string(0) "" ["post_status"]=> string(7) "publish" ["comment_status"]=> string(6) "closed" ["ping_status"]=> string(6) "closed" ["post_password"]=> string(0) "" ["post_name"]=> string(34) "posta-negra-o-rosada-cat-v-vacio-2" ["to_ping"]=> string(0) "" ["pinged"]=> string(0) "" ["post_modified"]=> string(19) "2016-09-23 15:19:47" ["post_modified_gmt"]=> string(19) "2016-09-23 19:19:47" ["post_content_filtered"]=> string(0) "" ["post_parent"]=> int(0) ["guid"]=> string(55) "http://www.santaisabel.cl/?post_type=oferta&p=9344" ["menu_order"]=> int(10) ["post_type"]=> string(6) "oferta" ["post_mime_type"]=> string(0) "" ["comment_count"]=> string(1) "0" ["filter"]=> string(3) "raw" } } ["post_count"]=> int(1) ["current_post"]=> int(-1) ["in_the_loop"]=> bool(false) ["post"]=> object(WP_Post)#2787 (24) { ["ID"]=> int(9344) ["post_author"]=> string(2) "10" ["post_date"]=> string(19) "2016-09-22 15:35:59" ["post_date_gmt"]=> string(19) "2016-09-22 19:35:59" ["post_content"]=> string(0) "" ["post_title"]=> string(35) "Posta Negra o Rosada Cat. V, vacío" ["post_excerpt"]=> string(0) "" ["post_status"]=> string(7) "publish" ["comment_status"]=> string(6) "closed" ["ping_status"]=> string(6) "closed" ["post_password"]=> string(0) "" ["post_name"]=> string(34) "posta-negra-o-rosada-cat-v-vacio-2" ["to_ping"]=> string(0) "" ["pinged"]=> string(0) "" ["post_modified"]=> string(19) "2016-09-23 15:19:47" ["post_modified_gmt"]=> string(19) "2016-09-23 19:19:47" ["post_content_filtered"]=> string(0) "" ["post_parent"]=> int(0) ["guid"]=> string(55) "http://www.santaisabel.cl/?post_type=oferta&p=9344" ["menu_order"]=> int(10) ["post_type"]=> string(6) "oferta" ["post_mime_type"]=> string(0) "" ["comment_count"]=> string(1) "0" ["filter"]=> string(3) "raw" } ["comment_count"]=> int(0) ["current_comment"]=> int(-1) ["found_posts"]=> string(1) "5" ["max_num_pages"]=> float(5) ["max_num_comment_pages"]=> int(0) ["is_single"]=> bool(false) ["is_preview"]=> bool(false) ["is_page"]=> bool(false) ["is_archive"]=> bool(true) ["is_date"]=> bool(false) ["is_year"]=> bool(false) ["is_month"]=> bool(false) ["is_day"]=> bool(false) ["is_time"]=> bool(false) ["is_author"]=> bool(false) ["is_category"]=> bool(false) ["is_tag"]=> bool(false) ["is_tax"]=> bool(false) ["is_search"]=> bool(false) ["is_feed"]=> bool(false) ["is_comment_feed"]=> bool(false) ["is_trackback"]=> bool(false) ["is_home"]=> bool(false) ["is_404"]=> bool(false) ["is_embed"]=> bool(false) ["is_paged"]=> bool(false) ["is_admin"]=> bool(false) ["is_attachment"]=> bool(false) ["is_singular"]=> bool(false) ["is_robots"]=> bool(false) ["is_posts_page"]=> bool(false) ["is_post_type_archive"]=> bool(true) ["query_vars_hash":"WP_Query":private]=> string(32) "11f73bd6d2a54b8a82f49b48ab8fd514" ["query_vars_changed":"WP_Query":private]=> bool(false) ["thumbnails_cached"]=> bool(false) ["stopwords":"WP_Query":private]=> NULL ["compat_fields":"WP_Query":private]=> array(2) { [0]=> string(15) "query_vars_hash" [1]=> string(18) "query_vars_changed" } ["compat_methods":"WP_Query":private]=> array(2) { [0]=> string(16) "init_query_flags" [1]=> string(15) "parse_tax_query" } }
carne

$4.790 kg

Posta Negra o Rosada Cat. V, vacío

Oferta válida desde 23/9/2016 hasta 25/9/2016.

SISA_CallugaOferta_SantasOfertas
pollo

$2.590 c/u

$3.590 c/u
Otros medios de pago

Pollo asado Santa Isabel unidad

Oferta válida desde 24/9/2016 hasta 25/9/2016.

helados

30% Dcto.

Todos los helado Trendy y Panda

Oferta válida desde 24/9/2016 hasta 25/9/2016.

queso

$1.399 c/u

Queso Gauda Dos Alamos laminado 250 g

Oferta válida desde 24/9/2016 hasta 25/9/2016.

sol

$3.990 c/pack

Pack cerveza Sol botella 6 x 330 cc

Oferta válida desde 24/9/2016 hasta 25/9/2016.

noble

3x2

Papel Higiénico Noble 25 m + 4 m 4 unidades

Oferta válida desde 23/9/2016 hasta 25/9/2016.

bebe

50% Dcto. 2da unidad

Todo perfumería infantil

Oferta válida desde 23/9/2016 hasta 25/9/2016.

super-pollo

$999 c/u

Pechuga de pollo Super Pollo 250 g

Oferta válida desde 23/9/2016 hasta 25/9/2016.

aceite

$1.399 c/u

Aceite maravilla Miraflores 1 L

Oferta válida desde 23/9/2016 hasta 25/9/2016.

carne

$4.790 kg

Posta Negra o Rosada Cat. V, vacío

Oferta válida desde 23/9/2016 hasta 25/9/2016.

bebidas

$950 c/u

Crush, Ginger Ale, Limón Soda o Agua Tónica variedades 1,5 L

Oferta válida desde 23/9/2016 hasta 25/9/2016.

escudo

$2.490 c/pack

Pack cerveza Escudo lata 6 x 470 cc

Oferta válida desde 23/9/2016 hasta 25/9/2016.

arroz

$ 1.029 c/u

Arroz Tucapel Gº1 Gran Selección 1 kg

Oferta válida desde 23/9/2016 hasta 25/9/2016.

nestle-variedades

4x3

Todos los postres refrigerados Nestlé

Oferta válida desde 22/9/2016 hasta 25/9/2016.

colun-light-lt

$1.129 c/u

Leche cultivada Colun light variedades 1 L

Oferta válida desde 22/9/2016 hasta 25/9/2016.

leches-loncoleche

$749 c/u

Leche Lonco Leche sin lactosa entera, semidescremada o descremada 1L

Oferta válida desde 22/9/2016 hasta 25/9/2016.

colun-variedades

10x $1.400

Yoghurt batido Colun variedades 125 gr

Oferta válida desde 22/9/2016 hasta 25/9/2016.

soprole-uno

$ 1.199 c/pack

Pack bebida láctea Uno Soprole 6 unid. x 80 ml

Oferta válida desde 22/9/2016 hasta 25/9/2016.

soprole-griego

4x $879

Yoghurt Griego trozos Soprole variedades 110 g

Oferta válida desde 22/9/2016 hasta 25/9/2016.