Notice (8): Undefined index:  DealTemplate [APP/controllers/deals_controller.php, line 586]
Paga desde $30.900 por sesión de lipoescultura con Clínica Smer en IOPA - 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 $30.900 por sesión de lipoescultura con Clínica Smer en IOPA

Desde:
$30.900
 
Referencia
$100.000
Beneficio
69%
Ahorras
$69.100
Este Groupon caducó el:
6 de Octubre de 2011
Paga desde $30.900 por sesión de lipoescultura con Clínica Smer en IOPA

Destacados

Una zona a elección entre abdomen, flancos o glúteos. Incluye drenaje linfático. Realizada con equipo Medcontour, ganador de la medalla de oro en el evento InterBeauty Praga 2010. Se puede reducir entre 3 y 6 cm. Resultados visibles desde la primera sesión.

Letra chica

Para mayores de 18 años. Menores de edad deberán contar con autorización de los padres y/o tutor legal. Horario de atención: lun a vie de 10:00 a 20:00 hrs. Reservas y cancelaciones con mínimo de 24 horas. Un Groupon por persona.
El Groupon se puede utilizar desde el 6 de Octubre de 2011 hasta el 6 de Enero de 2012
Caminar de un lado para otro en la pieza es un gesto reflejo que comparten personas afectadas por una enorme preocupación, quienes no tienen muy claro hacia dónde ir en la vida y los que aún sueñan con desfilar como modelos por una pasarela. El Groupon de hoy es para que dejes de imaginar y te decidas. En Clínica Smer paga desde $30.900 por sesiones de lipoescultura y drenaje linfático con el equipo MedContour. Elige entre: • Una sesión de lipoescultura más un de drenaje linfático ($30.900 en vez de $100.000) • Tres sesiones de lipoescultura más tres de drenaje linfático ($75.900 en vez de $300.000) • Seis sesiones de lipoescultura más seis de drenaje linfático ($134.900 en vez de $600.000) Clínica Smer es la sigla para Sociedad de Medicina Estética Reparatoria y de Rejuvenecimiento, que en conjunto con la Clínica IOPA ofrece 1, 3 o 6 sesiones de lipoescultura con drenaje linfático, realizadas con el equipo MedContour. El procedimiento se puede aplicar en la zona del abdomen, flancos o glúteos. El equipo MedContour usa un sistema cavitacional con la acción de 2 ultrasonidos para la reducción de la adiposidad localizada y la celulitis. Así se van rompiendo las células grasas que, posteriormente, son eliminadas gracias a la aplicación del drenaje linfático, en un procedimiento indoloro desarrollado por kinesiólogas. Estas sesiones se deben realizar una vez a la semana. Para que el cuerpo logre un bienestar físico e integral, esta clínica ofrece servicios dermatológicos, peeling faciales y la eliminación de tatuajes, entre otros. También cuenta con una línea corporal en la que se ofrecen tratamientos contra la celulitis, reafirmantes y de ultracavitación, entre otros.

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.



Clínica Smer de IOPA
Visitar página
Av. Los Leones 220 local 3 y 4, Providencia
(02) 2 233 0899, (9) 9 50146157 , (9) 9 50146157
80 cache queries, total size of 1,137,133 (Writes: 16, Reads: 32, Local reads: 32)
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.5a842b9bc9b2f07cd6cedb5d162194ffreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE98
9_e_special_campaign1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE74
10_v_special_campaigns.5a842b9bc9b2f07cd6cedb5d162194ffreaddefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE15384
11SlugDeal.58600bc912fc001c72b6fb678310710freaddefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
12_e_New_Deal13293readentitiesmemcached://latam-memcache-entities-vip.snc1:11213FALSE0
13_e_New_Deal13293writeentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
14_e_company2991readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE67
15_v_SlugDeal.58600bc912fc001c72b6fb678310710fwrite5hourmemcached://latam-memcache-default-vip.snc1:11211TRUE7954
16SlugDeal.58600bc912fc001c72b6fb678310710fwrite5hourmemcached://latam-memcache-default-vip.snc1:11211TRUE164
17getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
18getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
19getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
20getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
21SlugDeal.58600bc912fc001c72b6fb678310710fread_localdefaultTRUE164
22_e_New_Deal13293read_localentitiesTRUE69
23_e_company2991read_localentitiesTRUE67
24_v_SlugDeal.58600bc912fc001c72b6fb678310710fread_localdefaultTRUE7954
25DealsAddress.79681784370a2916b00ddd68652be91freaddefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
26_e_DealsAddress13293readentitiesmemcached://latam-memcache-entities-vip.snc1:11213FALSE0
27_e_DealsAddress13293writeentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE74
28DealsAddress.79681784370a2916b00ddd68652be91fwritedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE118
29DealChilds.d58e92cf1c894603494c683296eaa57creaddefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
30_e_dealChild13293readentitiesmemcached://latam-memcache-entities-vip.snc1:11213FALSE0
31_e_dealChild13293writeentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE70
32_v_DealChilds.d58e92cf1c894603494c683296eaa57cwritedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18084
33DealChilds.d58e92cf1c894603494c683296eaa57cwritedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE94
34getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
35getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
36DealImage.0861bce825301b0ccbd7ceefc8135da3readdefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
37_e_DealImage.deal13293readentitiesmemcached://latam-memcache-entities-vip.snc1:11213FALSE0
38_e_DealImage.deal13293writeentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE76
39DealImage.0861bce825301b0ccbd7ceefc8135da3writedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE120
40DealDescription.fc16eff44952dc61f4aac88ae8c863d4readdefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
41_e_DealDescription.deal13293readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE82
42DealDescription.fc16eff44952dc61f4aac88ae8c863d4writedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE126
43hasChilds.79681784370a2916b00ddd68652be91freaddefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
44_e_hasChild13293readentitiesmemcached://latam-memcache-entities-vip.snc1:11213FALSE0
45_e_hasChild13293writeentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE69
46hasChilds.79681784370a2916b00ddd68652be91fwritedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE105
47hasChilds.79681784370a2916b00ddd68652be91fread_localdefaultTRUE105
48_e_hasChild13293read_localentitiesTRUE69
49getExtension.e548ae951eb15f655f6574447e6d8367read5hourmemcached://latam-memcache-default-vip.snc1:11211FALSE0
50TodayGrouponSays.408d179e38ec6f17ec1e09704bc7b4f4readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE171
51_e_GrouponSays2015-05-23readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE79
52_e_Country1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE64
53_v_TodayGrouponSays.408d179e38ec6f17ec1e09704bc7b4f4readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE2342
54Banner.97b7a2664d8899d94e8234125279bc56readdefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE1278
55_e_Banner.country1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE72
56_e_Banner.brand1readentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE70
57_e_Banner.typeclandescuento-side-dealreadentitiesmemcached://latam-memcache-entities-vip.snc1:11213TRUE92
58getCountriesread_localdefaultTRUE19524
59getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
60getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
61DealChilds.79681784370a2916b00ddd68652be91freaddefaultmemcached://latam-memcache-default-vip.snc1:11211FALSE0
62_e_dealChild13293read_localentitiesTRUE70
63_v_DealChilds.79681784370a2916b00ddd68652be91fwritedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE18084
64DealChilds.79681784370a2916b00ddd68652be91fwritedefaultmemcached://latam-memcache-default-vip.snc1:11211TRUE94
65getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
66getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
67getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
68getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
69getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
70getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
71getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
72getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
73getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
74getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
75getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
76getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
77getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
78getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
79getLocations.36aceeeeb22861095d29ac39daa2a757read_localdefaultTRUE59103
80getCities.099b16b94d8670ab53a3e075f2e61215read_localdefaultTRUE19668
(default) 34 queries took 26 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `deals`91914
2DESCRIBE `companies`20201
3DESCRIBE `deals_extra_data`12121
4DESCRIBE `deals_funny_phrases`771
5DESCRIBE `funny_phrases`771
6DESCRIBE `deals_address`991
7SELECT `Country`.`default_slug` FROM `countries` AS `Country` WHERE `Country`.`code` = 'CL' LIMIT 1110
8SELECT `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 1110
9SELECT `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-30900-por-sesion-de-lipoescultura-drenaje-linfatico-en-clinica-smer' AND `Deal`.`brand_id` = 1 ORDER BY `Deal`.`date` DESC LIMIT 1113
10SELECT `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` = (13293) 000
11SELECT `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` = (13293) 000
12DESCRIBE `city_options`221
13DESCRIBE `city_options_cities`440
14SELECT * FROM deals_address DealsAddress LEFT JOIN locations Location ON Location.id = DealsAddress.location_id LEFT JOIN cities City ON DealsAddress.city_id = City.id WHERE DealsAddress.deal_id = 13293000
15SELECT `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`.`parent_deal_id` = 13293 AND `Deal`.`status` IN ('ACTIVE', 'SENT', 'SENDING') ORDER BY `Deal`.`final_price` ASC, `Deal`.`id` ASC 332
16SELECT `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` IN (13295, 13297, 13299) 001
17SELECT `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` IN (13295, 13297, 13299) 000
18DESCRIBE `deal_images`661
19SELECT `DealImage`.`id`, `DealImage`.`deal_id`, `DealImage`.`path`, `DealImage`.`text`, `DealImage`.`order`, `DealImage`.`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_images` AS `DealImage` LEFT JOIN `deals` AS `Deal` ON (`DealImage`.`deal_id` = `Deal`.`id`) WHERE `DealImage`.`deal_id` = 13293 001
20DESCRIBE `deal_descriptions`550
21SELECT `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` = 13293 001
22SELECT COUNT(*) AS `count` 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`.`parent_deal_id` = 13293 110
23 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-23' + INTERVAL City.time_offset SECOND AND Deal.due_date >= '2015-05-23' + INTERVAL City.time_offset SECOND) AND Deal.salesforce_id = '006C000000lwb7QIAQ' ORDER BY Deal.date DESC LIMIT 1 000
24DESCRIBE `groupon_says`12121
25DESCRIBE `banners`11111
26SELECT `DealCategory`.`id`, `DealCategory`.`parent_id`, `DealCategory`.`name`, `DealCategory`.`spanish_name`, `DealCategory`.`dealbank_category_id`, `DealCategory`.`guid` FROM `deal_categories` AS `DealCategory` WHERE `DealCategory`.`id` = 46 110
27SELECT name FROM deal_categories WHERE id = 45110
28SELECT Currency.*, City.id FROM currencies Currency LEFT JOIN cities AS City ON City.currency_id = Currency.id WHERE City.country_id = 114140
29SELECT `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
30DESCRIBE `stock`991
31DESCRIBE `stock_categories`331
32SELECT `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`.`parent_deal_id` = 13293 AND `Deal`.`status` IN ('ACTIVE', 'SENT', 'SENDING') ORDER BY `Deal`.`final_price` ASC, `Deal`.`id` ASC 332
33SELECT `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` IN (13295, 13297, 13299) 000
34SELECT `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` IN (13295, 13297, 13299) 000