Notice (8): Undefined index:  DealTemplate [APP/controllers/deals_controller.php, line 586]
Paga desde $67.000 por 2, 3 o 5 noches para dos + desayuno buffet + acceso a piscina cubierta en Hotel Borde Lago, Puerto Varas - Groupon · Groupon

    Condiciones

    Estas condiciones aplican a todos los Groupones, a menos que en la publicación se especifique lo contrario.
  • - No incluye propina.
  • - No válido para mayoristas.
  • - No acumulable con otras promociones.
  • - Prohibida la venta de bebidas alcohólicas a menores de 18 años.
  • - Se requiere llevar el Groupon impreso.
  • - Reservas sujetas a disponibilidad.
  • - Cita agendada y no asistida se tomará como servicio efectuado.
  • - Menores de edad deben asistir acompañados por un adulto.
  • - Puedes regalar todos los Groupones que quieras.
       Condiciones que aplican para Groupones que incluyen estadía en hotel, a menos que en la publicación se especifique lo contrario:
  • - No acumulable con otras promociones.
  • - No aplica después de la fecha de vencimiento.
  • - Reservas sujetas a disponibilidad y políticas de promoción.
  • - Se requiere llevar el Groupon impreso.
  • - El Groupon será validado al momento de hacer la reserva, en caso de no concurrir en la fecha establecida, la misma no se podrá recuperar.
  • - Solo para personas naturales. No válido para agencias de viaje.
  • - No incluye propina.
  • - Menores de edad deben asistir acompañados por un adulto.
  • - No se aceptan cambios de productos o servicios incluídos en la oferta
  • - Prohibida la venta de bebidas alcohólicas a menores de 18 años.
  • - Puedes regalar todos los Groupones que quieras.

Paga desde $67.000 por 2, 3 o 5 noches para dos + desayuno buffet + acceso a piscina cubierta en Hotel Borde Lago, Puerto Varas

Desde:
$67.000
 
Referencia
$134.000
Beneficio
50%
Ahorras
$67.000
Este Groupon caducó el:
10 de Julio de 2012
Chile es Tuyo
  • Paga desde $67.000 por 2, 3 o 5 noches para dos + desayuno buffet + acceso a piscina cubierta en Hotel Borde Lago, Puerto Varas

Destacados

Estadía en Hotel Borde Lago, ubicado a orillas del lago Llanquihue y a solo minutos de lugares como los Saltos del Petrohué y Laguna Verde. Alojamiento en habitación doble con cama matrimonial o 2 twins que cuenta con sistema de calefacción central. Incluye acceso a la piscina cubierta y estacionamiento.
  • Haz click aquí para ver detalles del viaje

Letra chica

Beneficio extra: 30% off sobre la tarifa rack por noche adicional y sobre el valor de la carta en el restaurante del hotel. Reservas al tel. (65) 438 999 y al e-mail: contacto@bordelago.com, enviando nombre, teléfono, fecha de llegada y salida, hora de check in, tipo de habitación y código Groupon. Horario de reservas: lun a vie de 09:00 a 18:30. Cancelaciones con al menos 48 horas de anticipación. Se permite un niño menor a 3 años compartiendo cama con sus padres. Un Groupon por pareja y por visita.
El Groupon se puede utilizar desde el 27 de Junio de 2012 hasta el 30 de Septiembre de 2012

Para quienes buscan la oportunidad de pasar el otoño en medio de los hermosos y fríos paisajes sureños, este Groupon entrega una chance para concretar la idea, pagando desde $67.000 por una estadía para dos con desayuno en Hotel Borde Lago, más trago de bienvenida, uso de piscina y 30% de descuento en la carta de su restaurante y en noche adicional. Elige entre las siguientes opciones:

  • $67.000 en vez de $134.000 por estadía de 2 noches
  • $89.550 en vez de $199.000 por estadía de 3 noches
  • $131.600 en vez de $329.000 por estadía de 5 noches



Ubicado a orillas del lago Llanquihue, en el km 4 del Camino Ensenada, este hotel inserto en la naturaleza, tiene la ventaja de estar situado cerca lugares como los Saltos del Petrohué, Laguna Verde, Lago Todos los Santos y Ensenada. Así una vez llegados, los pasajeros podrán brindar con un trago de bienvenida, para pasar a conocer la habitación que los aguarda para descansar durante su estadía con vista al lago y los volcanes de la región. Además, el dormitorio, se encontrará decorado con maderas nobles y exclusivos tapices, a lo que se suma la doble cama matrimonial o 2 twin, calefacción central, baño privado y televisión. Por otro lado, al amanecer, están contemplados los desayunos de estilo buffet, durante toda la estadía. Para relajarse y recuperar las energías, los pasajeros tendrán la opción de chapotear en la piscina cubierta o entretenerse jugando en el circuito de minigolf. El horario de check in es a las 15:00 y el de check out a las 11:30.

Instalaciones y servicios: 

  • El hotel cuenta con 52 habitaciones,
  • piscina cubierta,
  • estacionamiento,
  • desayuno buffet,
  • minigolf.


Otros con cargo adicional:

  • Camas adicionales,
  • traslados desde  y hacia el aeropuerto,
  • spa,
  • excursiones,
  • restaurante Flores y Leñero.


¿Buscas una referencia?

Las encontraste. A continuación te dejamos algunas opiniones de huéspedes, recabadas desde Hoteles.com

El lugar es hermoso, limpio, la decoración es muy linda, el hotel está ambientado con antigüedades. La calidad del desayuno está acorde al precio y la pileta también es un punto a favor. En resumen, volvería a alojarme en este hotel.–User, abril 2012
No dudamos en hospedarnos acá cada vez que visitamos Puerto Varas. Es un hotel cómodo, tranquilo, limpio, con piscina temperada, buenos alimentos, etc. Nada mejor que la tranquilidad de este hotel. ¡Lo amamos!–Pau, octubre 2012

Para visitar

Si vienes al Borde Lago, aprovecha de dar una vuelta por atractivos turísticos cercanos y disfruta de los lugares que se mencionan en esta pequeña guía:

Saltos del Petrohué

A unos 60 kilómetros de Puerto Varas, los Saltos del Petrohué representan el punto más atractivo del Parque Nacional Vicente Pérez Rosales. Sus cascadas naturales, la vegetación selvática y exhuberante y una vista inmejorable de los volcanes Osorno y Calbuco, lo ratifican como uno de los lugares más bellos de la Región de Los Lagos.

Iglesia del Sagrado Corazón
Una de las edificaciones más llamativas y admiradas de Puerto Varas, esta iglesia de estilo neobarroco fue declarada Monumento Histórico Nacional y recibe a diario la visita tanto de fieles como de curiosos que detienen su camino para contemplar sus amplias bóvedas, formidables revestimientos y su inspiradora fachada. Una verdadera referencia patrimonial de la ciudad.

Centro Cultural Estación

Punto de interés imperdible en la ciudad, en este museo se conserva una parte importante de la historia de los ferrocarriles que algún día surcaron a lo largo del valle longitudinal hasta Puerto Montt. Hay exposiciones permanentes e itinerantes, y la oportunidad de conocer algo más de la historia de la ciudad.

Ensenada
Ubicada al sureste del Lago Llanquihue, Ensenada reúne condiciones turísticas que pocas zonas del mundo poseen. La belleza del paisaje y la variada geografía y vegetación, convierten a este sector en una zona para realizar distintas actividades: trekking, montañismo, rafting, kayak, widsurf, cabalgatas, canopy y esquí, son solo algunas de ellas. Sin duda un punto obligado a visitar con la cercanía que te ofrece este Groupon.

Guía Groupon para regalos clásicos del Día de la Madre

Año tras año, el Día de la Madre es una de las fechas más ansiosamente esperadas por madres, hijos y la industria de los macarrones. A continuación mostramos algunas de las manualidades que más se regalan en esta fecha junto con sus pros, sus contras y la edad máxima aceptada (E.M.A.) del hijo.

Collar de macarrones
E.M.A.: 8 discutibles años.
Por qué sí: porque se pueden encontrar macarrones en cualquier parte y es fácil de hacer.
Por qué no: porque se pueden encontrar macarrones en cualquier parte y es fácil de hacer.
Mejor: un collar de no-macarrones. O cualquier joya que no tenga macarrones. O cualquier cosa que no conlleve pasta cruda.

Foto familiar en portarretrato de cartulina
E.M.A.: 18 años en general. 40 años para estudiantes de arte.
Por qué sí: porque una foto familiar nunca falla (a menos que sea de otra familia).
Por qué no: porque la cartulina envía señales confusas acerca de qué tan importante es la foto.
Mejor: un cuadro renacentista. La confusión hará que nadie piense en el tipo de marco.

Piedra pintada
E.M.A.: 3 dubitativos añitos.
Por qué sí: porque es una demostración artística con un valor sentimental invaluable que trascenderá nociones económicas y barreras temporales para pervivir en el corazón de quien la reciba.
Por qué no: porque es una piedra con un poco de témpera encima.
Mejor: idealmente un huevo de Fabergé. Si no es posible, un día de spa podría compensarlo.

Demuéstrame que existes.



Hotel Borde Lago
Visitar página
Camino a Ensenada km 4, Puerto Varas
Tel. (65) 438 999
contacto@bordelago.com
Reservas: Lun a vie de 09:00 a 18:30
Otros Groupones hoy
Ver todos los Groupones
305 cache queries, total size of 2,945,007 (Writes: 4, Reads: 247, Local reads: 54)
NrQueryTypeConfigServerSuccessSize
1localeCountryData.bd398d93c49167ed8221e1e09a598200readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE330
2getLocations.36aceeeeb22861095d29ac39daa2a757readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE59103
3getCities.099b16b94d8670ab53a3e075f2e61215readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19668
4getCountriesreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19524
5defaultLocation.bd398d93c49167ed8221e1e09a598200readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE30
6_v_defaultLocation.bd398d93c49167ed8221e1e09a598200readdefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
7defaultLocation.bd398d93c49167ed8221e1e09a598200writedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE30
8special_campaigns.1191fb1de6144174d5668273af50ed90readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE98
9_e_special_campaign1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE74
10_v_special_campaigns.1191fb1de6144174d5668273af50ed90readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15384
11SlugDeal.e3a2bdabe38ad453ce121b48aafb2de4readdefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
12_e_New_Deal1000058428readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
13_e_company6816readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
14_v_SlugDeal.e3a2bdabe38ad453ce121b48aafb2de4write5hourmemcached://latam-memcache-default-vip.snc1:11211TRUE11961
15SlugDeal.e3a2bdabe38ad453ce121b48aafb2de4write5hourmemcached://latam-memcache-default-vip.snc1:11211TRUE170
16getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
17getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
18getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
19getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
20SlugDeal.e3a2bdabe38ad453ce121b48aafb2de4read_localdefaultTRUE170
21_e_New_Deal1000058428read_localentitiesTRUE75
22_e_company6816read_localentitiesTRUE67
23_v_SlugDeal.e3a2bdabe38ad453ce121b48aafb2de4read_localdefaultTRUE11961
24_Deal.073c841db677e16aa1519f6f607ab226readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
25_e_New_Deal1002645013readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
26_e_company137656readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
27_v__Deal.073c841db677e16aa1519f6f607ab226readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19544
28_Deal.c23ba2c8c81ecfb12ff88c9f531cdd29readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
29_e_New_Deal1002641466readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
30_e_company136556readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
31_v__Deal.c23ba2c8c81ecfb12ff88c9f531cdd29readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE10643
32_Deal.5783699d7c4d4231d02a02cc69f9e405readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
33_e_New_Deal1002641137readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
34_e_company2985readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
35_v__Deal.5783699d7c4d4231d02a02cc69f9e405readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE13126
36_Deal.de17128dabd6b967fb42d332a3f7cc8areaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
37_e_New_Deal1002645035readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
38_e_company15662readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
39_v__Deal.de17128dabd6b967fb42d332a3f7cc8areaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE14852
40_Deal.3772ddbfa5b83bdab365efe9416e2aacreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
41_e_New_Deal1002641849readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
42_e_company93355readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
43_v__Deal.3772ddbfa5b83bdab365efe9416e2aacreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15420
44_Deal.8c45d2dc0171b1db4db13748ceaf078breaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
45_e_New_Deal1002637237readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
46_e_company132209readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
47_v__Deal.8c45d2dc0171b1db4db13748ceaf078breaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19587
48_Deal.d5eb26815778e6f6f1bf66dd226c36b2readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
49_e_New_Deal1002628947readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
50_e_company1938readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
51_v__Deal.d5eb26815778e6f6f1bf66dd226c36b2readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE9506
52_Deal.b55cf0d976bd7383b3633a67b9d0ac3ereaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
53_e_New_Deal1002597182readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
54_e_company137033readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
55_v__Deal.b55cf0d976bd7383b3633a67b9d0ac3ereaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE16178
56_Deal.d53d2c5628a94cec55548668ce95adb0readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
57_e_New_Deal1002650578readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
58_e_company137722readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
59_v__Deal.d53d2c5628a94cec55548668ce95adb0readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE14624
60_Deal.fd65d68ef3928de2697d8902f7e2d6bbreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
61_e_New_Deal1002616643readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
62_e_company2633readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
63_v__Deal.fd65d68ef3928de2697d8902f7e2d6bbreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE16082
64_Deal.8ac3433284cd104a91aa79a0ecea2ccfreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
65_e_New_Deal1002589373readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
66_e_company125843readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
67_v__Deal.8ac3433284cd104a91aa79a0ecea2ccfreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18844
68_Deal.9d68defaeac9a60602d974bb686c3abcreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
69_e_New_Deal1002624956readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
70_e_company110657readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
71_v__Deal.9d68defaeac9a60602d974bb686c3abcreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18518
72_Deal.a6f1f92feda00409d6f3547388ebda80readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE169
73_e_New_Deal1002646708readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
74_e_company911readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE66
75_v__Deal.a6f1f92feda00409d6f3547388ebda80readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18205
76_Deal.408726447f6abbb4fdf124a521e5656creaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
77_e_New_Deal1002641801readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
78_e_company100847readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
79_v__Deal.408726447f6abbb4fdf124a521e5656creaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE20353
80_Deal.28d6e48e100df60bce7353a43de293b6readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
81_e_New_Deal1002621349readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
82_e_company73331readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
83_v__Deal.28d6e48e100df60bce7353a43de293b6readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19316
84_Deal.39d0ad747b87c47bd8032cf7c19bb02areaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
85_e_New_Deal1002641486readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
86_e_company103171readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
87_v__Deal.39d0ad747b87c47bd8032cf7c19bb02areaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17003
88_Deal.141b52f58c5ac1e7a9466548a2a24e9dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
89_e_New_Deal1002612408readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
90_e_company16394readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
91_v__Deal.141b52f58c5ac1e7a9466548a2a24e9dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19634
92_Deal.cfa5b12eff65845f484273a620578462readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
93_e_New_Deal1002641055readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
94_e_company12976readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
95_v__Deal.cfa5b12eff65845f484273a620578462readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17639
96_Deal.29adfb562af00e48b61863be4c0b65a2readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
97_e_New_Deal1002640931readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
98_e_company7018readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
99_v__Deal.29adfb562af00e48b61863be4c0b65a2readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17568
100_Deal.b79066f49a9375f47b6143fa86d94d97readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
101_e_New_Deal1002589326readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
102_e_company119155readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
103_v__Deal.b79066f49a9375f47b6143fa86d94d97readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15296
104_Deal.10e81a0345649a127c313372c11a25d9readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
105_e_New_Deal1002641827readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
106_e_company136913readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
107_v__Deal.10e81a0345649a127c313372c11a25d9readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17580
108_Deal.9d68edf00323732d656e7b4c24987b11readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
109_e_New_Deal1002641663readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
110_e_company128639readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
111_v__Deal.9d68edf00323732d656e7b4c24987b11readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE16514
112_Deal.8019236efd758413d43c0845bfef8167readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
113_e_New_Deal1002606064readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
114_e_company130027readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
115_v__Deal.8019236efd758413d43c0845bfef8167readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18177
116_Deal.7de4266010497f74b7b8f61e101a084breaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
117_e_New_Deal1002631473readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
118_e_company106281readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
119_v__Deal.7de4266010497f74b7b8f61e101a084breaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18548
120_Deal.8fde688311718e83d2c1f96734b0365dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
121_e_New_Deal1002641841readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
122_e_company114695readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
123_v__Deal.8fde688311718e83d2c1f96734b0365dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15641
124_Deal.324c8df9b9d074f6548c2c193cc7fdaereaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
125_e_New_Deal1002641856readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
126_e_company132559readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
127_v__Deal.324c8df9b9d074f6548c2c193cc7fdaereaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE20306
128_Deal.ca6fe1d74a7c68c9f17d5dace99931d5readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
129_e_New_Deal1002641814readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
130_e_company131867readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
131_v__Deal.ca6fe1d74a7c68c9f17d5dace99931d5readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17609
132_Deal.52a21463452f9d584ff98278cd50cf8freaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
133_e_New_Deal1002641685readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
134_e_company100291readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
135_v__Deal.52a21463452f9d584ff98278cd50cf8freaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18103
136_Deal.82d5e81d4b6ae76a53402f5c78e631e3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
137_e_New_Deal1002641879readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
138_e_company3207readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
139_v__Deal.82d5e81d4b6ae76a53402f5c78e631e3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17162
140_Deal.e4d0123ec5c58579129e142c028f84c7readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
141_e_New_Deal1002641700readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
142_e_company134029readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
143_v__Deal.e4d0123ec5c58579129e142c028f84c7readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17229
144_Deal.5218fbc9fc278f9a094bb3d16751dc7dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE169
145_e_New_Deal1002641794readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
146_e_company200readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE66
147_v__Deal.5218fbc9fc278f9a094bb3d16751dc7dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17032
148_Deal.fa5219058b0ea8378a087e4ff1bb1a30readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
149_e_New_Deal1002642190readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
150_e_company136322readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
151_v__Deal.fa5219058b0ea8378a087e4ff1bb1a30readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18862
152_Deal.7a07c7dc692d08c105881e9f0fb607f3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
153_e_New_Deal1002642357readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
154_e_company136323readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
155_v__Deal.7a07c7dc692d08c105881e9f0fb607f3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15417
156_Deal.b4217ee7b2167dac6504e3aa4d1c1f34readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
157_e_New_Deal1002642375readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
158_e_company135956readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
159_v__Deal.b4217ee7b2167dac6504e3aa4d1c1f34readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19196
160_Deal.c81f989d86f7f4203d9de4a8f40af96breaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
161_e_New_Deal1002641674readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
162_e_company117359readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
163_v__Deal.c81f989d86f7f4203d9de4a8f40af96breaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE16995
164_Deal.620e06f7aaa2797154997cd76ceec6bfreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
165_e_New_Deal1002642218readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
166_e_company1154readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
167_v__Deal.620e06f7aaa2797154997cd76ceec6bfreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19940
168_Deal.912af396de61abc6985aae101924abb1readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
169_e_New_Deal1002642177readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
170_e_company136409readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
171_v__Deal.912af396de61abc6985aae101924abb1readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17522
172_Deal.a4aa73a7613b1b153ce6d398295c1b10readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
173_e_New_Deal1002641891readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
174_e_company133399readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
175_v__Deal.a4aa73a7613b1b153ce6d398295c1b10readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE14399
176_Deal.7bbf624d8f8556b8c8801e2a616c5a45readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
177_e_New_Deal1002580255readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
178_e_company136713readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
179_v__Deal.7bbf624d8f8556b8c8801e2a616c5a45readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE14477
180_Deal.2a9e83096eec4bf396495fc6e568b8dfreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
181_e_New_Deal1002589309readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
182_e_company130624readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
183_v__Deal.2a9e83096eec4bf396495fc6e568b8dfreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15723
184_Deal.f552ca3a41d9e1f3bcb87ebd5310c05creaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
185_e_New_Deal1002611629readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
186_e_company117255readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
187_v__Deal.f552ca3a41d9e1f3bcb87ebd5310c05creaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15727
188_Deal.ad3239ab83cf04d4300280b893277509readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
189_e_New_Deal1002589291readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
190_e_company136257readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
191_v__Deal.ad3239ab83cf04d4300280b893277509readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE16029
192_Deal.b0f176fe298c23cb75b1406433044e7dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
193_e_New_Deal1002589244readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
194_e_company66837readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
195_v__Deal.b0f176fe298c23cb75b1406433044e7dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE14269
196_Deal.243bc9784ab78bf511af7ad2a838a459readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
197_e_New_Deal1002571641readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
198_e_company136163readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
199_v__Deal.243bc9784ab78bf511af7ad2a838a459readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17000
200_Deal.71d578085f0556dadcccf9595fbe82a8readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE170
201_e_New_Deal1002579316readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
202_e_company1686readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
203_v__Deal.71d578085f0556dadcccf9595fbe82a8readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15164
204_Deal.843f0ef012e5e63d9bd979b7cc77adf3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
205_e_New_Deal1002621366readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
206_e_company137435readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
207_v__Deal.843f0ef012e5e63d9bd979b7cc77adf3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15505
208_Deal.2b8712f5d79b94d28829ee41a550576creaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
209_e_New_Deal1002624641readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
210_e_company135743readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
211_v__Deal.2b8712f5d79b94d28829ee41a550576creaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15672
212_Deal.6a7be028e217c6008dc96b0e1b31cff1readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
213_e_New_Deal1002625327readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
214_e_company134238readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
215_v__Deal.6a7be028e217c6008dc96b0e1b31cff1readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE13245
216_Deal.cd273446a50329e01c31bf7085be20b5readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
217_e_New_Deal1002627090readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
218_e_company14090readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE68
219_v__Deal.cd273446a50329e01c31bf7085be20b5readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19925
220_Deal.0a237a4b406dbaedb32dbdad99f8a510readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
221_e_New_Deal1002624691readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
222_e_company121311readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
223_v__Deal.0a237a4b406dbaedb32dbdad99f8a510readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17455
224_Deal.0ed30c910de67be66800ddfa59db4b14readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
225_e_New_Deal1002624664readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
226_e_company107481readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
227_v__Deal.0ed30c910de67be66800ddfa59db4b14readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE21467
228_Deal.a799779e20a8f9559b20ba958b0b75f3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
229_e_New_Deal1002624645readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
230_e_company123859readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
231_v__Deal.a799779e20a8f9559b20ba958b0b75f3readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE16977
232_Deal.de9532dc32e70f122e4a6fc083bea1e6readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE172
233_e_New_Deal1002641651readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
234_e_company134992readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
235_v__Deal.de9532dc32e70f122e4a6fc083bea1e6readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE17660
236DealsAddress.9dbee94af981d21d32b15d4932981c0dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE124
237_e_DealsAddress1000058428readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE80
238DealChilds.4fe82438fc60ff9cf7dbed53caafc779readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE100
239_e_dealChild1000058428readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE76
240_v_DealChilds.4fe82438fc60ff9cf7dbed53caafc779readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19162
241getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
242getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
243DealImage.1a05f283590b79bd1ad59ad5b0fca267readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE106
244_e_DealImage.deal1000058428readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE82
245_v_DealImage.1a05f283590b79bd1ad59ad5b0fca267readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19976
246DealDescription.b7592c364c7da3eb64042ede590b7988readdefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
247_e_DealDescription.deal1000058428readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE88
248DealDescription.b7592c364c7da3eb64042ede590b7988writedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE132
249hasChilds.9dbee94af981d21d32b15d4932981c0dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE111
250_e_hasChild1000058428readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE75
251hasChilds.9dbee94af981d21d32b15d4932981c0dread_localdefaultTRUE111
252_e_hasChild1000058428read_localentitiesTRUE75
253getExtension.8a28bbb02495a9e44239e37c83a9b825read5hourmemcached://latam-memcache-default-vip.snc1:11211FALSE0
254TodayGrouponSays.d98840b3118fabcec57612aafc595c2freaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
255_e_GrouponSays2015-05-22readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE79
256_e_Country1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE64
257_v_TodayGrouponSays.d98840b3118fabcec57612aafc595c2freaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE2342
258Banner.97b7a2664d8899d94e8234125279bc56readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE1278
259_e_Banner.country1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE72
260_e_Banner.brand1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE70
261_e_Banner.typeclandescuento-side-dealreadentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE92
262getCountriesread_localdefaultTRUE19524
263getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
264getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
265DealChilds.9dbee94af981d21d32b15d4932981c0dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE100
266_e_dealChild1000058428read_localentitiesTRUE76
267_v_DealChilds.9dbee94af981d21d32b15d4932981c0dreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE19162
268getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
269getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
270getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
271getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
272getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
273getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
274getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
275getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
276getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
277getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
278getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
279getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
280getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
281getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
282getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
283getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
284getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
285getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
286getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
287getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
288getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
289getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
290getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
291getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
292getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
293getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
294getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
295getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
296getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
297getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
298getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
299getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
300getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
301getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
302getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
303getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
304getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
305getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
(default) 12 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`default_slug` FROM `countries` AS `Country` WHERE `Country`.`code` = 'CL' LIMIT 1110
2SELECT `City`.*, `Country`.*, `Currency`.*, `Location`.* FROM `cities` AS `City` LEFT JOIN locations AS `Location` ON (`Location`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`City`.`country_id` = `Country`.`id`) LEFT JOIN `currencies` AS `Currency` ON (`City`.`currency_id` = `Currency`.`id`) WHERE `Country`.`code` = 'CL' AND `Location`.`slug` = 'las-condes' LIMIT 1111
3SELECT `Deal`.`id`, `Deal`.`brand_id`, `Deal`.`status`, `Deal`.`date`, `Deal`.`deal_type_id`, `Deal`.`parent_deal_id`, `Deal`.`country_id`, `Deal`.`city_id`, `Deal`.`type`, `Deal`.`type2`, `Deal`.`local`, `Deal`.`value`, `Deal`.`discount`, `Deal`.`final_price`, `Deal`.`reward`, `Deal`.`title`, `Deal`.`short_title`, `Deal`.`coupon_title`, `Deal`.`nl_title`, `Deal`.`slug`, `Deal`.`remark`, `Deal`.`description`, `Deal`.`due_date`, `Deal`.`details`, `Deal`.`company_id`, `Deal`.`picture`, `Deal`.`contract`, `Deal`.`tipping_point`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`sold_qty`, `Deal`.`expiration_date`, `Deal`.`redeem_at`, `Deal`.`max_coupons`, `Deal`.`shipping`, `Deal`.`expiration_alert`, `Deal`.`shipping_data`, `Deal`.`shipping_weight`, `Deal`.`shipping_long`, `Deal`.`shipping_height`, `Deal`.`shipping_width`, `Deal`.`shipping_content`, `Deal`.`shipping_delivery`, `Deal`.`shipping_contact`, `Deal`.`shipping_contact_address`, `Deal`.`shipping_contact_position`, `Deal`.`shipping_contact_phone`, `Deal`.`shipping_contact_email`, `Deal`.`shipping_courier`, `Deal`.`shipping_partner_price`, `Deal`.`shipping_total_price`, `Deal`.`shipping_client_price`, `Deal`.`commission`, `Deal`.`commission_tax`, `Deal`.`applicable_tax`, `Deal`.`seller_id`, `Deal`.`init_coupons`, `Deal`.`highlights`, `Deal`.`redeem_type`, `Deal`.`importance`, `Deal`.`salesforce_id`, `Deal`.`so_salesforce_id`, `Deal`.`additional_info`, `Deal`.`max_coupons_per_buy`, `Deal`.`settlements_fromMG`, `Deal`.`partner_country`, `Deal`.`partner_original_price`, `Deal`.`partner_special_price`, `Deal`.`flash_time`, `Deal`.`deal_addon`, `Deal`.`category_id`, `Deal`.`restricted`, `Deal`.`mulligan`, `Deal`.`mulligan_days`, `Deal`.`mulligan_time`, `Deal`.`extend_from_id`, `Deal`.`shipping_ended_date`, `Deal`.`shipping_ended_address`, `Deal`.`shipping_ended_name`, `Deal`.`shipping_ended_hours`, `Deal`.`shipping_delivery_date`, `Deal`.`shipping_real_delivery_date`, `Deal`.`shipping_product_delivery_date`, `Deal`.`shipping_real_product_delivery_date`, `Deal`.`shipping_delivery_zone_id`, `Deal`.`instant_sending`, `Deal`.`sending_coupons`, `Deal`.`sync_additional_info`, `Deal`.`stock_management`, `Deal`.`mg_partner_id`, `Deal`.`permalink`, `Country`.`id`, `Country`.`name`, `Country`.`slug`, `Country`.`code`, `Country`.`url`, `Country`.`default_slug`, `Country`.`facebook_id`, `Country`.`facebook_path`, `Country`.`twitter_id`, `Country`.`phone_country`, `Country`.`active`, `Country`.`analytics`, `Country`.`support_address`, `Country`.`address`, `Country`.`tz`, `Country`.`conversion`, `Country`.`rewards`, `Country`.`scheduler_url`, `City`.`id`, `City`.`country_id`, `City`.`currency_id`, `City`.`act_as_city_id`, `City`.`name`, `City`.`slug`, `City`.`time_offset`, `City`.`launch_date`, `City`.`lat`, `City`.`lng`, `City`.`facebook_id`, `City`.`facebook_path`, `City`.`twitter_id`, `City`.`timezone`, `Company`.`id`, `Company`.`name`, `Company`.`description`, `Company`.`website`, `Company`.`logo_url`, `Company`.`contract_rut`, `Company`.`contract_name`, `Company`.`contract_type`, `Company`.`contract_address`, `Company`.`contract_city`, `Company`.`contract_contact`, `Company`.`bank_rut`, `Company`.`bank_name`, `Company`.`bank_name2`, `Company`.`bank_account_holder`, `Company`.`bank_account_number`, `Company`.`payment_method`, `Company`.`created`, `Company`.`modified`, `Company`.`membership_info`, `DealsExtraData`.`id`, `DealsExtraData`.`deal_id`, `DealsExtraData`.`init_coupon_date`, `DealsExtraData`.`created`, `DealsExtraData`.`modified`, `DealsExtraData`.`gender_code`, `DealsExtraData`.`template_deal_id`, `DealsExtraData`.`sharing_stock`, `DealsExtraData`.`dealbank_status`, `DealsExtraData`.`business_unit`, `DealsExtraData`.`coupon_duration`, `DealsExtraData`.`reviews` FROM `deals` AS `Deal` LEFT JOIN `countries` AS `Country` ON (`Deal`.`country_id` = `Country`.`id`) LEFT JOIN `cities` AS `City` ON (`Deal`.`city_id` = `City`.`id`) LEFT JOIN `companies` AS `Company` ON (`Deal`.`company_id` = `Company`.`id`) LEFT JOIN `deals_extra_data` AS `DealsExtraData` ON (`DealsExtraData`.`deal_id` = `Deal`.`id`) WHERE `Deal`.`slug` = 'paga-desde-67000-por-2-3-o-5-noches-para-dos-desayuno-buffet-acceso-a-piscina-cubierta-en-hotel-borde-lago-puerto-va-1' AND `Deal`.`brand_id` = 1 ORDER BY `Deal`.`date` DESC LIMIT 1112
4SELECT `DealsFunnyPhrase`.`id`, `DealsFunnyPhrase`.`funny_phrase_id`, `DealsFunnyPhrase`.`deal_template_id`, `DealsFunnyPhrase`.`deal_run_id`, `DealsFunnyPhrase`.`date_deal`, `DealsFunnyPhrase`.`created`, `DealsFunnyPhrase`.`modified` FROM `deals_funny_phrases` AS `DealsFunnyPhrase` WHERE `DealsFunnyPhrase`.`deal_template_id` = (1000058428) 000
5SELECT `DealsAddress`.`id`, `DealsAddress`.`deal_id`, `DealsAddress`.`country_id`, `DealsAddress`.`city_id`, `DealsAddress`.`location_id`, `DealsAddress`.`address`, `DealsAddress`.`lat`, `DealsAddress`.`lng`, `DealsAddress`.`created` FROM `deals_address` AS `DealsAddress` WHERE `DealsAddress`.`deal_id` = (1000058428) 000
6SELECT `DealDescription`.`id`, `DealDescription`.`deal_id`, `DealDescription`.`title`, `DealDescription`.`text`, `DealDescription`.`created`, `Deal`.`id`, `Deal`.`brand_id`, `Deal`.`status`, `Deal`.`date`, `Deal`.`deal_type_id`, `Deal`.`parent_deal_id`, `Deal`.`country_id`, `Deal`.`city_id`, `Deal`.`type`, `Deal`.`type2`, `Deal`.`local`, `Deal`.`value`, `Deal`.`discount`, `Deal`.`final_price`, `Deal`.`reward`, `Deal`.`title`, `Deal`.`short_title`, `Deal`.`coupon_title`, `Deal`.`nl_title`, `Deal`.`slug`, `Deal`.`remark`, `Deal`.`description`, `Deal`.`due_date`, `Deal`.`details`, `Deal`.`company_id`, `Deal`.`picture`, `Deal`.`contract`, `Deal`.`tipping_point`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`sold_qty`, `Deal`.`expiration_date`, `Deal`.`redeem_at`, `Deal`.`max_coupons`, `Deal`.`shipping`, `Deal`.`expiration_alert`, `Deal`.`shipping_data`, `Deal`.`shipping_weight`, `Deal`.`shipping_long`, `Deal`.`shipping_height`, `Deal`.`shipping_width`, `Deal`.`shipping_content`, `Deal`.`shipping_delivery`, `Deal`.`shipping_contact`, `Deal`.`shipping_contact_address`, `Deal`.`shipping_contact_position`, `Deal`.`shipping_contact_phone`, `Deal`.`shipping_contact_email`, `Deal`.`shipping_courier`, `Deal`.`shipping_partner_price`, `Deal`.`shipping_total_price`, `Deal`.`shipping_client_price`, `Deal`.`commission`, `Deal`.`commission_tax`, `Deal`.`applicable_tax`, `Deal`.`seller_id`, `Deal`.`init_coupons`, `Deal`.`highlights`, `Deal`.`redeem_type`, `Deal`.`importance`, `Deal`.`salesforce_id`, `Deal`.`so_salesforce_id`, `Deal`.`additional_info`, `Deal`.`max_coupons_per_buy`, `Deal`.`settlements_fromMG`, `Deal`.`partner_country`, `Deal`.`partner_original_price`, `Deal`.`partner_special_price`, `Deal`.`flash_time`, `Deal`.`deal_addon`, `Deal`.`category_id`, `Deal`.`restricted`, `Deal`.`mulligan`, `Deal`.`mulligan_days`, `Deal`.`mulligan_time`, `Deal`.`extend_from_id`, `Deal`.`shipping_ended_date`, `Deal`.`shipping_ended_address`, `Deal`.`shipping_ended_name`, `Deal`.`shipping_ended_hours`, `Deal`.`shipping_delivery_date`, `Deal`.`shipping_real_delivery_date`, `Deal`.`shipping_product_delivery_date`, `Deal`.`shipping_real_product_delivery_date`, `Deal`.`shipping_delivery_zone_id`, `Deal`.`instant_sending`, `Deal`.`sending_coupons`, `Deal`.`sync_additional_info`, `Deal`.`stock_management`, `Deal`.`mg_partner_id`, `Deal`.`permalink` FROM `deal_descriptions` AS `DealDescription` LEFT JOIN `deals` AS `Deal` ON (`DealDescription`.`deal_id` = `Deal`.`id`) WHERE `DealDescription`.`deal_id` = 1000058428 001
7 SELECT Deal.id, Deal.extend_from_id, Deal.status, Deal.slug FROM deals Deal INNER JOIN cities AS City ON City.id = Deal.city_id WHERE Deal.status='ACTIVE' AND (Deal.date <= '2015-05-22' + INTERVAL City.time_offset SECOND AND Deal.due_date >= '2015-05-22' + INTERVAL City.time_offset SECOND) AND Deal.salesforce_id = '006C000000lOsRpIAK' ORDER BY Deal.date DESC LIMIT 1 000
8SELECT `DealbankCategoryName`.`name`, `DealbankCategoryName`.`slug` FROM `dealbank_categories` AS `DealbankCategory` INNER JOIN dealbank_category_names AS `DealbankCategoryName` ON (`DealbankCategoryName`.`dealbank_category_id` = `DealbankCategory`.`id` AND `DealbankCategoryName`.`country_id` = 1) INNER JOIN dealbank_categories_cities AS `DealbankCategoryCities` ON (`DealbankCategoryCities`.`dealbank_category_id` = `DealbankCategory`.`id` AND `DealbankCategoryCities`.`city_id` = 16) WHERE `DealbankCategory`.`business_unit` = 'travel' ORDER BY `DealbankCategory`.`order` ASC 000
9SELECT `DealCategory`.`id`, `DealCategory`.`parent_id`, `DealCategory`.`name`, `DealCategory`.`spanish_name`, `DealCategory`.`dealbank_category_id`, `DealCategory`.`guid` FROM `deal_categories` AS `DealCategory` WHERE `DealCategory`.`id` = 222 110
10SELECT name FROM deal_categories WHERE id = 220110
11SELECT Currency.*, City.id FROM currencies Currency LEFT JOIN cities AS City ON City.currency_id = Currency.id WHERE City.country_id = 114140
12SELECT `DealsExtraData`.`id`, `DealsExtraData`.`deal_id`, `DealsExtraData`.`init_coupon_date`, `DealsExtraData`.`created`, `DealsExtraData`.`modified`, `DealsExtraData`.`gender_code`, `DealsExtraData`.`template_deal_id`, `DealsExtraData`.`sharing_stock`, `DealsExtraData`.`dealbank_status`, `DealsExtraData`.`business_unit`, `DealsExtraData`.`coupon_duration`, `DealsExtraData`.`reviews`, `Deal`.`id`, `Deal`.`brand_id`, `Deal`.`status`, `Deal`.`date`, `Deal`.`deal_type_id`, `Deal`.`parent_deal_id`, `Deal`.`country_id`, `Deal`.`city_id`, `Deal`.`type`, `Deal`.`type2`, `Deal`.`local`, `Deal`.`value`, `Deal`.`discount`, `Deal`.`final_price`, `Deal`.`reward`, `Deal`.`title`, `Deal`.`short_title`, `Deal`.`coupon_title`, `Deal`.`nl_title`, `Deal`.`slug`, `Deal`.`remark`, `Deal`.`description`, `Deal`.`due_date`, `Deal`.`details`, `Deal`.`company_id`, `Deal`.`picture`, `Deal`.`contract`, `Deal`.`tipping_point`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`sold_qty`, `Deal`.`expiration_date`, `Deal`.`redeem_at`, `Deal`.`max_coupons`, `Deal`.`shipping`, `Deal`.`expiration_alert`, `Deal`.`shipping_data`, `Deal`.`shipping_weight`, `Deal`.`shipping_long`, `Deal`.`shipping_height`, `Deal`.`shipping_width`, `Deal`.`shipping_content`, `Deal`.`shipping_delivery`, `Deal`.`shipping_contact`, `Deal`.`shipping_contact_address`, `Deal`.`shipping_contact_position`, `Deal`.`shipping_contact_phone`, `Deal`.`shipping_contact_email`, `Deal`.`shipping_courier`, `Deal`.`shipping_partner_price`, `Deal`.`shipping_total_price`, `Deal`.`shipping_client_price`, `Deal`.`commission`, `Deal`.`commission_tax`, `Deal`.`applicable_tax`, `Deal`.`seller_id`, `Deal`.`init_coupons`, `Deal`.`highlights`, `Deal`.`redeem_type`, `Deal`.`importance`, `Deal`.`salesforce_id`, `Deal`.`so_salesforce_id`, `Deal`.`additional_info`, `Deal`.`max_coupons_per_buy`, `Deal`.`settlements_fromMG`, `Deal`.`partner_country`, `Deal`.`partner_original_price`, `Deal`.`partner_special_price`, `Deal`.`flash_time`, `Deal`.`deal_addon`, `Deal`.`category_id`, `Deal`.`restricted`, `Deal`.`mulligan`, `Deal`.`mulligan_days`, `Deal`.`mulligan_time`, `Deal`.`extend_from_id`, `Deal`.`shipping_ended_date`, `Deal`.`shipping_ended_address`, `Deal`.`shipping_ended_name`, `Deal`.`shipping_ended_hours`, `Deal`.`shipping_delivery_date`, `Deal`.`shipping_real_delivery_date`, `Deal`.`shipping_product_delivery_date`, `Deal`.`shipping_real_product_delivery_date`, `Deal`.`shipping_delivery_zone_id`, `Deal`.`instant_sending`, `Deal`.`sending_coupons`, `Deal`.`sync_additional_info`, `Deal`.`stock_management`, `Deal`.`mg_partner_id`, `Deal`.`permalink` FROM `deals_extra_data` AS `DealsExtraData` LEFT JOIN `deals` AS `Deal` ON (`DealsExtraData`.`deal_id` = `Deal`.`id`) WHERE `DealsExtraData`.`deal_id` IS NULL LIMIT 1001